READ ONLY Before RESETLOGS (11g)

A new feature in Oracle 11g is that after incomplete recovery of a database, you can now open the database in read only mode before opening in resetlog mode.

This now enables you to check the status of your recovery. The point in time etc, before commiting to the change.

Gives you another opportunity to resume recovery!

ALTER DATABASE OPEN READ ONLY;

ALTER DATABASE OPEN RESET LOGS;