Forum Discussion

Mux's avatar
Mux
Level 4
10 years ago

The RMAN restores are failing with "Backup file not found in Netbackup catalog"

The RMAN restores are failing with the below error:

 

=========================

channel t5: ORA-19870: error while restoring backup piece PROD_17769_1

ORA-19507: failed to retrieve sequential file, handle="PROD_17769_1", parms=""

ORA-27029: skgfrtrv: sbtrestore returned error

ORA-19511: Error received from media manager layer, error text:

   Backup file <PROD_17769_1> not found in NetBackup catalog

=========================

I am using below scripts for restoring control files, Earlier these scripts were working fine but now having issue:

 

=========================

RUN

{

set DBID 25331020;

SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO 'ERPPROD%F';

allocate channel t1 type SBT_TAPE parms='ENV=(NB_ORA_POLICY=PROD_ERP_RMAN,NB_ORA_SERV=qfb00001,NB_ORA_CLIENT=qfa00025.qf.org.qa)';

restore controlfile from autobackup maxdays=3;

release channel t1;

}

 

 

RUN

{

set DBID 25331020;

allocate channel t1 type SBT_TAPE parms='ENV=(NB_ORA_POLICY=PROD_ERP_RMAN,NB_ORA_SERV=qfb00001,NB_ORA_CLIENT=QFA00025)';

restore controlfile from "ERPPRODc-25331020-20140917-01";

release channel t1;

}

=========================

 

The script used for backup is as below:

 

=========================

run {
sql 'alter session set optimizer_mode=RULE';
allocate channel t1 type SBT MAXPIECESIZE 50G;
allocate channel c1 type SBT MAXPIECESIZE 50G;
allocate channel t2 type SBT MAXPIECESIZE 50G;
allocate channel c2 type SBT MAXPIECESIZE 50G;
allocate channel t3 type SBT MAXPIECESIZE 50G;
BACKUP DATABASE format'%d_%s_%p' TAG=PRODFULLBKP;
sql 'alter system archive log current';
BACKUP ARCHIVELOG FROM TIME 'SYSDATE-2' UNTIL TIME 'SYSDATE' format 'arc_%d_%s_%p' TAG=PRODARCHIVELOG;
BACKUP current controlfile format 'ERPPRODc%f' TAG=CTRLFILE;
crosscheck backup;
crosscheck archivelog all;
delete noprompt archivelog all completed before 'sysdate-5';
release channel t1;
release channel c1;
release channel t2;
release channel c2;
release channel t3;
}

=========================

i am attaching the list backup of controlfile

 

Can anyone help...?

 

Thanks

  • PROD_17755_1 is not found in your attechment. Are you trying to restore control file on alternate host? How did you exactly try to restore? You wrote two types of restore attempt in your first post. 

4 Replies

Replies have been turned off for this discussion
  • take out the NB_ORA_POLICY from restore script.

     

    NB_ORA_CLIENT=qfa00025.qf.org.qa

    NB_ORA_CLIENT=QFA00025

    showiing one with uppder case and another with lower case.. Make you you use the same client name that is used in backup script.

     

  • I ran the restore script after making the mentioned changes, but receiving the  same error.

     

    channel t4: ORA-19870: error while restoring backup piece PROD_17755_1

    ORA-19507: failed to retrieve sequential file, handle="PROD_17755_1", parms=""

    ORA-27029: skgfrtrv: sbtrestore returned error

    ORA-19511: Error received from media manager layer, error text:

       Backup file <PROD_17755_1> not found in NetBackup catalog

  • PROD_17755_1 is not found in your attechment. Are you trying to restore control file on alternate host? How did you exactly try to restore? You wrote two types of restore attempt in your first post.