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

Thread: archive log mode

  1. #1
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Hello,
    i need to perminantly turn archive log mode on?
    any suggestions?

    thanks
    Jigar

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    suggestions for...? just do it

  3. #3
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Good Idea, go ahead an do it!
    Thanks
    Kishore Kumar

  4. #4
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    i actually needed the syntax and the know how on how to do it.

    thanks

  5. #5
    Join Date
    Nov 2000
    Posts
    56
    Ok, what do you do is set the parameter for
    log_archive_start
    log_archive_dest_1 or log_archive_dest
    log_archive_format
    in init.ora found in oracle_home\admin\sid\pfile
    Log_archive_start should be true
    log_archive_dest_1 or log_archive_dest, whichever version you are using. Here you should indicate the dir, in which you are going to store the archive files, mention the full path.
    log_archive_format usually the format in which you want to store the archive files, something like arch%t%s.log. Here %t refers to the redo log thread number and %s refers to the log sequence number.

    Shut down the database with immediate or normal option.
    connect to sqlplus as internal
    startup the database with MOUNT option
    issue
    alter database archivelog
    then open the database
    this will enable archiving of the database permanently.
    Rama

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