Diff for "désert/Symantec/NBU"

Step-by-step configuration of NetBackup for Microsoft SQL Server differential backups

https://www.veritas.com/support/en_US/article.000033118

Step-by-step procedure for using NetBackup to restore a Microsoft SQL Full Backup using a MOVE script

https://www.veritas.com/support/en_US/article.000033126

How to configure a NetBackup policy to protect Microsoft SQL databases?

http://www.settlersoman.com/how-to-configure-a-netbackup-policy-to-protect-microsoft-sql-databases/

NBU restore script

• recovery catalog (if used). At the rman command prompt, enter the following:

crosscheck backupset of database;

Use restore ... validate when you want RMAN to choose the backups to test.

NetBackup 7.7.1 AdministratorGuide => 131 to 138 pages

https://www.veritas.com/support/en_US/article.HOWTO64200

1. Make sure you have installed Oracle with the same user as used on the original source client machine

2. Install NetBackup Client and Oracle agent

3. Patch if needed

4. Touch the file on the master server: => /usr/openv/netbackup/db/altnames/No.Restrictions

5. Browse the Oracle backups by running /usr/openv/netbackup/bin/bplist -S <master server> - C <Oracle source client name> -t 4 -l -R /

   • => Make sure you can browse the backups

6. Restore the control file (in NOMOUNT mode) - See exact steps for this procedure in technote HOWTO63971

   • => SQL> STARTUP NOMOUNT rman nocatalog => RMAN> connect target => RMAN> SET DBID=XXXXXX

     • RMAN> restore controlfile from

7. Restore the database (in MOUNT mode)

   • RMAN> mount database

8. Restore the database using the script in /usr/openv/netbackup/ext/db_ext/oracle/samples/rman/database_restore.sh

RUN {
  ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
  ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
  SEND 'NB_ORA_SERV=<master server>, NB_ORA_CLIENT=<Oracle source client name>’;
  RESTORE DATABASE;
  RECOVER DATABASE;
  RELEASE CHANNEL ch00;
  RELEASE CHANNEL ch01;
} 

Troubleshooting

NetBackup 7.7.1 AdministratorGuide => 208 pages

https://www.veritas.com/support/en_US/article.HOWTO64200

1. Make sure you have installed Oracle with the same user as used on the original source client machine

2. Install NetBackup Client and Oracle agent

3. Patch if needed

4. Touch the file on the master server: => /usr/openv/netbackup/db/altnames/No.Restrictions

5. Browse the Oracle backups by running /usr/openv/netbackup/bin/bplist -S <master server> - C <Oracle source client name> -t 4 -l -R /

   • => Make sure you can browse the backups

6. Restore the control file (in NOMOUNT mode) - See exact steps for this procedure in technote HOWTO63971

   • => SQL> STARTUP NOMOUNT rman nocatalog => RMAN> connect target => RMAN> SET DBID=XXXXXX

     • RMAN> restore controlfile from

7. Restore the database (in MOUNT mode)

   • RMAN> mount database

8. Restore the database using the script in /usr/openv/netbackup/ext/db_ext/oracle/samples/rman/database_restore.sh

RUN {
  ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
  ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
  SEND 'NB_ORA_SERV=<master server>, NB_ORA_CLIENT=<Oracle source client name>’;
  RESTORE DATABASE;
  RECOVER DATABASE;
  RELEASE CHANNEL ch00;
  RELEASE CHANNEL ch01;
} 

Troubleshooting

/usr/openv/netbackup/logs/user_ops

The debug logs are located in /usr/openv/netbackup/logs .

To set the debug level on a UNIX client
Enter the following line in the bp.conf file.

VERBOSE = X

Where X is the debug level you want.

/usr/openv/netbackup/logs/user_ops

UNIX: /usr/openv/netbackup/logs/dbclient/log.mmddyy

The debug logs are located in /usr/openv/netbackup/logs .

To set the debug level on a UNIX client
Enter the following line in the bp.conf file.

VERBOSE = X

Where X is the debug level you want.