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

Step 5

After restoring is finished, open the database by resetting the logs by typing the following command

RMAN>alter database open resetlogs

alter database open

That's it the database is restored but since the database is running in NOARCHIVELOG mode you will loose the transactions occurred after the last full backup. If possible you have to reenter all lost transactions manually which is difficult in most of the cases.

 

 

 

 

 

 

 

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.