1. Support
  2. Knowledge base
  3. 100037985

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

Article: 100037985
Last Published: 2025-09-25
Ratings: 24 7
Product(s): NetBackup

Description

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

 
1. Make sure to install Oracle with the same user that was used for the original source client machine.

2. Install the NetBackup Client and Oracle agent.
 
3. Patch if needed.
 
4. Create this touch file on the master server (remember to remove this file after the operation completes):
  • 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 the backups are browsable.
 
6. Restore the control file (in NOMOUNT mode)
  • The exact steps for this procedure are 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
  • 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