Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

RMAN : Recovery of Control files


RMAN> report schema;
Note : we cannot see the controlfile location in RMAN.
SQL> select name from v$controlfile;
oracle venu> ls
oracle venu> rm control01.ctl
oracle venu> ls
RMAN> validate database;
RMAN> shutdown abort
SQL> shut abort
oracle> rman target /
RMAN> startup nomount
RMAN> restore controlfile from '/u03/rmanbkp/control01.ctl';
RMAN> alter database mount;
RMAN> recover database;
RMAN> sql 'alter database open resetlogs';
Related Posts Plugin for WordPress, Blogger...

Flag Counter