Forum Discussion

Hadi_Reslan's avatar
Hadi_Reslan
Level 2
12 years ago

Oracle RMAN restore is failing with error "ORA-19507: failed to retrieve sequential file, ...."

Hi All,

We are running netbackup for oracle agent. The oracle clients has four instance and each instance has its own backup policy.

The backup is successful for all instances. But when it comes to restore, only one instance restore succeeds and 3 fails. below is the rman output:

 

RMAN> run {
2>  allocate channel ch1 type 'sbt_tape';
3>  SEND'NB_ORA_SERV=backup-server,NB_ORA_CLIENT=banner,NB_ORA_POLICY=banner-oracle-seed-policy,NB_ORA_SCHED=Default-Application-Backup';
4>  restore controlfile to '/tmp/my_controlfile_seed.ctl';
5>  release channel ch1;
6>  }
 
using target database control file instead of recovery catalog
allocated channel: ch1
channel ch1: sid=155 devtype=SBT_TAPE
channel ch1: Veritas NetBackup for Oracle - Release 7.5 (2012060520)
 
sent command to channel: ch1
 
Starting restore at 22-MAR-13
 
channel ch1: starting datafile backupset restore
channel ch1: restoring control file
output filename=/tmp/my_controlfile_seed.ctl
channel ch1: reading from backup piece cntrl_18_1_810725846
ORA-19870: error reading backup piece cntrl_18_1_810725846
ORA-19507: failed to retrieve sequential file, handle="cntrl_18_1_810725846", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
   Backup file <cntrl_18_1_810725846> not found in NetBackup catalog
failover to previous backup
 
channel ch1: starting datafile backupset restore
channel ch1: restoring control file
output filename=/tmp/my_controlfile_seed.ctl
channel ch1: reading from backup piece bk_14_1_810725788
ORA-19870: error reading backup piece bk_14_1_810725788
ORA-19507: failed to retrieve sequential file, handle="bk_14_1_810725788", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
   Backup file <bk_14_1_810725788> not found in NetBackup catalog
failover to previous backup
.
.
.
.
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/22/2013 11:35:44
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore
 
I appreciate if somebody can assist in finding a solution for this problem.
 
Many Thanks,
Hadi

 

7.5
Backup and Recovery
NetBackup
Restore
Solaris
Troubleshooting
  • Marianne's avatar
    Marianne
    12 years ago

    Did you remember to specify ORACLE_SID variable?

    Is user Id the same as user who performed the backup?

    In addition to dbclient log, also ensure that bprd log folder exists on the master server.
    If not, create folder and restart NBU.
    Retry the restore, then copy logs to .txt files (dbclient.txt, bprd.txt) and post as File attachments.

     

8 Replies

Sort By
Replies have been turned off for this discussion
  • Will_Restore's avatar
    Will_Restore
    Level 6
    12 years ago
    Look at the dblient log file for further information. If it does not already exist on the client, create NetBackup/logs/dbclient directory and run the job again
  • Marianne's avatar
    Marianne
    Level 6
    12 years ago

    Did you remember to specify ORACLE_SID variable?

    Is user Id the same as user who performed the backup?

    In addition to dbclient log, also ensure that bprd log folder exists on the master server.
    If not, create folder and restart NBU.
    Retry the restore, then copy logs to .txt files (dbclient.txt, bprd.txt) and post as File attachments.

     

  • Hadi_Reslan's avatar
    Hadi_Reslan
    Level 2
    12 years ago

    I am using a script file for oracle policy backup selection with the below paramters for TRNG instance. For the other instances, i change the &quot;ORACLE_SID&quot; paramter according to the instance name.

    ORACLE_HOME=/u02/app/oracle/product/10.2.0
    ORACLE_SID=TRNG
    ORACLE_USER=oracle
    TARGET_CONNECT_STR=/
     
    I login to the server as oracle user and specify the ORACLE_SID for the instance i want to restore. the restore is succeeding for the instance TRNG but not for the other 3 instances. Although the configuration is exactly the same for all 4 instances.

     Later i'll check the log files and post them.

    Many Thanks

  • Yasuhisa_Ishika's avatar
    Yasuhisa_Ishika
    Level 6
    12 years ago

    cntrl_18_1_810725846  is not listed in bplist.

    Please check with which client name you took the backup of control file for this instance. Post "bppllist policyname -U", and "bpimagelist -policy policyname -hoursago 240"

  • Hadi_Reslan's avatar
    Hadi_Reslan
    Level 2
    12 years ago

    The problem is solved. Had the wrong ORACLE_SID parameter in the rman script files.

    Thank you all