DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: log_archive_start

  1. #1
    Join Date
    Oct 2002
    Posts
    391

    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.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    obviously your understanding is incorrect

    mount and alter database archive log

  3. #3
    Join Date
    May 2005
    Location
    AZ, USA
    Posts
    131
    To expand on pando's statement, review the online documents:
    http://download-west.oracle.com/docs...hredo.htm#4790

  4. #4
    Join Date
    Oct 2002
    Posts
    391
    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?

  5. #5
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78
    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.

  6. #6
    Join Date
    Oct 2002
    Posts
    391
    thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width