A technical troubleshooting blog about Oracle with other Databases & Cloud Technologies.

De-configure MRP in Standby

1 min read
On Source, as Oracle user:
export ORACLE_SID=<source_sid>
sqlplus '/as sysdba'
 
alter system set log_archive_dest_state_<whatever_#_used>='DEFER' scope=both sid='*';
alter system set log_archive_dest_<whatever_#_used>='' scope=both sid='*';
alter system set log_archive_config='dg_config=(<only the db_unique_name's needed>)' scope=both sid='*';
On Target, as Oracle user:
export ORACLE_SID=<target_sid>
sqlplus '/as sysdba'
 
alter database recover managed standby database cancel;
alter system set log_archive_config='' scope=both sid='*';
alter system set fal_client='' scope=both sid='*';
alter system set fal_server='' scope=both sid='*';

Hope it helped !! 🙂