Which two are true regarding the DelayMins Database Pro…

Your Data Guard environment consists of these components and settings:
1. A primary database supporting an OLTP workload
2. A remote physical standby database
3. Real-time query is enabled
4. The redo transport mode is set to SYNC.5. The protection mode is set to Maximum Availability.
Which two are true regarding the DelayMins Database Property for the standby database?

Your Data Guard environment consists of these components and settings:
1. A primary database supporting an OLTP workload
2. A remote physical standby database
3. Real-time query is enabled
4. The redo transport mode is set to SYNC.5. The protection mode is set to Maximum Availability.
Which two are true regarding the DelayMins Database Property for the standby database?

A.
It can only be enabled for a configuration in Maximum Performance mode.

B.
It allows user errors on the primary to be recovered by using the physical standby database.

C.
It enables you to bypass the default network timeout interval specified for the standby redo transport
destination.

D.
It can only be enabled for a configuration in Maximum Availability mode.

E.
It allows logical corruptions on the primary to be recovered by using the physical standby database.

F.
It specifies a delay before the primary ships redo to the standby destination having DelayMins set.

Explanation:
F: The DelayMins configurable database property specifies the number of minutes log apply services will delay
applying the archived redo log data on the standby database.
https://docs.oracle.com/cd/E11882_01/server.112/e40771/dbpropref.htm#DGBKR855



Leave a Reply 5

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


Marc

Marc

F is wrong , the delay is on the apply not on the redo transport.

Chunn

Chunn

F seems to be correct too….

https://docs.oracle.com/database/121/DGBKR/dbpropref.htm#DGBKR870

Although this property is set for the standby database, it is indirectly related to the redo transport services for the database or far sync instance that is sending redo data. The broker propagates the setting you specify on the standby database to the corresponding attributes of the LOG_ARCHIVE_DEST_n value of the database or far sync instance that is sending redo data.

Chunn

Chunn

Refer 8.3.8 DelayMins

2

2

B,E

Use the DelayMins database property to specify the number of minutes that log apply
services must wait before applying redo data to the standby database. Note that only
log apply services on the standby database are delayed. Redo transport services on the
primary database are not delayed, thus the primary database data is still well
protected by the standby database.