How to restore an Oracle backup from an AIR or other replication master domain

Problem

 When attempting to restore from a second Master server in a replicated AIR environment the restore fails.  
 

Error Message

 If the environment is not configured correctly the restore will error out with the following job details:

08/31/2013 15:31:56 - begin Restore 
08/31/2013 15:31:57 - restoring from image dbclient1_1377976445 
08/31/2013 15:31:57 - Info bprd (pid=1460) Restoring from copy 1 of image created Sat Aug 31 15:14:05 2013 
08/31/2013 15:31:57 - requesting resource @aaaab 
08/31/2013 15:31:57 - granted resource MediaID=@aaaab;DiskVolume=/ADV_DISK;DiskPool=DP_ADV_NBMASTER1;Path=/ADV_DISK;StorageServer=nbmaster1;MediaServer=nbmaster1 
08/31/2013 15:31:58 - Error bpbrm (pid=1475) bpcd on dbclient1 exited with status 59: access to the client was not allowed 
08/31/2013 15:31:58 - Info tar (pid=0) done. status: 59: access to the client was not allowed 
08/31/2013 15:31:58 - Error bpbrm (pid=1475) client restore EXIT STATUS 59: access to the client was not allowed 
08/31/2013 15:31:58 - restored from image dbclient1_1377976445; restore time: 0:00:01 
08/31/2013 15:31:58 - end Restore; elapsed time 0:00:02 
Oracle policy restore error (2801)

Cause

The client host must be configured to allow the master and media servers at both the production and AIR/DR site to have access to the client.
 

Solution

If the restores are being performed by using the Netbackup for Oracle Recovery Wizard perform the following steps:

Note:  Part of the steps below incorporate the recovery wizard restore steps from the Veritas NetBackup™ for Oracle Administrator's Guide pg 90-91.

1) Start the Backup, Archive, and Restore interface on the client host.

On UNIX and Linux, from the command line, run the following command:

/usr/openv/netbackup/bin/jbpSA &

On Windows, from the Windows Start menu, choose AllPrograms>Veritas NetBackup > Backup, Archive, and Restore.

2)  Change the policy type.

Perform this step if the Oracle node is not visible.

From the File menu (Windows) or Actions menu (UNIX and Linux), choose

3) For the Specify NetBackup Machines and Policy Type change the specify netbackup machines and policy type "server to use for backups and restores" to the other Master where the AIR replicated images reside.

4) On UNIX and Linux, click the Restore Files tab.

On Windows, click Select for Restore.

5) Expand the Oracle node in the left pane to view an Oracle instance hierarchy.

6) Select a node in the left pane to view details in the right pane.

7) In the right pane, select the database object(s) (data files, tablespaces) you want to recover.

If you select the Oracle instance, the wizard recovers the entire database using RMAN.

8) Click Actions > Restore.

Enter information about the recovery operation you want to perform in the screens that the NetBackup for Oracle recovery wizard displays.

The screens are as follows:

■ Welcome

■ Target Database Logon Credentials

■ Recovery Catalog Logon Credentials

■ Recovery Options

■ Restore Options

■ Recover Limits

■ Database State

If you need an explanation of any of the fields on the wizard screens, click

Help on the wizard screen.

9) When you have completed the wizard, the Selection Summary screen displays the summary of the recovery template. Review this summary. You can choose to run the template immediately after the wizard finishes or save the template locally, or both.

If you need an explanation of any of the fields on the wizard panels, click Help on the wizard panel.

10) Click Finish to run, to save, or to save the recovery template.  

11) Before you run the template, review the bp.conf file or registry settings on the client host to ensure that it will accept connections from the master and media server(s) at the AIR/DR site.  Add a SERVER entry for each host if not already present.

Note: If you are running RMAN on the client or using an RMAN script instead of a template the steps require that the environment variable for the Netbackup Master NB_ORA_SERV be set to the Master server with the AIR replicated image. 

For example an RMAN send statement can be executed:

RMAN> SEND 'NB_ORA_SERV=secondAIRMaster,NB_ORA_CLIENT=dbclient1';

The following example would be from an RMAN script:

RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=dbclient1,NB_ORA_SERV=secondAIRMaster';
RESTORE DATABASE;
RECOVER DATABASE;
RELEASE CHANNEL ch00;
}

Applies To

All platforms and NetBackup versions