Oracle Exam 1Z0-066 Topic 6 Question 30 Discussion

Actual exam question for Oracle's 1Z0-066 exam

Question #: 30
Topic #: 6

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? (Choose two.)

AIncrease the size of the buffer cache on the physical standby database instances.

BIncrease the number of standby redo log files on the standby databases.

CDecrease the redo log file size on the primary database.

DLower DB_BLOCK_CHECKING to MEDIUM or LOW on the standby databases.

EIncrease the size of standby redo log files on the standby databases.

Show Suggested Answer

Suggested Answer: A, D

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

References:

by Alease at May 04, 2022, 07:34 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!