05-26-2015 07:21 AM
Hi all ;
i have the below environment :
* Master server Hostname: Netbackup-bck , Solaris 10
* Media servers :
1- Oracle RAC Servers :
- racnode1 hostname: newpension1-bck , backup under /NB_backup/DB_backup
- racnode2 hostname: newpension2-bck
2- standalone db server:
- hostname: dbserver-bck.
i took backup from the oracle RAC database using the the first node newpension1-bck and the ASM backup is under /NB_backup/DB_backup .
there was adatabase installed in standalone db server , so we deleted it to make a redirect restore from newpension1-bck to dbserver-bck . i speaked to DBA about that and confirm about restore from ASM backup to non-ASM database .
below the steps i used to perform the restore:
* on master server :
1- vi /usr/openv/netbackup/db/altnames/dbserver-bck
newpension1-bck
* on "destination server" dbserver-bck :
1- browse the oracle backups bu running bplist -S netbackup-bck -C newpension1-bck -t 4 -l -R /
2- mount the NAS storage file system which locate the backup of the newpension1-bck under dbserver-bck
3- set CLIENT_NAME= newpnsion1-bck in bp.conf
4- copy password file in the source newpension1-bck to the destination client database and rename it orapwpesnion1 as found in newpension1
5- Restore the control file ( in Nomount Mode )
$ rman nocatalog
RMAN> connect target
then
run {
allocate channel c1 type 'sbt_tape';
send 'NB_ORA_SERV=netbackup-bck, NB_ORA_CLIENT=ora_clnt';
restore controlfile to '/tmp/cntrl.bak' from 'ctrl_dPENSION_uegq7skb4_s2512_p1_t880693604';
release channel c1;
}
but the following error occur :
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/26/2015 15:34:12
ORA-19870: error while restoring backup piece c-1010546082-20150526-11
ORA-19507: failed to retrieve sequential file, handle="ctrl_dPENSION_uegq7skb4_s2512_p1_t880693604", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Failed to open backup file for restore.
please check dbclient log file on the destination server ,and bprd on the master server
Solved! Go to Solution.
05-26-2015 08:35 PM
05-26-2015 07:34 AM
Hello Deyaa!
Please check this TN http://www.symantec.com/docs/TECH165202
Nacho
05-26-2015 07:58 AM
Best to create No.Restrictions in altnames.
There seems to be confustion in name of restore destination : dbserver vs dbserver-bck.
17:07:00.055 [18018] <2> process_request: browse_clnt: newpension1-bck 17:07:00.055 [18018] <2> process_request: requesting_clnt: dbserver 17:07:00.055 [18018] <2> process_request: destination_clnt: dbserver 17:07:00.055 [18018] <2> process_request: clnt_bp_conf_name: newpension1-bck 17:07:00.055 [18018] <2> process_request: peername: dbserver-bck
05-26-2015 09:24 AM
the same error marianne ;
please check the updated logs
05-26-2015 09:25 AM
tried all possibilities but with the same error .
BR
Deyaa
05-26-2015 11:37 AM
the below is the job status :
05/26/2015 18:23:19 - Error bpbrm (pid=11113) Request from host newpension1-bck (192.168.1.30) to host dbserver-bck (192.168.1.70) is not allowed access. Host newpension1-bck (192.168.1.30) is not an authorized server for host dbserver-bck.
05/26/2015 18:23:19 - Error bpbrm (pid=11113) bpcd on dbserver-bck exited with status 59: access to the client was not allowed
05/26/2015 18:23:19 - Info tar (pid=0) done. status: 59: access to the client was not allowed
05/26/2015 18:23:19 - Error bpbrm (pid=11113) client restore EXIT STATUS 59: access to the client was not allowed
05/26/2015 18:36:21 - begin Restore
05/26/2015 18:36:21 - Info bprd (pid=27160) Found (1) files in (1) images for Restore Job ID 404.xxx
05/26/2015 18:36:22 - restoring from image newpension1-bck_1432606518
05/26/2015 18:36:22 - Info bprd (pid=27160) Searched (1) files of (1) files for Restore Job ID 404.xxx
05/26/2015 18:36:22 - Info bprd (pid=27160) Restoring from copy 1 of image created Tue May 26 05:15:18 2015 from policy DB_node1_Disk
05/26/2015 18:36:24 - restored from image newpension1-bck_1432606518; restore time: 0:00:02
05/26/2015 18:36:25 - end Restore; elapsed time 0:00:04
Oracle policy restore error (2801)
05-26-2015 08:35 PM
05-27-2015 05:04 AM
very thanks marianne ; you are the best
05-27-2015 05:12 AM
Sorry I 'faded' last light... Different time zones means that we cannot always be online at the same time.
Glad that it worked!
You provided useful info from the start. Wish everyone would do the same!