Disable Oracle Data Guard - Urgent
774627May 23 2010 — edited Jun 11 2010Hello All,
I am in a peculiar situation and any help is appreciated.
I have a Primay Database and one Physical standby database and they are in Sync. Now, my client wants me to disable data guard and run these two databases as independent one. While performing this activity, there should not be any downtime on Primary. There is no data guard broker involved.
PRIMARY SETUP
==========
*.log_archive_config='dg_config=(APR1,DRAPR1)'#used
*.LOG_ARCHIVE_DEST_1='LOCATION=/PR1_u12/oraAPR1/archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=APR1'#used
*.LOG_ARCHIVE_DEST_2='SERVICE=DRAPR1 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=DRAPR1'#used
*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'#used
.standby_archive_dest='/PR1_u12/oraAPR1/archive'#used
PHYSICAL STANDBY SETUP
=================
*.fal_client='DRAPR1'#used
*.fal_server='APR1'#used
*.log_archive_config='dg_config=(DRAPR1,APR1)'#used
*.LOG_ARCHIVE_DEST_1='LOCATION=/PR1_u12/oraAPR1/archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=DRPR1'#used
*.LOG_ARCHIVE_DEST_2='SERVICE=APR1 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=APR1'#used
*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'#used
*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'#used
*.standby_archive_dest='/PR1_u12/oraAPR1/archive'#used
*.standby_file_management='auto'#used
How do i make these two databases as independant database without having downtime in PRIMARY. Please help.