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

What you do is change the log destination state:

Code:

---

ALTER SYSTEM SET log_archive_dest_state_n = 'DEFER';

---

;)

LKBrwn_DBA,

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


Tim

hail the magic of Oracle documentation http://download-west.oracle.com/docs...tparams101.htm

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

I don't think you want to do #1 (the local archive log location):

Code:

---

ALTER SYSTEM SET log_archive_dest_state_1 = 'DEFER';

---

:rolleyes: