1. Support
  2. Knowledge base
  3. 100037985

How to restore Oracle database to an alternate client machine using NetBackup

Article: 100037985
Last Published: 2021-02-18
Ratings: 29 7
Product(s): NetBackup & Alta Data Protection

Description

Summary of steps needed to be carried out on the alternate (destination) Oracle client machine:

 
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:
touch /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 article  100037984
 
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 the correct entries for the following parameters:
ORACLE_HOME
ORACLE_SID
ORACLE_USER
TARGET_CONNECT_STR

The main section of the script should look like this:

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;
}
 
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
 
 

Was this content helpful?

Article Languages