DG: PROTECTION_MODE UNPROTECTED
edited Feb 16, 2013 2:25AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 9 commentsAnswered ✓
We Implemented DG ( Oracle 10.2.0.5) on X4270M2 ( RAC solution) , everything is working properly and replication is smooth even in peak hours…But when extending the checks on standby the protection_mode is UNPROTECTED
SQL> column ROLE format a7 tru
SQL> column NAME format a8 wrap
SQL> select name,database_role,log_mode,protection_mode
2 from v$database;
NAME DATABASE_ROLE LOG_MODE PROTECTION_MODE
-------- ---------------- ------------ --------------------
VSDB_S2 LOGICAL STANDBY ARCHIVELOG UNPROTECTED
1 row selected.
As per oracle support documentation, it is a bug corrected in 10.2.0.5. Bug 6488551 - The PROTECTION_MODE column in V$DATABASE shows "UNPROTECTED" at ASYNC LNS [ID 6488551.8]
0