Can't restore from RMAN backup
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>
- 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.