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
change the log destination state:
What you do is change the log destination state:
ALTER SYSTEM SET log_archive_dest_state_n = 'DEFER';