ora - 16005 and its solution

ORA  – 16005 and its solution

At DR site we have a database that we do recovery on it on daily basis and after completion of the recovery we have to open it in read only mode.  One fine day I did everything as usual on the database. I applied the redo and control file of production database on it and completed the recovery using recover database command. There was no error till this activity. But as soon as I tried this database in read only mode I got error ora -16005.

SQL>  alter database open read only;

 alter database open read only

*

ERROR at line 1:

ORA-16005: database requires recovery

To resolve the problem I followed below steps:-

1.       Shutdown the database

                SQL> shut immediate

ORA-01109: database not open

  

Database dismounted.

ORACLE instance shut down.

2.       Started the database in restrict mode.

SQL> startup restrict;

ORACLE instance started.

Total System Global Area   35025056 bytes

Fixed Size                    73888 bytes

Variable Size              28307456 bytes

Database Buffers            6553600 bytes

Redo Buffers                  90112 bytes

Database mounted.

Database opened.

3.       Again shutdown the database.

SQL> shut immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

  

4.       Mounted the database and opened the database in read only mode.

SQL> startup mount

ORACLE instance started. 

Total System Global Area   35025056 bytes

Fixed Size                    73888 bytes

Variable Size              28307456 bytes

Database Buffers            6553600 bytes

Redo Buffers                  90112 bytes

Database mounted.

SQL> alter database open read only;

Database altered.