cancel
Showing results for 
Search instead for 
Did you mean: 

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

Hadi_Reslan
Level 2
Partner

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

 

1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

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.

 

View solution in original post

8 REPLIES 8

Will_Restore
Level 6
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
Moderator
Moderator
Partner    VIP    Accredited Certified

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
Level 2
Partner

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

Hadi_Reslan
Level 2
Partner

kindly find attached the log files. I also attached output for the contents of the netbackup and RMAN catalogs.

The rman restore is requesting the file "<cntrl_18_1_810725846>"

The file is found in RMAN catalog but not in netbackup catalog.

It seems that the RMAN catalog is not syncing with the NBU catalog.

 

Regards,

Yasuhisa_Ishika
Level 6
Partner Accredited Certified

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
Level 2
Partner

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

Thank you all

Yasuhisa_Ishika
Level 6
Partner Accredited Certified

Please mark Marianne's post as a solution as she mentioned to ORACLE_SID.