Tuesday, February 16, 2010

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

SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode


SQL> !
$ oerr ora 265
00265, 00000, "instance recovery required, cannot set ARCHIVELOG mode"
// *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.
// *Action: Open the database and then enter the SHUTDOWN command with the
// NORMAL or IMMEDIATE option.

No comments:

Post a Comment

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...