-
Dr
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
-
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
Code:
ALTER SYSTEM SET LOG_ARCHIVE_DEST_2 = '';
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2 = DISABLE;
ALTER SYSTEM SET STANDBY_ARCHIVE_DEST = '';
COMMIT;
Hopefully this will fix
Sam
-
Except for log_archive_start, all other parameters are dynamic.