Recovering Database running in NOARCHIVELOG mode using RMAN Continued...

Step 3

After restoring the controlfile to "/u02/oracle/testdb/" directory, shutdown the instance and copy just restored controlfile to original locations

$sqlplus

Enter User: / as sysdba
SQL>shutdown immediate;
SQL>Exit
$

Copy controlfile to original locations

$ cp control.ora ./test/control01.ctl
$ cp control.ora ./test/control02.ctl

Step 4

Start RMAN and Start and mount the database

start the database

Now give RESTORE DATABASE command

RMAN> restore database

restore database

NEXT STEP

New: Modern Oracle

Concepts here also apply to Oracle 19c/21c/23ai unless a version note says otherwise. See the homepage for what's changed.