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

Thread: Dr

  1. #1
    Join Date
    Jul 2001
    Posts
    181

    Dr

    I am decommsion are DR site which is 8.1.7 standby the production init.ora has the following entries:

    log_archive_start = TRUE # set to true when activated
    LOG_ARCHIVE_FORMAT = ETSPROD_%t_%s.arch

    LOG_ARCHIVE_DEST_1 = 'LOCATION=/oraclefs/archive/ETSPROD MANDATORY REOPEN=15'
    LOG_ARCHIVE_DEST_STATE_1 = ENABLE

    LOG_ARCHIVE_DEST_2 = 'SERVICE=standby_etsprod OPTIONAL REOPEN=15' # 15 seconds
    LOG_ARCHIVE_DEST_STATE_2 = ENABLE

    STANDBY_ARCHIVE_DEST = /oraclefs/archive/ETSPROD # should be set to same as primary

    Can I disable the shipping to the standby without having to bounce the db. Can the changes be made on the fly and also with the removal of standby from tns?

    Cheers

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Since the parameters

    LOG_ARCHIVE_DEST & STANDBY_ARCHIVE_DEST are of dynamic parameters in 8.1.7, you can reset them as follows

    Login as sys@sid as sysdba
    Code:
         ALTER SYSTEM SET LOG_ARCHIVE_DEST_2 = '';
         ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2 = DISABLE;
         ALTER SYSTEM SET STANDBY_ARCHIVE_DEST = '';
    
         COMMIT;
    Hopefully this will fix

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,471

    Cool

    Except for log_archive_start, all other parameters are dynamic.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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