OraFAQ Forum: Data Guard » Oracle dataguard limitations what is best

Home » Server Options » Data Guard » Oracle dataguard limitations what is best (RDBMS 12.2..0.1 on linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: Oracle dataguard limitations what is best [message #679540 is a reply to message #679505]

Fri, 06 March 2020 13:28

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

Snapshot standbys and logical standbys are not used for any sort of recovery.

Report message to a moderator

Re: Oracle dataguard limitations what is best [message #679660 is a reply to message #679540]

Thu, 12 March 2020 09:49

evoradba
Messages: 144
Registered: April 2005
Location: Canada

Senior Member

thank you
have anyone used the delay log applying in the standby physical database?

Report message to a moderator

Re: Oracle dataguard limitations what is best [message #679661 is a reply to message #679660]

Thu, 12 March 2020 11:26

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

evoradba
Messages: 144
Registered: April 2005
Location: Canada

Senior Member

how does it work? can you please share?
thank you!

Report message to a moderator

Re: Oracle dataguard limitations what is best [message #679664 is a reply to message #679663]

Thu, 12 March 2020 12:10

JPBoileau
Messages: 88
Registered: September 2017

Member

Google is your friend Smile

Smile

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

JP

Report message to a moderator

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)'

Report message to a moderator

Re: Oracle dataguard limitations what is best [message #679666 is a reply to message #679665]

Thu, 12 March 2020 14:18

John Watson
Messages: 8976
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.

Report message to a moderator

Re: Oracle dataguard limitations what is best [message #679671 is a reply to message #679666]

Fri, 13 March 2020 10:11

evoradba
Messages: 144
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!

Report message to a moderator

Re: Oracle dataguard limitations what is best [message #679672 is a reply to message #679671]

Fri, 13 March 2020 10:52

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

until i got what I wanted

Which was exactly? And how did you get it?

Report message to a moderator

Re: Oracle dataguard limitations what is best [message #679673 is a reply to message #679672]

Fri, 13 March 2020 11:38

evoradba
Messages: 144
Registered: April 2005
Location: Canada

Senior Member

played around with these

ApplyLagThreshold
TransportLagThreshold
TransportDisconnectedThreshold
ArchiveLagTarget

Report message to a moderator

Re: Oracle dataguard limitations what is best [message #679674 is a reply to message #679673]

Fri, 13 March 2020 12:49

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

OK but this does not really answer my questions.

Report message to a moderator

Re: Oracle dataguard limitations what is best [message #679675 is a reply to message #679674]

Fri, 13 March 2020 13:05

evoradba
Messages: 144
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

Report message to a moderator

Re: Oracle dataguard limitations what is best [message #679676 is a reply to message #679675]

Fri, 13 March 2020 14:21

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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?

Report message to a moderator

Re: Oracle dataguard limitations what is best [message #679677 is a reply to message #679675]

Sat, 14 March 2020 02:28

John Watson
Messages: 8976
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.

Report message to a moderator

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

Report message to a moderator

Previous Topic:	not updating APPLIED column in v$archived_log.
Next Topic:	oracle instance naming in a dataguard setup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 20:02:05 CDT 2025