Exam 1z0-066 topic 1 question 64 discussion

Actual exam question from Oracle's 1z0-066

Question #: 64
Topic #: 1

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.

Show Suggested Answer

Suggested Answer: AD 🗳️
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:
https://docs.oracle.com/database/121/HABPT/config_dg.htm#HABPT4904

by oraexam12 at Sept. 12, 2022, 8:50 a.m.

Comments

Submit Cancel

JESUSBB

1 year, 9 months ago

Answer: A and D

upvoted 1 times

...

Exam 1z0-066 All Questions

View all questions & answers for the 1z0-066 exam

Exam 1z0-066 topic 1 question 64 discussion

Comments

JESUSBB

SY0-701