Forum Discussion

Deyaa's avatar
Deyaa
Level 4
10 years ago

oracle Database redirect restore error

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

 

7.6
Backing Up
Backup and Recovery
Error messages
Installing
Integration
NetBackup
Recovering
Restore
Solaris
  • Marianne's avatar
    Marianne
    10 years ago
    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.
  • I_De_Pedro's avatar
    I_De_Pedro
    Level 4
    10 years ago

    Hello Deyaa!

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

    Nacho

     

     

     

  • Marianne's avatar
    Marianne
    Level 6
    10 years ago

    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's avatar
    Deyaa
    Level 4
    10 years ago

    tried all possibilities but with the same error .

    BR

    Deyaa

  • Deyaa's avatar
    Deyaa
    Level 4
    10 years ago

    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's avatar
    Marianne
    Level 6
    10 years ago
    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.
  • Marianne's avatar
    Marianne
    Level 6
    10 years ago

    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!