how to add log_archive_duplex_dest without shutdown
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: how to add log_archive_duplex_dest without shutdown

Hybrid View

  1. #1
    Join Date
    Apr 2002
    Posts
    61
    Hi,
    I have the following setting in my init file right now and the database is up and running:
    ##### For archiving if ARCHIVELOG is on ########
    LOG_ARCHIVE_DEST =O:\Ora_archivelog\Orant\database
    LOG_ARCHIVE_FORMAT =QIS1%S.arc
    LOG_ARCHIVE_START=TRUE
    text_enable=TRUE
    ##########

    I need to add a second destination for the archive logs without brining the database down. I am looking for the statements. Please reply.
    Thanks,
    Ramesh

  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    log_archive_max_processes = 1
    log_archive_start = true
    LOG_ARCHIVE_MIN_SUCCEED_DEST = 1
    log_archive_dest_1 = "location=DISK$ORADATA:[ORACLE_UTF8.DB_ANIMO.ADMIN.ARCH] MANDATORY"
    log_archive_format = arch_%t_%s.arc
    log_archive_dest_state_1 = enable


    alter system set log_archive_dest_2 = "location=DISK$ORADATA:[ORACLE_UTF8.DB_ANIMO.ADMIN.ARCH1] OPTIONAL"
    alter system set log_archive_dest_state_2 = enable;
    Best wishes!
    Dmitri

  3. #3
    Join Date
    Apr 2002
    Posts
    61

    Thanks

    Thanks for the quick reply. It worked.
    Ramesh

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