Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Can't restore from RMAN backup

Created: 26 Sep 2012 • Updated: 26 Sep 2012 | 7 comments
This issue has been solved. See solution.

Hi Everyone!

I can't restore from my RMAN backups.

RMAN> run
2> {
3> host "date";
4> allocate channel t1 DEVICE TYPE 'SBT_TAPE' PARMS="ENV=(NB_ORA_CLIENT=vs-oa00-01b.hosting.local,NB_ORA_POLICY=Oracle_Prod_Policy,NB_ORA_SERV=ps-bcp00-01a.hosting.local,NB_ORA_SCHED=Default-Application-Backup)";
5> restore controlfile to '/u01/app/control01.ctl' from tag 'TAG20120926T053022';
6> release channel t1 ;
host "date";
7> 8> }

Wed Sep 26 17:32:27 MSK 2012
host command complete

allocated channel: t1
channel t1: SID=551 instance=skdbse2 device type=SBT_TAPE
channel t1: Veritas NetBackup for Oracle - Release 7.5 (2012020807)

Starting restore at 26-SEP-12

channel t1: starting datafile backup set restore
channel t1: restoring control file
output file name=/u01/app/control01.ctl
channel t1: reading from backup piece c-1341750022-20120926-02
channel t1: ORA-19870: error while restoring backup piece c-1341750022-20120926-02
ORA-19507: failed to retrieve sequential file, handle="c-1341750022-20120926-02", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
   Backup file <c-1341750022-20120926-02> not found in NetBackup catalog

failover to previous backup

released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/26/2012 17:32:41
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore

RMAN>

Comments 7 CommentsJump to latest comment

Will Restore's picture

" Backup file <c-1341750022-20120926-02> not found in NetBackup catalog "

How was this instance backed up ?

Will Restore -- where there is a Will there is a way

Alex_al's picture

This instance backed up with RMAN script using Recovery catalog:

RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=vs-ora00-01b.hosting.local,NB_ORA_SID=skdbse2,NB_ORA_POLICY=Oracle_Prod_Policy,NB_ORA_SERV=ps-bcp00-01a.hosting.local,NB_ORA_SCHED=Defaul
t-App
lication-Backup';
BACKUP INCREMENTAL LEVEL=0 FORMAT 'df_%d_%s_%p_%t' DATABASE;
sql 'alter system archive log current';
RELEASE CHANNEL ch00;

ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=vs-ora00-01b.hosting.local,NB_ORA_SID=skdbse2,NB_ORA_POLICY=Oracle_Prod_Policy,NB_ORA_SERV=ps-bcp00-01a.hosting.local,NB_ORA_SCHED=Defaul
t-App
lication-Backup';
BACKUP FORMAT 'al_%d_%s_%p_%t' ARCHIVELOG ALL DELETE INPUT;
RELEASE CHANNEL ch00;

ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=vs-ora00-01b.hosting.local,NB_ORA_SID=skdbse2,NB_ORA_POLICY=Oracle_Prod_Policy,NB_ORA_SERV=ps-bcp00-01a.hosting.local,NB_ORA_SCHED=Defaul
t-App
lication-Backup';
BACKUP FORMAT 'cntrl_%d_%s_%p_%t' CURRENT CONTROLFILE;
RELEASE CHANNEL ch00;
}

In RMAN I can see the file with backup

RMAN> LIST BACKUPSET TAG 'TAG20120926T053022';

List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
24176   Full    47.50M     SBT_TAPE    00:00:21     26-SEP-12
        BP Key: 26217   Status: AVAILABLE  Compressed: NO  Tag: TAG20120926T053022
        Handle: c-1341750022-20120926-02   Media: ORA001
  SPFILE Included: Modification time: 24-SEP-12
  SPFILE db_unique_name: SKDBSE
  Control File Included: Ckp SCN: 78846139095   Ckp time: 26-SEP-12

Yasuhisa Ishikawa's picture

Just typo.

In your original post:

RMAN> run
2> {
3> host "date";
4> allocate channel t1 DEVICE TYPE 'SBT_TAPE' PARMS="ENV=(NB_ORA_CLIENT=vs-oa00-01b.hosting.local,NB_ORA_POLICY=Oracle_Prod_Policy,NB_ORA_SERV=ps-bcp00-01a.hosting.local,NB_ORA_SCHED=Default-Application-Backup)";
5> restore controlfile to '/u01/app/control01.ctl' from tag 'TAG20120926T053022';
6> release channel t1 ;
host "date";
7> 8> }

NB_ORA_CLIENT must be vs-ora00-01b.hosting.local.

Authorized Symantec Consultant(ASC) Data Protection in Tokyo, Japan

SOLUTION
Alex_al's picture

Thank you! I didn,t saw that I maked mistake in hostname!

Marianne's picture

Have you confirmed that RMAN catalog and NBU catalog are in sync?

Are you performing the restore as same user that did the backup?

Is this a restore to same or alternate Oracle server?

Try to do bplist on the master for client vs-oa00-01b.hosting.local to see if you can locate the required backup piece:

bplist -C vs-oa00-01b.hosting.local -t 4 -s <dd/mm/yyyy> -e <dd/mm/yyyy> -R /

(where -s is start date and -e end date)

Do the bplist from the master as well as the destination client.

check that bprd log folder exists on the master for troubleshooting. (NBU needs to be restarted to enable log.)

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

Alex_al's picture

Yow I can check sync RMAN catalog with NBU?

Yes, I make restore as same user.

Yes, I try to make restore at the same host where backup was maked.

server

C:\Program Files\VERITAS\NetBackup\bin>bplist -C vs-ora00-01b.hosting.local -t 4
 -s 09/26/2012 -e 09/28/2012 -R /
c-1341750022-20120927-02:\
cntrl_SKDBSE_11900_1_795072479:\
c-1341750022-20120927-01:\
al_SKDBSE_11898_1_795072207:\
al_SKDBSE_11897_1_795071983:\
c-1341750022-20120927-00:\
df_SKDBSE_11895_1_795067309:\
c-1341750022-20120926-02:\
cntrl_SKDBSE_11893_1_794986193:\
c-1341750022-20120926-01:\
al_SKDBSE_11891_1_794985888:\
al_SKDBSE_11890_1_794985617:\
c-1341750022-20120926-00:\

host

-bash-4.2$ bplist -C vs-ora00-01b.hosting.local -t 4 -s 09/26/2012 -e 09/28/2012 -R /
/c-1341750022-20120927-02
/cntrl_SKDBSE_11900_1_795072479
/c-1341750022-20120927-01
/al_SKDBSE_11898_1_795072207
/al_SKDBSE_11897_1_795071983
/c-1341750022-20120927-00
/df_SKDBSE_11895_1_795067309
/c-1341750022-20120926-02
/cntrl_SKDBSE_11893_1_794986193
/c-1341750022-20120926-01
/al_SKDBSE_11891_1_794985888
/al_SKDBSE_11890_1_794985617
/c-1341750022-20120926-00
/df_SKDBSE_11888_1_794980868

I'm create folder bprd on master but can't immediately restart it because backup job now in progress.

Alex_al's picture

I found, it was mistake in the hosname!

Thanks for advice!