LOG_ARCHIVE_START in oracle 9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: LOG_ARCHIVE_START in oracle 9i

  1. #1
    Join Date
    May 2002
    Posts
    163

    LOG_ARCHIVE_START in oracle 9i

    Hi,

    In oracle 8i I used to set the following parameters before opening my database in archive mode
    log_archive_start =
    log_archive_dest_1 =
    log_archive_format =

    Presently I created a database in oracle 9i and the init file that got created automatically, these parameters are missing there.

    Then I tried to configure those thru SPFILE , but while trying the same I am getting the following error. How to resove this prob. I would like to set those parameters in my 9i database.

    SQL> alter system set log_archive_start=TRUE
    scope=BOTH;

    alter system set log_archive_start=TRUE
    *
    ERROR at line 1:
    ORA-02095: specified initialization parameter cannot be modified

    Regards
    Nwcomer
    Student

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

  3. #3
    Join Date
    May 2002
    Posts
    163
    Hi,

    I already tried that

    shutdown immediate;
    startup mount;
    alter database archivelog;
    archive log start;
    alter database open;

    But I would like to make it automatically, like in 8i what I did. So how to update my parameter file?

    Regards
    Nwcomer
    Student

  4. #4
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    Re: LOG_ARCHIVE_START in oracle 9i

    Originally posted by newcomer
    SQL> alter system set log_archive_start=TRUE
    scope=BOTH;

    alter system set log_archive_start=TRUE
    *
    ERROR at line 1:
    ORA-02095: specified initialization parameter cannot be modified
    You cannot modify this parameter dynamically, without bouncing the database.

    http://download-west.oracle.com/docs...hredo.htm#4751

    HTH.

  5. #5
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by newcomer
    Hi,

    But I would like to make it automatically, like in 8i what I did. So how to update my parameter file?

    Regards
    There are some prams which can be modified dynamiclly and in effect without bouncing the DB ( but will be effective until bounce ). but this 1 cant be done.

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  6. #6
    Join Date
    Nov 2008
    Posts
    1
    use
    alter system log_archive_start=true scope=spfile;

    it will alter the parameter in spfile dynamically so that it will be true at next startup also
    and use
    alter system archive log start;
    for current instance of the database
    its working with oracle 9r2

    Good bye

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