cancel
Showing results for 
Search instead for 
Did you mean: 

RMAN Restore ALTERNATE client ,alternate storage unit

PranavB
Level 4

Hello Geeks !

 

I have to do one restore to alternative client at a diffrent location . I have duplicated the imgaes of rman to data domain at other site.

Would it be possible to restore like this.

 

Env is Solaris 10 -7.5.0.5

 

Thanks,

PranavB

1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Level 6
Partner    VIP    Accredited Certified

To restore from duplicate copy, you will need to promote this copy to primary.

Next point to confirm is Rman catalog. 
Was backup done using rman catalog or NOCATALOG?
If Rman catalog - you/dba need to ensure that rman catalog is accessible at remote domain.

Redirected restore is covered in NetBackup for Oracle Administrator's Guide:  http://www.symantec.com/docs/DOC5175 under this topic: 

Redirecting a restore to a different client 

Here you will see that the restore is initiated from the destination client.
So, important to confirm comms between master and destination client:
Forward and reverse name lookup plus port 1556 open in both directions.
Create altnames entry on master server to allow redirected restore (details in the manual) and firstly use bplist on the destination client to see if Oracle images for source client can be listed.
List and restore commands must be done as same oracle user id that performed the backup.
(Compare user id's in /etc/passwd on source and destination client).
See the same manual for bplist example.

When bplist works fine, the DBA needs to confirm connectivity to Rman catalog and use rman commands to list backups.
If all of the above is fine, see the manual for instructions on NBU and/or Rman variables - such as NB_ORA_CLIENT and CLIENT_NAME. 
Fine to use either or.

Lastly, confirm comms between destination client and media server where images were duplicated to.
Test backup and restore of small filesystem folder will be fine.

Ensure ALL of these folders exist before you start:

On master: bprd  (restart NBU if you need to create the folder)
On destination client: bpcd and dbclient (dbclient needs 777 permissions)
On media server: bpbrm and bptm

 

Good luck!

View solution in original post

5 REPLIES 5

PranavB
Level 4

Earlier backup was taken on tape.

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Yes, just make sure to make the "other" site copy primary so its used and not the one in the primary site.

Michael_G_Ander
Level 6
Certified

Just remember that NB_ORA_CLIENT and CLIENT_NAME needs to be the name of original client

The standard questions: Have you checked: 1) What has changed. 2) The manual 3) If there are any tech notes or VOX posts regarding the issue

Marianne
Level 6
Partner    VIP    Accredited Certified

To restore from duplicate copy, you will need to promote this copy to primary.

Next point to confirm is Rman catalog. 
Was backup done using rman catalog or NOCATALOG?
If Rman catalog - you/dba need to ensure that rman catalog is accessible at remote domain.

Redirected restore is covered in NetBackup for Oracle Administrator's Guide:  http://www.symantec.com/docs/DOC5175 under this topic: 

Redirecting a restore to a different client 

Here you will see that the restore is initiated from the destination client.
So, important to confirm comms between master and destination client:
Forward and reverse name lookup plus port 1556 open in both directions.
Create altnames entry on master server to allow redirected restore (details in the manual) and firstly use bplist on the destination client to see if Oracle images for source client can be listed.
List and restore commands must be done as same oracle user id that performed the backup.
(Compare user id's in /etc/passwd on source and destination client).
See the same manual for bplist example.

When bplist works fine, the DBA needs to confirm connectivity to Rman catalog and use rman commands to list backups.
If all of the above is fine, see the manual for instructions on NBU and/or Rman variables - such as NB_ORA_CLIENT and CLIENT_NAME. 
Fine to use either or.

Lastly, confirm comms between destination client and media server where images were duplicated to.
Test backup and restore of small filesystem folder will be fine.

Ensure ALL of these folders exist before you start:

On master: bprd  (restart NBU if you need to create the folder)
On destination client: bpcd and dbclient (dbclient needs 777 permissions)
On media server: bpbrm and bptm

 

Good luck!

PranavB
Level 4

Thank you ,let me run a test