Dr

[netbar]

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

[sambavan]

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

     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

[LKBrwn_DBA]

Except for log_archive_start, all other parameters are dynamic.