Data mode of Oracle replicuard physical standby Database

In DataGuard, the data protection mode should be set as needed

In all configurations, performance is used for data security, or the data security level is used for performance.

1. Data protection mode
First: Maximize Data Protection
Maximum availability: This protection mode provides the highest level of data protection that is possible without compromising the availability of a primary database. with Oracle Data Guard, transactions do not commit until all redo data needed to recover those transactions has either been encrypted ed in memory or written to the standby redo log (depending upon configuration) on at least one synchronized standby database. if the primary database cannot write its redo stream to at least one synchronized standby database, it operates as if it were in maximum performance mode to preserve primary database availability until it is again able to write its redo stream to a synchronized standby database.

This protection mode ensures zero data loss failed T in the case of certain double faults, such as failure of a primary database after failure of the standby database.

-- First write the log to the memory or archive the backup database, and then execute the transaction, in addition to the failure of both sides at the same time.

Type 2: maximum performance
Maximum performance: This is the default protection mode. it provides the highest level of data protection that is possible without affecting the performance of a primary database. this is accomplished by allowing transactions to commit as soon as all redo data generated by those transactions has been written to the online log. redo data is also written to one or more standby databases, but this is done asynchronously with respect to transaction commitment, so primary database performance is unaffected by delays in writing redo data to the standby database (s ).

This protection mode offers slightly less data protection than maximum availability mode and has minimal impact on primary database performance.

-- The default protection method is to execute the transaction first, record it to the log, and synchronize it to the slave database, which has little impact on the iude of the master database.

Third: zero data loss
Maximum protection: This protection mode ensures that no data loss will occur if the primary database fails. to provide this level of protection, the redo data needed to recover a transaction must be written to both the online redo log and to the standby redo log on at least one synchronized standby database before the transaction commits. to ensure that data loss cannot occur, the primary database will shut down, rather than continue processing transactions, if it cannot write its redo stream to at least one synchronized standby database.

-- After the transaction is committed, commit the log to the slave database first, close other transactions in the master database, and then execute the transaction. Then, execute the next transaction.

2. Modification Method (data protection is controlled by the master database parameters)
Note: operations on the master database

Sort by data packets

Maximize protection <maximize availability <maximize performance

SQL> select protection_mode, protection_level from v $ database;

PROTECTION_MODE PROTECTION_LEVEL
------------------------------------------------------------------------------------------------------------------------
MAXIMUM PERFORMANCE

SQL> alter database set standby database to maximize availability;

The database has been changed.

SQL> select protection_mode, protection_level from v $ database;

PROTECTION_MODE PROTECTION_LEVEL
------------------------------------------------------------------------------------------------------------------------
Maximum availability resynchronization // not effective

For more details, please continue to read the highlights on the next page:

Recommended reading:

Use the Duplicate function of RMAN to create a physical partition uard

Basic Oracle tutorial-copying a database through RMAN

Reference for RMAN backup policy formulation

RMAN backup learning notes

Oracle Database Backup encryption RMAN Encryption

Use RMAN to back up duplicate to create a replica uard

1 2 3 Next Page