Home » Server Options » Data Guard » Oracle dataguard limitations what is best (RDBMS 12.2..0.1 on linux)
Oracle dataguard limitations what is best [message #679505] Thu, 05 March 2020 10:52 Go to next message
evoradba
Messages: 126
Registered: April 2005
Location: Canada
Senior Member
Question:
I'm working on dataguard and I'm looking for the best and easiest recovery mode using dataguard
i see the following options:


Snapshot Standby Database
Logical standby database
physical standby database


any recommendations on what is the best way with less limitations i do see that Logical standby has limitations on Unsupported Datatypes etc

has anyone have other comments ideas etc
thank you
Re: Oracle dataguard limitations what is best [message #679540 is a reply to message #679505] Fri, 06 March 2020 13:28 Go to previous messageGo to next message
John Watson
Messages: 8274
Registered: January 2010
Location: Global Village
Senior Member
Snapshot standbys and logical standbys are not used for any sort of recovery.
Re: Oracle dataguard limitations what is best [message #679660 is a reply to message #679540] Thu, 12 March 2020 09:49 Go to previous messageGo to next message
evoradba
Messages: 126
Registered: April 2005
Location: Canada
Senior Member
thank you
have anyone used the delay log applying in the standby physical database?
Re: Oracle dataguard limitations what is best [message #679661 is a reply to message #679660] Thu, 12 March 2020 11:26 Go to previous messageGo to next message
Michel Cadot
Messages: 67152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Yes I did.

[Updated on: Thu, 12 March 2020 11:26]

Report message to a moderator

Re: Oracle dataguard limitations what is best [message #679663 is a reply to message #679661] Thu, 12 March 2020 11:59 Go to previous messageGo to next message
evoradba
Messages: 126
Registered: April 2005
Location: Canada
Senior Member
how does it work? can you please share?
thank you!
Re: Oracle dataguard limitations what is best [message #679664 is a reply to message #679663] Thu, 12 March 2020 12:10 Go to previous messageGo to next message
JPBoileau
Messages: 88
Registered: September 2017
Member
Google is your friend Smile

https://docs.oracle.com/database/121/SBYDB/log_apply.htm#SBYDB00515

JP
Re: Oracle dataguard limitations what is best [message #679665 is a reply to message #679664] Thu, 12 March 2020 12:18 Go to previous messageGo to next message
evoradba
Messages: 126
Registered: April 2005
Location: Canada
Senior Member
thanks - i saw that link before
what Im looking for is a timing re sync link every couple of hours


Properties:
DGConnectIdentifier = 'xxxxx'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
RedoRoutes = ''
DelayMins = '25'
Binding = 'optional'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyLagThreshold = '7500'
TransportLagThreshold = '300'
TransportDisconnectedThreshold = '30'
ApplyParallel = 'AUTO'
ApplyInstances = '0'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '900'
LogArchiveMaxProcesses = '4'
LogArchiveMinSucceedDest = '1'
DataGuardSyncLatency = '0'
DbFileNameConvert =
LogFileNameConvert =

FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
PreferredObserverHosts = ''
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxx)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=xxxxxx_DGMGRL)(INSTANCE_NAME=xxxxx)(SERVER= DEDICATED)))'
StandbyArchiveLocation = 'USE_DB_RECOVERY_FILE_DEST'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
TopWaitEvents = '(monitor)'
Re: Oracle dataguard limitations what is best [message #679666 is a reply to message #679665] Thu, 12 March 2020 14:18 Go to previous messageGo to next message
John Watson
Messages: 8274
Registered: January 2010
Location: Global Village
Senior Member
Quote:
what Im looking for is a timing re sync link every couple of hours
Can you explain what you mean by that? What you are trying to achieve? Note that that the redo apply delay is really only for backward compatibility, from release 10 database flashback gives better functionality.
Re: Oracle dataguard limitations what is best [message #679671 is a reply to message #679666] Fri, 13 March 2020 10:11 Go to previous messageGo to next message
evoradba
Messages: 126
Registered: April 2005
Location: Canada
Senior Member
Hi
I figure it out I was looking for delay in applying the logs from prod to standy
i just play with the configuration for a while until i got what I wanted

thank you!
Re: Oracle dataguard limitations what is best [message #679672 is a reply to message #679671] Fri, 13 March 2020 10:52 Go to previous messageGo to next message
Michel Cadot
Messages: 67152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
until i got what I wanted
Which was exactly? And how did you get it?

Re: Oracle dataguard limitations what is best [message #679673 is a reply to message #679672] Fri, 13 March 2020 11:38 Go to previous messageGo to next message
evoradba
Messages: 126
Registered: April 2005
Location: Canada
Senior Member
played around with these

ApplyLagThreshold
TransportLagThreshold
TransportDisconnectedThreshold
ArchiveLagTarget
Re: Oracle dataguard limitations what is best [message #679674 is a reply to message #679673] Fri, 13 March 2020 12:49 Go to previous messageGo to next message
Michel Cadot
Messages: 67152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

OK but this does not really answer my questions.

Re: Oracle dataguard limitations what is best [message #679675 is a reply to message #679674] Fri, 13 March 2020 13:05 Go to previous messageGo to next message
evoradba
Messages: 126
Registered: April 2005
Location: Canada
Senior Member
I changed the settings on

ApplyLagThreshold 6500
TransportLagThreshold 30 ( had a few issues with this one)
TransportDisconnectedThreshold 0
ArchiveLagTarget 100
Re: Oracle dataguard limitations what is best [message #679676 is a reply to message #679675] Fri, 13 March 2020 14:21 Go to previous messageGo to next message
Michel Cadot
Messages: 67152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

To achieve what exactly? or what are the effects of these settings?
And what were the issues you got with the second ones?

Re: Oracle dataguard limitations what is best [message #679677 is a reply to message #679675] Sat, 14 March 2020 02:28 Go to previous messageGo to next message
John Watson
Messages: 8274
Registered: January 2010
Location: Global Village
Senior Member
I thought that you waned to delay redo apply? That would be the DelayMins property. The ones you have listed are to do with fast-start failover.
Re: Oracle dataguard limitations what is best [message #679682 is a reply to message #679660] Mon, 16 March 2020 10:13 Go to previous message
evoradba
Messages: 126
Registered: April 2005
Location: Canada
Senior Member
yes - correct - I'm new to dataguard - i was getting warming messages

i no longer get warning or error messages

I'm trying now to setup dataguard for a DR test
option 1 is to fail to standby and then back to primary
option 2 is to fail to standby client tests and not to switch back to primary
Previous Topic: not updating APPLIED column in v$archived_log.
Next Topic: oracle instance naming in a dataguard setup
Goto Forum:
  


Current Time: Thu Jun 04 04:03:20 CDT 2020