Oracle RMAN backup restore using netbackup DR appliance.
Hi,
We are using Netbackup 8.1 for our backups
Production Site and Recovery Site. Both sites are active with Master Server (name NB-Master) installed in Production Site. There is also one Media Server (name NB-Media1) installed on Production Site and at least one Media Server (name NB-Media2) on Disaster Recovery site. It means that one NetBackup domain is splitted between two sites. All backups (included NetBackup Catalog backups) are done on Production Media Server (name NB-Media1) and all backups (included NetBackup Catalog backups) replicated to the Disaster Recovery Site via Storage Lifecycle Policy (SLP).
We have testing different scenarios:
1.First scenario restore (RMAN) oracle database using Production Media Server (name NB-Media1) where we have taken backup and it is working fine.
2. Second scenario (Master Server (name NB-Master) and Media Server (name NB-Media1) not available). We want to restore restore (RMAN) oracle database using DR Media Server (name NB-Media2) where our backups get replicated using SLP. This scenario is giving error.
We are initiating restore commands from client and using NB_ORA_SERV as DR appliance.
#########################
RMAN> run
{
ALLOCATE CHANNEL ch01 DEVICE TYPE SBT_TAPE PARMS="SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64.1, ENV=(NB_ORA_CLIENT=Client_name,NB_ORA_SERV=NB-Media2)";
restore controlfile from 'cntrl_42_1_1013551832';
}
#############################
Please note Master server & Prodution backup appliance is not reachable. DR appliance is rechable from client where we are trying to restore.
hosts file and bp.conf is having details of DR appliance.
bplist command dose not list RMAN backups on which replicated on DR appliance. So RMAN restore fails.
How we can restore oracle database from DR appliance.
Please advise.
Regards,
Rahul.
Are NB-Media1 and NB-Media2 media servers under the same master server?
(SLP is duplicating images between Media1 and and Media2)
Or do you have a different Master server at the DR site?
(SLP is replicating images to Media2 that belongs to a master server at DR site)NB_ORA_SERV variable points to the Master server where the Image catalog resides.
bplist will contact the master server to list from the Image catalog.So, NB_ORA_SERV=NB-Media2 can only work if NB-Media2 is a master server, and has been added to the Oracle client in SERVER entries
If the replication and import phases completed successfully, you should be able to browse and restore using master NB-Media2.
Can you navigate to /usr/openv/netbackup/db/images on NB-Media2? When you list the directory names, can you see the client name from production?
If so, what do you see when you list sub-directories in the Client folder?
There should be 10-digit folders where image headers reside.
All 'recent' images (since 13 July) should be in a folder named 1563000000.
Image headers between 1 and 13 July will be in folder 1562000000.So, once you have verified that their are images on NB-Media2 for the client-name in the required date-range, then please have another look at search criteria for bplist. Client name must match the folder name in images folder exactly, date range must match timestamps in images folders, etc.
Firstly run bplist on NB-Media2 with all relevant search parameters, e.g.
bplist -C <client-name> -s <start-date> -t 4 -R /Does that work?
If so, try the command from the client.
If error message is received, have a look at bprd log on NB-Media2 to see how the request is received and interpreted.So, there is no security certificate on DR master.
Have a look at these posts:
https://vox.veritas.com/t5/NetBackup/NetBackup-Client-Token-for-second-master-server/m-p/841485
