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 Full database


RMAN> report schema;
oracle> cd /u01/app/oracle/venu
oracle venu> ls
oracle venu> rm *
oracle venu> ls
RMAN> validate database;
RMAN> shutdown abort
RMAN> startup nomount
RMAN> restore controlfile from '/u03/rmanbkp/control01.ctl';
RMAN> alter database mount;
RMAN> restore database;
RMAN> recover database;
RMAN> sql 'alter database open resetlogs';
Note : If we want to use any SQL command in RMAN prompt, specify 'sql' infront of the single quote sql command like above.

Related Posts Plugin for WordPress, Blogger...

Flag Counter