Q

Can't force a log switch

I still can't force a log switch. The result of archive log list on my database is as follows:

Database log mode    Archive mode
Automatic archival   Disabled
Archive destination  D:oracleora81RDBMS
Oldest online log sequence  332
Next log sequence           332
Current log sequence        335
With this result kindly tell me if anything is wrong. There is enough space in the archive destination.

Your database is in Archivelog mode, but you have not enabled automatic archival. Make sure that you have set the LOG_ARCHIVE_DEST or LOG_ARCHIVE_DEST_n parameters correctly. You'll also need to set LOG_ARCHIVE_FORMAT and set LOG_ARCHIVE_START=TRUE. Then shutdown your database and restart it. Now that you have LOG_ARCHIVE_START=TRUE, you should see "Automatic archival Enabled" when you issue ARCHIVE LOG LIST.


This was first published in July 2004
This Content Component encountered an error

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close