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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

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