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;
https://www.veritas.com/support/en_US/article.HOWTO64200
- Make sure you have installed Oracle with the same user as used on the original source client machine
Install NetBackup Client and Oracle agent
- Patch if needed
Touch the file on the master server: => /usr/openv/netbackup/db/altnames/No.Restrictions
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
- 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
- Restore the database (in MOUNT mode)
RMAN> mount database
- 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;
}