archivelog not starting
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: archivelog not starting

  1. #1
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    I want to start my database from nonarchivelog to archivelog
    I did following.
    1. changes in initparameter

    log destination
    log archive true
    2. shutdown database and start with mount (no open)
    3. fire alter dtaabase archivelog as well as alter system archive log start.

    it says stament processed but still it is not starting archiving ...

    What's the problem might be.
    How can I start archive log mode...


    kumud

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    did you switch logfile a couple times to make sure?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Aug 2001
    Posts
    390
    You can enable archiving munually

    1. shutdown immediate
    2. startup mount
    3. alter database dbname archivelog;
    4. alter database dbname open;
    5. archive log all


    now check your database to be sure it's running archiveg log mode by typing ARCHIVE LOG LSIT


    good luck


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