cancel
Showing results for 
Search instead for 
Did you mean: 

oracle Database redirect restore error

Deyaa
Level 4

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 /

-rw-rw---- oracle    asmadmin     19660800 May 26 05:07 /c-1010546082-20150526-0b
-rw-rw---- oracle    asmadmin     19660800 May 26 05:06 /ctrl_dPENSION_uegq7skb4_s2512_p1_t880693604
-rw-rw---- oracle    asmadmin     19660800 May 26 05:05 /c-1010546082-20150526-0a
-rw-rw---- oracle    asmadmin     41943040 May 26 05:04 /arch_dPENSION_ueeq7sk70_s2510_p1_t880693472
-rw-rw---- oracle    asmadmin    589824000 May 26 05:03 /arch_dPENSION_uedq7sk4v_s2509_p1_t880693407
-rw-rw---- oracle    asmadmin    805830656 May 26 05:03 /arch_dPENSION_uecq7sk4v_s2508_p1_t880693407
-rw-rw---- oracle    asmadmin     19660800 May 26 05:02 /c-1010546082-20150526-09
-rw-rw---- oracle    asmadmin    52905728K May 26 04:52 /bk_dPENSION_ue7q7sjfl_s2503_p1_t880692725
-rw-rw---- oracle    asmadmin    35581696K May 26 04:52 /bk_dPENSION_ue6q7sjfl_s2502_p1_t880692725
 
 
 

    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

 

1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
So, it seems newpension1-bck is also a media server and performed its own backup? This means that it will also be the restore media server. Add SERVER entry for newpension1-bck in bp.conf on dbserver-bck. Ensure master server stays 1st SERVER entry.

View solution in original post

8 REPLIES 8

I_De_Pedro
Level 4
Employee Accredited Certified

Hello Deyaa!

Please check this TN http://www.symantec.com/docs/TECH165202 

Nacho

 

 

 

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

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

Deyaa
Level 4

the same error marianne ;

please check the updated logs

Deyaa
Level 4

tried all possibilities but with the same error .

BR

Deyaa

Deyaa
Level 4

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)

 

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
So, it seems newpension1-bck is also a media server and performed its own backup? This means that it will also be the restore media server. Add SERVER entry for newpension1-bck in bp.conf on dbserver-bck. Ensure master server stays 1st SERVER entry.

Deyaa
Level 4

very thanks marianne ; you are the best 

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

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!