Home » Server Options » Data Guard » archive log gap (oracle 11g)
archive log gap [message #654617] Mon, 08 August 2016 01:12 Go to next message
rameshrk0206@gmail.com
Messages: 6
Registered: August 2016
Junior Member
Hi,

please let me solution for my problem.

There is large archivelog gap between primary and standby database.

which way is better again can i clone standy database or can i do incremental recovery based
on scn number.

Re: archive log gap [message #654621 is a reply to message #654617] Mon, 08 August 2016 01:31 Go to previous messageGo to next message
Michel Cadot
Messages: 65207
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The first thing is to know why there is such gap.
Is this hole on the archived logs or is this just the last ones are missing.
Quantify "large".

[Edit: missing word]

[Updated on: Mon, 08 August 2016 03:20]

Report message to a moderator

Re: archive log gap [message #654629 is a reply to message #654621] Mon, 08 August 2016 02:18 Go to previous messageGo to next message
rameshrk0206@gmail.com
Messages: 6
Registered: August 2016
Junior Member
hi,

my standby datbase was kept down for the past three days,thats why log gap
increased large.

Re: archive log gap [message #654630 is a reply to message #654629] Mon, 08 August 2016 02:42 Go to previous messageGo to next message
John Watson
Messages: 7150
Registered: January 2010
Location: Global Village
Senior Member
The Fetch Archive Log mechanism should sort it out automatically, no problem.
Re: archive log gap [message #655163 is a reply to message #654630] Tue, 23 August 2016 04:21 Go to previous message
rameshrk0206@gmail.com
Messages: 6
Registered: August 2016
Junior Member
thank you..
Previous Topic: Service Name in Data Guard
Next Topic: PING[ARCX]: Heartbeat failed to connect to standby 'XXX'. Error is 1034
Goto Forum:
  


Current Time: Fri Nov 24 12:46:03 CST 2017

Total time taken to generate the page: 0.01544 seconds