Re: restore controlfile

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

The controlfile is on tape backup. I have to restore controlfile. Can you please help with the script? DB is in nomount mode

connect target / ;
connect auxiliary /;
set DBID=878411589

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 controlfile from 'c-878411589-20170728-00';
}


Thanks