1.

How To Check What Protection Mode Of Primary Database In Your Oracle Data Guard?

Answer»

By using following QUERY you can check protection mode of primary database in your Oracle DATA GUARD setup. SELECT PROTECTION_MODE FROM V$DATABASE;

For Example: SQL> select protection_mode from v$database;

PROTECTION_MODE

——————————–

MAXIMUM PERFORMANCE

By using following query you can check protection mode of primary database in your Oracle Data Guard setup. SELECT PROTECTION_MODE FROM V$DATABASE;

For Example: SQL> select protection_mode from v$database;

PROTECTION_MODE

——————————–

MAXIMUM PERFORMANCE



Discussion

No Comment Found