Which three statements are true about Data Guard config…

Which three statements are true about Data Guard configurations?

Which three statements are true about Data Guard configurations?

A.
All databases in one Data Guard environment must have the same database name.

B.
VALID_FOR is a LOG_ARCH|VE_DEST_N attribute that enables DB role change operations without having to modify LOG_ARCHIVE_DEST_n when performing switchovers or failovers.

C.
For Standard Edition, LOG_ARCH|VE_DUPLEX_DEST is used to configure redo transport, from the primary to the standby database.

D.
When using the Data Guard Broker, an spfile is not required.

E.
Up to 30 physical standby databases may exist within one configuration.

F.
The Oracle recommendation for the number of standby redo log groups per thread is one more than the number of online redo log groups per thread



Leave a Reply 7

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


Wim J

Wim J

C incorrect: DG only available in EE
D: spfile is a requirement for broker

Why is B wrong?

A is incorrect: the db_name can be different, the db_unique name should be the same.

so BEF??

PeraDetlic

PeraDetlic

A,B,F

An Oracle Data Guard broker configuration can now contain up to 253 members, including one primary database and a combination of standby databases and far sync instances that receive redo directly from the primary database.

Wim J

Wim J

indeed, the number of databases is augmented to 253. So E is incorrect.

A is my mistake.

agree with A, B, F

Nelz

Nelz

How many log_archive_dest_n parameters do you have? I have not seen 253

edge

edge

Hi

Agree with you
A,B,F

Regards

Nelz

Nelz

A E F
I am not too sure about B

ars

ars

You can cascade database to have more than 30 standby databases.