PROTECTION_MODE is UNPROTECTED at standby database Analysis

PROTECTION_MODE is UNPROTECTED at standby database analytics database version

SQL> select * from v$version;BANNER--------------------------------------------------------------------------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64biPL/SQL Release 10.2.0.1.0 - ProductionCORE    10.2.0.1.0      ProductionTNS for Linux: Version 10.2.0.1.0 - ProductionNLSRTL Version 10.2.0.1.0 – Production

 

1. Problem description (data guard adopts the maximum performance mode, but the PROTECTION_MODE of the standby database is UNPROTECTED ?)

Master database SQL> select databases, OPEN_MODE, PROTECTION_MODE from v $ database; DATABASE_ROLE OPEN_MODE PROTECTION_MODE too many primary read write maximum performance slave database SQL> select DATABASE_ROLE, OPEN_MODE, PROTECTION_MODE from v $ database; DATABASE_ROLE OPEN_MODE PROTECTION_MODE -------------------------------------------------------------------------------- PHYSICAL STANDBY MOUNTED UNPROTECTED

 

2. Problem description: The slave database logs are normally used. The master database performs DML operations. You can also see DML results when the slave database read is only enabled. It indicates that this data guard is correct. But why does the standby database PROTECTION_MODE show UNPROTECTED? With the help of a friend, I found the following description about this problem: maximize_standby_db_clause Use this clause to specify the level of protection for the data in your database environment. you specify this clause from the primary database, which must be mounted but not open. note: The PROTECTED and UNPROTECTED keywords have been replaced for clarity but are still supported. PROTECTED is equivalent to maximize protection. UNPROTECTED is equivalent to maximize performance. 3. Problem Analysis:

PROTECTED= TO MAXIMIZE PROTECTIONUNPROTECTED= TO MAXIMIZE PERFORMANCE

 

This makes it easy to see that in data guard, PROTECTION_MODE = UNPROTECTED does not have any problems at all, except that it is called UNPROTECTED as another way of maximize performance. 4. Conclusion:

PROTECTED= TO MAXIMIZE PROTECTIONUNPROTECTED= TO MAXIMIZE PERFORMANCE

 

Some key parameter understanding problems.