I have configured my test database on Oracle 9i Enterprise Edition for archiving. I enabled all the features necessary for archiving, but when I try to test it by switching the log file then the archiver from the V$instance it shows me the status as failed. Kindly suggest what I should do, I would be highly obliged.

    Requires Free Membership to View

    Login

Are there any error messages in the alert log? Did you also query v$log for additional information? Without more information, it's difficult to troubleshoot a problem like this. To put a database into archivelog mode, two things must happen:
  • You must set the proper initialization parameters in either the init.ora or spfile.
  • The database must be altered to change it from noarchivelog mode into archivelog mode.
For a detailed, step-by-step procedure to enabling archivelog mode in a database refer to the Oracle9i Release 2 (9.2) Database Administrator's Guide.

Remember to take a database backup before you change the archiving mode of the database.

This was first published in May 2007

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top