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?
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
Hopefully this will fix
ALTER SYSTEM SET LOG_ARCHIVE_DEST_2 = '';
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2 = DISABLE;
ALTER SYSTEM SET STANDBY_ARCHIVE_DEST = '';
Life is a journey, not a destination!
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
Click Here to Expand Forum to Full Width