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

Thread: archivelog not starting

  1. #1
    Join Date
    May 2000
    fremont ca
    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...


  2. #2
    Join Date
    Nov 2000
    did you switch logfile a couple times to make sure?
    Jeff Hunter
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Aug 2001
    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