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?
Cheers