Suggested Answer:ABE🗳️
Consider using the following methods to optimize the time it takes to apply redo to physical standby databases. * (B) Set Parallel Recovery to Twice the Number of CPUs on One Standby Host * (E) During media recovery or Redo Apply, the redo log file is read, and data blocks that require redo application are parsed out. With parallel media recovery, these data blocks are subsequently distributed evenly to all recovery processes to be read into the buffer cache. The default is serial recovery or zero parallelism, which implies that the same recovery process reads the redo, reads the data blocks from disk, and applies the redo changes. References: https://docs.oracle.com/cd/B19306_01/server.102/b14239/manage_ps.htm#BACHIBGG
I think it is a trick question. REDO apply on a physical standby database is the capacity that my standby can process the received logs, therefore it will not be affected by the reception delay: the rate at which the standby can process will be the same if the delay is 0 seconds, 1 second or 10 seconds, therefore in my opinion the A is false.
On the other hand, a higher rate of generation of REDO in the primary, will necessarily have to increase the rate of application of REDO in standby.
Therefore I believe that the correct thing is BDE
How it "* (B) Set Parallel Recovery to Twice the Number of CPUs on One Standby Host" related to "B. the number of archiver processes on the standby database" ?
I believe right answer must be ADE.
upvoted 2 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
JESUSBB
1 year, 9 months agoRogazan
3 years, 6 months agoKamaelk
5 years, 2 months ago