Defer Archive log Oracle 10G R2
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Defer Archive log Oracle 10G R2

  1. #1
    Join Date
    Jan 2001
    Posts
    91

    Post Defer Archive log Oracle 10G R2

    I'm currently running Oracle 10G R2 on SLES 10SPK2.

    We are in the process of doing a Software Upgrade and my vendor recommend that we defer the Archive logs on our DB , we push Archive to 2 standby db's one is local and the other is at our DR Site. would I use the following on my prod db to defer and restart the Archive logs when the upgrade is done


    alter system archive log stop

    alter system archive log start


    Thanks

    Tim

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    no, you would not do that

    look up the dataguard manuals about deffering applying nogs, none of it involves turning archive logging off

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

    Cool change the log destination state:

    What you do is change the log destination state:

    Code:
    ALTER SYSTEM SET log_archive_dest_state_n = 'DEFER';
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  4. #4
    Join Date
    Jan 2001
    Posts
    91

    Post

    LKBrwn_DBA,

    When I'm ready to start archiving processs again do I replace DEFER with UNDEFER?? or something


    Tim

  5. #5
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    hail the magic of Oracle documentation http://download-west.oracle.com/docs...tparams101.htm
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  6. #6
    Join Date
    Jan 2001
    Posts
    91

    Post

    Ok I see there is a n in the >>

    ALTER SYSTEM SET log_archive_dest_state_n = 'DEFER';

    it seems that the n represent a log destination,

    below is the results of show parameter log_archive_dest

    --------

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    log_archive_dest string
    log_archive_dest_1 string location=/ap01/oracle/admin/sm
    prod1/arch
    log_archive_dest_10 string
    log_archive_dest_2 string SERVICE=standby_rpt lgwr optio
    nal async=20480 affirm reopen=
    120 net_timeout=30
    log_archive_dest_3 string SERVICE=standby_dr lgwr option
    al async=20480 affirm reopen=1
    20 net_timeout=30
    log_archive_dest_4 string SERVICE=standby_06 lgwr option

    ----------------------------------------------------------------------------


    so do this mean when I do the defer I use the following:

    ALTER SYSTEM SET log_archive_dest_state_1 = 'DEFER';
    ALTER SYSTEM SET log_archive_dest_state_2 = 'DEFER';
    ALTER SYSTEM SET log_archive_dest_state_3 = 'DEFER';
    ALTER SYSTEM SET log_archive_dest_state_4 = 'DEFER';

    then to re-enable use:

    ALTER SYSTEM SET log_archive_dest_state_1 = 'ENABLE';
    ALTER SYSTEM SET log_archive_dest_state_2 = 'ENABLE';
    ALTER SYSTEM SET log_archive_dest_state_3 = 'ENABLE';
    ALTER SYSTEM SET log_archive_dest_state_4 = 'ENABLE';


    Thanks

  7. #7
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,469

    Cool Not #1

    I don't think you want to do #1 (the local archive log location):
    Code:
    ALTER SYSTEM SET log_archive_dest_state_1 = 'DEFER';
    "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