Oracle dataguard limitations what is best [message #679505] |
Thu, 05 March 2020 10:52 |
evoradba
Messages: 144 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 #679665 is a reply to message #679664] |
Thu, 12 March 2020 12:18 |
evoradba
Messages: 144 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 |
John Watson
Messages: 8964 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 #679682 is a reply to message #679660] |
Mon, 16 March 2020 10:13 |
evoradba
Messages: 144 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
|
|
|