-
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
-
no, you would not do that
look up the dataguard manuals about deffering applying nogs, none of it involves turning archive logging off
-
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
-
LKBrwn_DBA,
When I'm ready to start archiving processs again do I replace DEFER with UNDEFER?? or something
Tim
-
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.
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|