Q
Manage Learn to apply best practices and optimize your operations.

How to configure test database for archiving

I have configured my test database for archiving. I enabled all the features necessary for archiving, but when I try to test it, it shows me the status as failed.

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.

Dig Deeper on Oracle database installation, upgrades and patches

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close