How to configure test database for archiving
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.
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