Hi there,
I'm using DGMGRL (Oracle 12.2.0.1 + Jan 2019 PSU).
i'm trying to implement the same architecture on Cloud that we have on premise. (It means one primary + 2 Physical Standbys).
To be able to switchover quickly, i'm using far sync instances on premise (because DC Cloud is far away) configured in HA (if tfs1 is down then tfs2 is the taking the lead to propagate changes and if both tfs1 and tfs2 are down then primary send changes directly in ASYNC mode to mwt).
I'm trying to configure correctly on premise first and then do the configuration for mwt,1wt,2wt as primary in Cloud.
Here is the picture of my conf with a show configuration :
DGMGRL> show configuration verbose;
Configuration - cellar_dg_t
Protection Mode: MaxAvailability
Members:
cellarmxt - Primary database
cellar1xt - Physical standby database
cellar2xt - Physical standby database
cellarmxtfs1 - Far sync instance
cellarmwt - Physical standby database
cellar1wt - Physical standby database (receiving current redo)
cellar2wt - Physical standby database (receiving current redo)
cellarmxtfs2 - Far sync instance (alternate of cellarmxtfs1)
cellarmwt - Physical standby database
cellar1wt - Physical standby database (receiving current redo)
cellar2wt - Physical standby database (receiving current redo)
cellarmwt - Physical standby database (alternate of cellarmxtfs1)
cellar1wt - Physical standby database (receiving current redo)
cellar2wt - Physical standby database (receiving current redo)
When i stop tfs1, i have this configuration (with error ora-16686) :
DGMGRL> show configuration;
Configuration - cellar_dg_t
Protection Mode: MaxAvailability
Members:
cellarmxt - Primary database
Error: ORA-16778: redo transport error for one or more members
cellar1xt - Physical standby database
cellar2xt - Physical standby database
cellarmxtfs2 - Far sync instance (alternate of cellarmxtfs1)
cellarmwt - Physical standby database
Warning: ORA-16686: database may not receive redo data if redo source is an alternate destination
cellar1wt - Physical standby database (receiving current redo)
Warning: ORA-16686: database may not receive redo data if redo source is an alternate destination
cellar2wt - Physical standby database (receiving current redo)
Warning: ORA-16686: database may not receive redo data if redo source is an alternate destination
Members Not Receiving Redo:
cellarmxtfs1 - Far sync instance
Can you please help me to solve this ?
Here are my RedoRoutes properties :
DGMGRL> show database 'cellarmxt' 'RedoRoutes';
RedoRoutes = '(LOCAL:(cellar1xt SYNC),(cellar2xt SYNC),(cellarmxtfs1 SYNC PRIORITY=1,cellarmxtfs2 SYNC PRIORITY=2,cellarmwt ASYNC PRIORITY=3))'
DGMGRL> show database 'cellar1xt' 'RedoRoutes';
RedoRoutes = '(LOCAL:(cellarmxt SYNC),(cellar2xt SYNC),(cellarmxtfs1 SYNC PRIORITY=1,cellarmxtfs2 SYNC PRIORITY=2,cellarmwt ASYNC PRIORITY=3))'
DGMGRL> show database 'cellar2xt' 'RedoRoutes';
RedoRoutes = '(LOCAL:(cellarmxt SYNC),(cellar1xt SYNC),(cellarmxtfs1 SYNC PRIORITY=1,cellarmxtfs2 SYNC PRIORITY=2,cellarmwt ASYNC PRIORITY=3))'
DGMGRL> show far_sync 'cellarmxtfs1' 'RedoRoutes';
RedoRoutes = '(ANY:cellarmwt ASYNC)'
DGMGRL> show far_sync 'cellarmxtfs2' 'RedoRoutes';
RedoRoutes = '(ANY:cellarmwt ASYNC)'
DGMGRL> show database 'cellarmwt' 'RedoRoutes';
RedoRoutes = '(LOCAL:(cellar1wt SYNC),(cellar2wt SYNC))(cellarmxt : (cellar1wt ASYNC),(cellar2wt ASYNC))(cellar1xt :(cellar1wt ASYNC),(cellar2wt ASYNC))(cellar2xt :(cellar1wt ASYNC),(cellar2wt ASYNC))'
DGMGRL> show database 'cellar1wt' 'RedoRoutes';
RedoRoutes = ''
DGMGRL> show database 'cellar2wt' 'RedoRoutes';
RedoRoutes = ''
Thanks