Restore oracle database with netbackup (RMAN)

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 > – C  -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

7. Restore the database (in MOUNT mode)

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

You will need to modify the restore script and add in the correct entries for following parameters:

ORACLE_HOME

ORACLE_SID

ORACLE_USER

TARGET_CONNECT_STR

The main section of the script should look like:

RUN {

ALLOCATE CHANNEL ch00 TYPE ‘SBT_TAPE’;

ALLOCATE CHANNEL ch01 TYPE ‘SBT_TAPE’;

SEND ‘NB_ORA_SERV=, NB_ORA_CLIENT=’;

RESTORE DATABASE;

RECOVER DATABASE;

RELEASE CHANNEL ch00;

RELEASE CHANNEL ch01;

}

The above will restore the last full backup known to RMAN and NetBackup

To run the script, simply on the destination client run:

./usr/openv/netbackup/ext/db_ext/oracle/samples/rman/database_restore.sh