Hi,
Scenario:
I want to test my DB backup from TAPE by recovering in a new server in a new location.
Target:
I did the pre-requisite by creating password file and copy the pfile and change the new destinations (controlfile, diag_dest etc). Using the new pfile in Target server DB is nomount stage.
I tried to restore the control file from the backup.I got the below
Starting restore at 20-MAY-16
channel CH1: looking for AUTOBACKUP on day: 20160520
channel CH1: looking for AUTOBACKUP on day: 20160519
channel CH1: looking for AUTOBACKUP on day: 20160518
channel CH1: looking for AUTOBACKUP on day: 20160517
channel CH1: looking for AUTOBACKUP on day: 20160516
channel CH1: looking for AUTOBACKUP on day: 20160515
channel CH1: looking for AUTOBACKUP on day: 20160514
channel CH1: no AUTOBACKUP in 7 days found
released channel: CH1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/20/2016 14:00:40
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
In Source DB I login into RMAN and check list backup of controlfile, I found the below one
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1073 Full 41.50M SBT_TAPE 00:00:59 20-MAY-16
BP Key: 1073 Status: AVAILABLE Compressed: NO Tag: TAG20160520T011000
Handle: control_c-1016433097-20160520-04 Media: @aaaaf
Control File Included: Ckp SCN: 448575846 Ckp time: 20-MAY-16
I tried using the Handle to restore the controlfile, I am getting below.
RMAN> RUN
{
ALLOCATE CHANNEL CH1 DEVICE TYPE sbt_tape send 'NB_ORA_POLICY=oracle-laph0097-PDS_OR3-DB,NB_ORA_SERV=freedon.nml.com';
restore controlfile from 'control_c-1016433097-20160520-04';
RELEASE CHANNEL CH1;
}2> 3> 4> 5> 6>
allocated channel: CH1
channel CH1: SID=1563 device type=SBT_TAPE
channel CH1: Veritas NetBackup for Oracle - Release 7.6 (2014102419)
Starting restore at 20-MAY-16
channel CH1: no AUTOBACKUP in 7 days found
released channel: CH1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/20/2016 14:02:21
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
Can anyone suggest why RMAN is not discovering the AUTOBACKUP, since it is enabled. Also why I am not able to restore from piece.
Thank you,
Sreeni