What is true concerning this configuration?

You are monitoring your Data Guard broker configuration and issue this set of DGMGRL commands:
DGMGRL> SHOW CONFIGURATION
Configuration – DRSolution
Protection Mode: MaxPerformance
Databases:
Close_by-Primary database
FS_inst- Far Sync
Far_away –Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
What is true concerning this configuration?

You are monitoring your Data Guard broker configuration and issue this set of DGMGRL commands:
DGMGRL> SHOW CONFIGURATION
Configuration – DRSolution
Protection Mode: MaxPerformance
Databases:
Close_by-Primary database
FS_inst- Far Sync
Far_away –Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
What is true concerning this configuration?

A.
The Close_by primary database instance forwards redo to the FS_inst Far Sync instance, which forwards the redo in turn to the Far_away physical standby
database instance.

B.
The far sync instance will not forward redo to the Far_away physical standby because the Protection mode is not MaxProtection.

C.
The close_by primary database forwards redo to the Far_away physical standby directly and also sends redo to the FS_inst Far Sync instance.

D.
The far sync instance will not forward redo to the Far_away physical standby because Fast-Start Failover is disabled.

E.
The FS_inst Far Sync instance forwards redo to the Far_away physical standby only if the close_by primary database is not able to do so.

Explanation:
An Oracle Data Guard far sync instance is a remote Oracle Data Guard destination that accepts redo from the primary database and then ships that redo to other
members of the Oracle Data Guard configuration. A far sync instance manages a control file, receives redo into standby redo logs (SRLs), and archives those
SRLs to local archived redo logs, but that is where the similarity with standbys ends. A far sync instance does not have user data files, cannot be opened for

access, cannot run redo apply, and can never function in the primary role or be converted to any type of standby database.

https://docs.oracle.com/database/121/SBYDB/create_fs.htm



Leave a Reply 4

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


Wim J

Wim J

I don’t think you can conclude anything with only those commands.
Redoroutes are essential information?

Will a far sync by default take over the shipment from primary to a (faraway) instance?

PeraDetlic

PeraDetlic

DGMGRL> ADD FAR_SYNC FS1 AS CONNECT IDENTIFIER IS FS1.example.com;
Far Sync FS1 added
DGMGRL> ENABLE FAR_SYNC FS1;
Enabled.
DGMGRL> SHOW CONFIGURATION;

Configuration – DRSolution

Protection Mode: MaxPerformance
Databases:
North_Sales – Primary database
FS1 – Far Sync
South_Sales – Physical standby database

Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS

DGMGRL> EDIT DATABASE ‘North_Sales’ SET PROPERTY ‘RedoRoutes’ = ‘(LOCAL : FS1 SYNC)’;
DGMGRL> EDIT FAR_SYNC ‘FS1’ SET PROPERTY ‘RedoRoutes’ = ‘(North_Sales : South_Sales ASYNC)’;
DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MaxAvailability;
DGMGRL> SHOW CONFIGURATION;

Configuration – DRSolution

Protection Mode: MaxAvailability
Databases:
North_Sales – Primary database
FS1 – Far Sync
South_Sales – Physical standby database

Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS

==> Conclusion: ambiguous question <==

Steff

Steff

B,D,E are incorrect.

A looks like this
Close_by
…FS_inst
……Far_away

C looks like this
Close_by
…FS_inst
…Far_away

JorgeZG

JorgeZG

C is correct