Q: far-sync gap
- From: amihay gonen <agonenil@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 28 Oct 2014 16:19:54 +0200
Hi all ,
I'm testing Farsync and it seems that always a gap in current_scn between
primary and farsync and standby .
I don't understand why...
I've the following configuration :
DGMGRL> show configuration verbose
Configuration - dr
Protection Mode: MaxAvailability
Members:
ldb1 - Primary database
ldb1fs - Far sync instance
ldb1sb - Physical standby database
Properties:
FastStartFailoverThreshold = '30'
OperationTimeout = '30'
TraceLevel = 'USER'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '180'
ObserverReconnect = '0'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
ObserverOverride = 'FALSE'
ExternalDestination1 = ''
ExternalDestination2 = ''
PrimaryLostWriteAction = 'CONTINUE'
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> enable configuration
Enabled.
DGMGRL> show configuration verbose
Configuration - dr
Protection Mode: MaxAvailability
Members:
ldb1 - Primary database
ldb1fs - Far sync instance
ldb1sb - Physical standby database
Properties:
FastStartFailoverThreshold = '30'
OperationTimeout = '30'
TraceLevel = 'USER'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '180'
ObserverReconnect = '0'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
ObserverOverride = 'FALSE'
ExternalDestination1 = ''
ExternalDestination2 = ''
PrimaryLostWriteAction = 'CONTINUE'
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL>
when doing the following queries :
sqlplus -l -s a/a@ldb1 <<EOF
set head off
select 'ldb1:'||current_scn||','||CONTROLFILE_CHANGE# from v\$database;
EOF
sqlplus -l -s sys/a@ldb1fs as sysdba<<EOF
set head off
select 'ldb1fs:'||current_scn||','||CONTROLFILE_CHANGE# from v\$database;
EOF
sqlplus -l -s a/a@ldb1sb <<EOF
set head off
select 'ldb1fs:'||current_scn||','||CONTROLFILE_CHANGE# from v\$database;
EOF
I got the following results
ldb1:*2275269*,2274999
Elapsed: 00:00:00.00
ldb1fs*:2275073*,1800180
Elapsed: 00:00:00.00
ldb1fs:*2275267*,2250255
Elapsed: 00:00:00.01
Other related posts:
