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

Rman encryption and other techniques

Today I will demonstrate Recovery Manager features, especially encryption and some other techniques. First of all let me note about RMAN backup encryption. Staring from Oracle 10g RMAN now creates encrypted backups that cannot be restored by unauthorized people. There are 3 modes of backup encryption: * Transparent encryption * Password encryption * Dual-mode encryption using either transparent or password encryption All RMAN backups are not encrypted but you can encrypt any RMAN backup in the form of a backup set. In this tutorial I will show you how to configure Password encryption. Let`s finish talking and start to demonstrate. check parameters with "SHOW ALL" command, by default encryption is OFF RMAN> show all; RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTR...
4 comments
Read more

ORA-03206: maximum file size of (5242880) blocks in AUTOEXTEND clause is out of range

Today when I want to change max size of datafile I got strange error. ALTER DATABASE DATAFILE '/u01/app/oracle/oradata/MYDB/users01.dbf' AUTOEXTEND ON NEXT 1280K MAXSIZE 32GB ORA-03206: maximum file size of (5242880) blocks in AUTOEXTEND clause is out of range Here is reason: The maximum file size for an autoextendable file has exceeded the maximum number of blocks allowed. After research internet I found that instead of using 32GB we can use 32767M. (same values but in MB). Or you may use 31GB too. ALTER DATABASE DATAFILE '/u01/app/oracle/oradata/MYDB/users01.dbf' AUTOEXTEND ON NEXT 1280K MAXSIZE 32767M;
Post a Comment
Read more

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