Thursday, January 9, 2014

ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

Error: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

Details: This error occurs when switch databas eto ARCHIVELOG mode by executing:
ALTER DATABASE ARCHIVELOG;

Cause:The database either crashed or was shutdown with the ABORT option. Media recovery cannot be enabled because the online logs may not be sufficient to recover the current datafiles.

Solution:Open the database and then enter the SHUTDOWN command with the NORMAL or IMMEDIATE option:
>ALTER DATABASE OPEN;

>SHUTDOWN IMMEDIATE; 

No comments:

Post a Comment