aravindhreturns

 Profile Answers by aravindhreturns 

• Apr 22nd, 2010

 

Use these two methods to get the control file from autobackup:-
(This applies only if you have configured AUTOBACKUP ON)

One:-
First, Login to RMAN (RMAN Target /)

Set the DBID by querying v$database (SELECT DBID FROM V$DATABASE;)
SET DBID 3386862614

Then run the following in RMAN to get your controlfile backup:-
RUN {RESTORE CONTROLFILE FROM AUTOBACKUP;}

Thats it. You're done.

(or)

Two:-
after logging into RMAN (RMAN Target /)

Use this command to restore it from
restore until time 'sysdate-3' CONTROLFILE to 'c:tempcfile' from autobackup;
(The until time clause sets time of validity for CONTROLFILE)

Though I have just listed two, There are still many other complicated methods in RMAN to get your control file.