Oracle redirected restoration issue
Controlfile restoration issue has been resolved after adding No.restricstions file, but still i am facing the problem while restoring database!
Below is the logfile,
abcbkp02:> rman target / catalog rman/xxxx@rman12
Recovery Manager: Release 12.1.0.2.0 - Production on Thu May 28 05:47:23 2015
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: DSTGEDV (not mounted)
connected to recovery catalog database
RMAN> run
{
set until time "to_date('2015/05/25 20:30:00','YYYY/MM/DD HH24:MI:SS')";
allocate channel ch1 type 'sbt_tape' parms="ENV=(NB_ORA_CLASS=AIR_ABCDB12_DB_DSTGEDV_ONLINE, NB_ORA_SERV=abcbkp02, NB_ORA_CLIENT=abcdb12)";
restore controlfile;
}
2> 3> 4> 5> 6>
executing command: SET until clause
allocated channel: ch1
channel ch1: SID=122 device type=SBT_TAPE
channel ch1: Veritas NetBackup for Oracle - Release 7.6 (2015021210)
Starting restore at 28-MAY-15
new media label is "@aaaah" for piece "c-2057956423-20150525-2a"
channel ch1: starting datafile backup set restore
channel ch1: restoring control file
channel ch1: reading from backup piece c-2057956423-20150525-2a
channel ch1: piece handle=c-2057956423-20150525-2a tag=TAG20150525T200244
channel ch1: restored backup piece 1
channel ch1: restore complete, elapsed time: 00:01:05
output file name=/u03/dstgedv/data01/control01.ctl
output file name=/u03/dstgedv/redo01/control02.ctl
output file name=/u03/dstgedv/redo02/control03.ctl
Finished restore at 28-MAY-15
released channel: ch1
RMAN> alter database mount;
Statement processed
RMAN> run
2> {
set until time "to_date('2015/05/25 20:30:00','YYYY/MM/DD HH24:MI:SS')";
3> 4> allocate channel ch1 type 'sbt_tape' parms="ENV=(NB_ORA_CLASS=AIR_ABCDB12_DB_DSTGEDV_ARCH, NB_ORA_SERV=abcbkp02, NB_ORA_CLIENT=abcdb12)";
5> allocate channel ch2 type 'sbt_tape' parms="ENV=(NB_ORA_CLASS=AIR_ABCDB12_DB_DSTGEDV_ARCH, NB_ORA_SERV=abcbkp02, NB_ORA_CLIENT=abcdb12)";
6> allocate channel ch3 type 'sbt_tape' parms="ENV=(NB_ORA_CLASS=AIR_ABCDB12_DB_DSTGEDV_ARCH, NB_ORA_SERV=abcbkp02, NB_ORA_CLIENT=abcdb12)";
7> restore database;}
executing command: SET until clause
allocated channel: ch1
channel ch1: SID=122 device type=SBT_TAPE
channel ch1: Veritas NetBackup for Oracle - Release 7.6 (2015021210)
allocated channel: ch2
channel ch2: SID=178 device type=SBT_TAPE
channel ch2: Veritas NetBackup for Oracle - Release 7.6 (2015021210)
allocated channel: ch3
channel ch3: SID=241 device type=SBT_TAPE
channel ch3: Veritas NetBackup for Oracle - Release 7.6 (2015021210)
Starting restore at 28-MAY-15
channel ch1: starting datafile backup set restore
channel ch1: specifying datafile(s) to restore from backup set
channel ch1: restoring datafile 00001 to /u03/dstgedv/data01/system01.dbf
channel ch1: restoring datafile 00006 to /u03/dstgedv/data01/users01.dbf
channel ch1: restoring datafile 00009 to /u03/dstgedv/data01/DSODBSPACE.dbf
channel ch1: reading from backup piece DSTGEDV_879778653_10307_1
channel ch2: starting datafile backup set restore
channel ch2: specifying datafile(s) to restore from backup set
channel ch2: restoring datafile 00002 to /u03/dstgedv/data01/iaspace.dbf
channel ch2: restoring datafile 00007 to /u03/dstgedv/data01/xmetasrsp.dbf
channel ch2: restoring datafile 00008 to /u03/dstgedv/data01/dseodb01.dbf
channel ch2: reading from backup piece DSTGEDV_879778653_10306_1
channel ch3: starting datafile backup set restore
channel ch3: specifying datafile(s) to restore from backup set
channel ch3: restoring datafile 00003 to /u03/dstgedv/data01/sysaux01.dbf
channel ch3: restoring datafile 00004 to /u03/dstgedv/undo01/undotbs01.dbf
channel ch3: restoring datafile 00005 to /u03/dstgedv/data01/xmetaspace.dbf
channel ch3: reading from backup piece DSTGEDV_879778653_10305_1
channel ch1: ORA-19870: error while restoring backup piece DSTGEDV_879778653_10307_1
ORA-19507: failed to retrieve sequential file, handle="DSTGEDV_879778653_10307_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
Backup file <DSTGEDV_879778653_10307_1> not found in NetBackup catalog
channel ch2: ORA-19870: error while restoring backup piece DSTGEDV_879778653_10306_1
ORA-19507: failed to retrieve sequential file, handle="DSTGEDV_879778653_10306_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
Backup file <DSTGEDV_879778653_10306_1> not found in NetBackup catalog
channel ch3: ORA-19870: error while restoring backup piece DSTGEDV_879778653_10305_1
ORA-19507: failed to retrieve sequential file, handle="DSTGEDV_879778653_10305_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
Backup file <DSTGEDV_879778653_10305_1> not found in NetBackup catalog
failover to previous backup
channel ch1: starting datafile backup set restore
channel ch1: specifying datafile(s) to restore from backup set
channel ch1: restoring datafile 00001 to /u03/dstgedv/data01/system01.dbf
channel ch1: restoring datafile 00006 to /u03/dstgedv/data01/users01.dbf
channel ch1: restoring datafile 00009 to /u03/dstgedv/data01/DSODBSPACE.dbf
channel ch1: reading from backup piece DSTGEDV_879696472_10210_1
channel ch2: starting datafile backup set restore
channel ch2: specifying datafile(s) to restore from backup set
channel ch2: restoring datafile 00002 to /u03/dstgedv/data01/iaspace.dbf
channel ch2: restoring datafile 00007 to /u03/dstgedv/data01/xmetasrsp.dbf
channel ch2: restoring datafile 00008 to /u03/dstgedv/data01/dseodb01.dbf
channel ch2: reading from backup piece DSTGEDV_879696472_10209_1
channel ch3: starting datafile backup set restore
channel ch3: specifying datafile(s) to restore from backup set
channel ch3: restoring datafile 00003 to /u03/dstgedv/data01/sysaux01.dbf
channel ch3: restoring datafile 00004 to /u03/dstgedv/undo01/undotbs01.dbf
channel ch3: restoring datafile 00005 to /u03/dstgedv/data01/xmetaspace.dbf
channel ch3: reading from backup piece DSTGEDV_879696472_10208_1
channel ch1: ORA-19870: error while restoring backup piece DSTGEDV_879696472_10210_1
ORA-19507: failed to retrieve sequential file, handle="DSTGEDV_879696472_10210_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
Backup file <DSTGEDV_879696472_10210_1> not found in NetBackup catalog
channel ch2: ORA-19870: error while restoring backup piece DSTGEDV_879696472_10209_1
ORA-19507: failed to retrieve sequential file, handle="DSTGEDV_879696472_10209_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
Backup file <DSTGEDV_879696472_10209_1> not found in NetBackup catalog
channel ch3: ORA-19870: error while restoring backup piece DSTGEDV_879696472_10208_1
ORA-19507: failed to retrieve sequential file, handle="DSTGEDV_879696472_10208_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
Backup file <DSTGEDV_879696472_10208_1> not found in NetBackup catalog
failover to previous backup
released channel: ch1
released channel: ch2
released channel: ch3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/28/2015 05:50:37
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
Please suggest what can be done to get out of this error.
Backup file <DSTGEDV_879778653_10307_1> not found in NetBackup catalog
Backup file <DSTGEDV_879696472_10209_1> not found in NetBackup catalog
.....
It seems that rman catalog and NBU catalogs may be out of sync.
Have you tried to run bplist to see what is in NBU catalog?
bplist -t 4 -C abcdb12 -d <start-date> -R /
e.g.bplist -t 4 -C abcdb12 -d 05/20/2015 -R /
Also compare system (OS) dates between NBU master server, Oracle client and rman catalog server.
If there is more than a couple of hours difference, date stamps may be different resulting incorrect search criteria.To sync rman and NBU catalogs, see this TN:
DOCUMENTATION: Best Practice for maintaining a consistent backup catalog between Oracle RMAN and NetBackup.
http://www.symantec.com/docs/TECH49868and this one:
Maintaining the RMAN repository
http://www.symantec.com/docs/HOWTO89530This technote http://www.symantec.com/docs/TECH77362 might also help with this
In my experience most Oracle restore issues is related to name resolving somewhere along the line