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.
