restore controlfile

Posted by Roshan on Aug 07, 2017; 4:46am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/restore-controlfile-tp3111.html

Oracle Database 12c
Hi,

I am planning to restore controlfile from tape after a crash. Below is my script

connect target sys/m@cbstst;
connect auxiliary /;

run {

ALLOCATE AUXILIARY CHANNEL CH4 TYPE 'SBT_TAPE';

SEND 'NSR_ENV=(NSR_SERVER=rhis-nwdd-1202,NSR_CLIENT=10.210.228.7)';
#restore clone primary controlfile to '/archicom/ora12c/oradata/control1.ctl';
restore until time 'sysdate-4' clone primary controlfile;
}

I have connected target to a test instance because production has crashed. I am getting error below

released channel: CH4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/07/2017 08:47:14
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore

RMAN> **end-of-file**

I can see the controlfile has been backed up on tape.

Thanks,
Roshan