-
log_archive_start
Hi.
I set this parameter to true in my initsid.ora and got the below when doing a archive log list.
Database log mode No Archive Mode
Automatic archival Enabled
Is it working as designed that the "database log mode" is no archive mode?
My understanding is that with this parameter set to true, the database log mode will be automatic without doing a series of other commands to make it automatic?
Please advise.
-
obviously your understanding is incorrect
mount and alter database archive log
-
To expand on pando's statement, review the online documents:
http://download-west.oracle.com/docs...hredo.htm#4790
-
Hi,
from the url, i got the below
Enabling Automatic Archiving at Instance Startup
To enable automatic archiving of filled groups each time an instance is started, include the initialization parameter LOG_ARCHIVE_START in the database's initialization parameter file and set it to TRUE:
LOG_ARCHIVE_START=TRUE
The new value takes effect the next time you start the database.
This is my understanding as well.
and yes, i know that the commands below will help to resolve this
Database log mode No Archive Mode
1) startup mount
2) alter database archivelog;
3) alter database open;
But besides the above commands, could we make this automatic when it startsup?
-
Basically the parameter log_archive_start=true starts archiver processes automatically at instance startup. but to enable archiving u have to use these commands
1. startup mount;
2. alter database archivelog; (This will enable archiving)
3. alter database open;
No we caught make it automatic and u have to enter step 2. manually to enable archiving.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|