<<Back to Oracle DataGuard Main Page
Disabling Active Data Guard Feature in Oracle Physical Standby Database.
As we know oracle active data guard (also know as Physical Standby in read only with apply) is a licences feature, and one has to pay to use it.
There are also several known bugs , which hits the database when using this Oracle ADG features
eg.
Bug 28199085
or RMAN issues like
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of partial resync command on default channel at 09/03/2019 05:56:24
RMAN-20051: datafile resync not completed
So if we don't need this feature I strongly advise to keep it off (deactivated)
How to deactivate the Active Data Guard Feature
Deactivating of oracle active data guard feature requires setting of hidden parameter _query_on_physical to false. Ensure to set the parameter in both primary as well as standby database. Its a static parameter and therefore will be effective only after restart of the database hence downtime required.
SQL> show parameter "_query_on_physical"
SQL> alter system set "_query_on_physical"=false scope=spfile;
System altered.
SQL> startup force;
ORACLE instance started.
Total System Global Area 3221225472 bytes
Fixed Size 2929552 bytes
Variable Size 1962937456 bytes
Database Buffers 1241513984 bytes
Redo Buffers 13844480 bytes
Database mounted.
ORA-16669: instance cannot be opened because the Oracle Active Data Guard
option is disabled
SQL> show parameter "_query_on_physical"
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
_query_on_physical boolean FALSE
SQL>
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
ORACLD MOUNTED PHYSICAL STANDBY
NOTE: This is not recommended by oracle. For more details read Doc ID 2269239.1
Comments
Post a Comment