Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Disable Oracle Data Guard - Urgent

774627May 23 2010 — edited Jun 11 2010
Hello 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 9 2010
Added on May 23 2010
9 comments
5,436 views