Which two would you recommend to reduce the redo apply …

Your Data Guard environment consists of these components and settings:
1. A primary database
2. Two remote physical standby databases
3. The redo transport mode is set to SYNC.
4. Real-time query is enabled for both standby databases.
5. The DB_BLOCK_CHECKING parameter is set to TRUE on both standby databases.You notice an increase in redo apply lag time on both standby databases.
Which two would you recommend to reduce the redo apply lag on the standby databases?

Your Data Guard environment consists of these components and settings:
1. A primary database
2. Two remote physical standby databases
3. The redo transport mode is set to SYNC.
4. Real-time query is enabled for both standby databases.
5. The DB_BLOCK_CHECKING parameter is set to TRUE on both standby databases.You notice an increase in redo apply lag time on both standby databases.
Which two would you recommend to reduce the redo apply lag on the standby databases?

A.
Increase the size of the buffer cache on the physical standby database instances.

B.
Increase the number of standby redo log files on the standby databases.

C.
Decrease the redo log file size on the primary database.

D.
Lower DB_BLOCK_CHECKING to MEDIUM or LOW on the standby databases.

E.
Increase the size of standby redo log files on the standby databases.

Explanation:
Use Data Guard Redo Apply Best Practices
To improve the Redo Apply rate of a physical standby database (and media recovery):
* Set DB_CACHE_SIZE to a Value Greater than on the Primary Database
* Set DB_BLOCK_CHECKSUM=FULL and DB_BLOCK_CHECKING=MEDIUM or FULL
* Maximize I/O Rates on Standby Redo Logs and Archived Redo Logs
* Assess Recovery Rate
* Assess Database Wait Events
* Tune I/O Operations
* Assess System Resources
https://docs.oracle.com/database/121/HABPT/config_dg.htm#HABPT4904



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Chunn

Chunn

I think A,D