DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2001
    SVRMGR> alter database rsdev01 archivelog;
    alter database rsdev01 archivelog
    ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

    What does it mean and how do I turn on ARCHIVELOG mode?

  2. #2
    Join Date
    Aug 2000
    If you have to turn on the archiving, you have to startup the DB in "mount" mode and then issue the following command.
    "alter database archivelog"

    svrmgrl> shutdown immediate ;

    svrmgrl> startup mount ;

    svrmgrl> alter database archivelog ;

    To enable the automatic archiving you have to set the following line in the init.ora file before restarting the instance .


    You can dynamically do this by,

    svrmgrl> alter system archive log start ;

  3. #3
    Join Date
    Oct 2000
    ORA 00265 MEANS" The database either crashed or was shut down 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"

    Then do what gsprince has described.
    John Doyle

  4. #4
    Join Date
    Jan 2001
    your error message came from shutdown process. you must shutdown instance using shutdown abirt. then it need instance recovery. shut it down using normal or immediate and then turn archive log on.

  5. #5
    Join Date
    Feb 2001

    Thumbs up

    Thanks! It worked.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.