Skip to main content

Remove Data Guard Configuration Oracle 11g

Today I will show you how to remove DG configuration

DGMGRL> show configuration;  
 Configuration  
  Name:        DGMANAGER  
  Enabled:       YES  
  Protection Mode:   MaxAvailability  
  Databases:  
   PROD - Primary database  
   STAND - Physical standby database  
 Fast-Start Failover: DISABLED  
 Current status for "DGMANAGER":  
 SUCCESS  

 DGMGRL> remove configuration;  
 Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode  
 Failed.

I tried to remove database from configuration

DGMGRL> remove database "STAND";  
 Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode  
 Failed.

But result was same. Unsuccess.

I changed protection mode to MaxPerformance and then retied again

DGMGRL> edit configuration set protection mode as MaxPerformance;  
 Succeeded.  

DGMGRL> show configuration;  
 Configuration  
  Name:        DGMANAGER  
  Enabled:       YES  
  Protection Mode:   MaxPerformance  
  Databases:  
   PROD - Primary database  
   STAND - Physical standby database  
 Fast-Start Failover: DISABLED  
 Current status for "DGMANAGER":  
 SUCCESS  

DGMGRL> remove database "STAND"  
 Removed database "STAND" from the configuration  
 DGMGRL> remove configuration;  
 Removed configuration  
 DGMGRL> show configuration  
 Error: ORA-16532: Data Guard broker configuration does not exist  
 Configuration details cannot be determined by DGMGRL  
 DGMGRL>

Dataguard configuration successfully removed. Now we have to disable some parameters.

SQL> set linesize 200  
 SQL> show parameter dg_broker  
 NAME                 TYPE               VALUE  
 ------------------------------------ --------------------------------- ------------------------------  
 dg_broker_config_file1        string              /u01/app/oracle/product/11.1.0  
                                     /db_1/dbs/dr1PROD.dat  
 dg_broker_config_file2        string              /u01/app/oracle/product/11.1.0  
                                     /db_1/dbs/dr2PROD.dat  
 dg_broker_start           boolean              TRUE  
 SQL>


Change dg_broker_start`s value to FALSE on both side

alter system set dg_broker_start=FALSE;

At the end
remove dr*.dat files on both side

 -bash-3.00$ pwd  
 /u01/app/oracle/product/11.1.0/db_1/dbs  
 -bash-3.00$ ls -lrt dr*.dat  
 -rw-r-----  1 oracle  oinstall    1024 Jul 07 12:25 dr2PROD.dat  
 -rw-r-----  1 oracle  oinstall    1024 Jul 07 12:25 dr1PROD.dat  
 -bash-3.00$ rm dr*.dat  


 -bash-4.2$ pwd  
 /u01/app/oracle/product/11.0.1/db_1/dbs  
 -bash-4.2$ ls -lrt dr*.dat  
 -rw-r-----  1 oracle  oinstall    1024 Jul 07 12:24 dr2STAND.dat  
 -rw-r-----  1 oracle  oinstall    1024 Jul 07 12:24 dr1STAND.dat  
 -bash-4.2$ rm dr*.dat

Comments

Post a Comment

Popular posts from this blog

Fix ORA-01139: RESETLOGS option only valid after an incomplete database recovery

While shutting down my TEST database process was hanged. Then I had to use shutdown abort. But when I wanted to start database it did not open. SQL> select name from v$database; NAME --------- TEST SQL> shut abort; ORACLE instance shut down. SQL> startup mount ORACLE instance started. Total System Global Area 6597406720 bytes Fixed Size 2265664 bytes Variable Size 3204451776 bytes Database Buffers 3372220416 bytes Redo Buffers 18468864 bytes Database mounted. SQL> alter database open; alter database open * ERROR at line 1: ORA-03113: end-of-file on communication channel Process ID: 6552 Session ID: 191 Serial number: 3  What`s wrong?  SQL> alter database open resetlogs; ERROR:    ORA-03114: not connected to ORACLE    SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Pr...
9 comments
Read more

Fix: ORA-13639: The current operation was interrupted because it timed out.

Sometimes SQL Tuning Advisor interrupts cause time limit took more than defined. You have to analyze it or increase value. Here you can see increasing of value. Example result of sql select                  execution_name, advisor_name,                  to_char(execution_start,'dd-mon-yy hh:mi:ss') execution_start,                  to_char(execution_end,'dd-mon-yy hh:mi:ss') execution_end, status,error_message from dba_advisor_executions where task_name = 'SYS_AUTO_SQL_TUNING_TASK' order by execution_start; Check value of TIME_LIMIT`s parameter : SQL> column parameter_value for A35 SQL> select parameter_name, parameter_value from dba_advisor_parameters where task_name = 'SYS_AUTO_SQL_TUNING_TASK' and parameter_name in ('TIME_LIMIT', 'DEFAULT_EXECUTION_TYP...
Post a Comment
Read more

How to fix ORA-26040: Data block was loaded using the NOLOGGING option

Today I faced with new ORA error. After solving I want to share this experience with yours. So, today 5`th datafile of my database was corrupted (/u01/app/oracle/oradata/ulfet_db/example01.dbf). After recover via RMAN I saw strange error. RMAN> recover datafile 5 block 443; Starting recover at 24-MAR-13 using channel ORA_DISK_1 channel ORA_DISK_1: restoring block(s) channel ORA_DISK_1: specifying block(s) to restore from backup set restoring blocks of datafile 00005 channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/ULFET_DB/backupset/2013_03_24/o1_mf_nnndf_TAG20130324T223233_8nykp220_.bkp channel ORA_DISK_1: piece handle=/u01/app/oracle/flash_recovery_area/ULFET_DB/backupset/2013_03_24/o1_mf_nnndf_TAG20130324T223233_8nykp220_.bkp tag=TAG20130324T223233 channel ORA_DISK_1: restored block(s) from backup piece 1 channel ORA_DISK_1: block restore complete, elapsed time: 00:00:03 starting media recovery media recovery complete, elapsed ti...
2 comments
Read more