OraFAQ Forum: Data Guard » Rac Dataguard Gap Query

Home » Server Options » Data Guard » Rac Dataguard Gap Query (Oracle 10204 on solaris 10)

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

Rac Dataguard Gap Query [message #507385]

Sat, 14 May 2011 15:44

dasuwal@gmail.com
Messages: 20
Registered: June 2009

Junior Member

Hello Forum

Please let me know the query to see the gap between phyical(3node) and standby(1 active on 3 node cluster) on rac.

Thanks in advance,
D.

Report message to a moderator

Re: Rac Dataguard Gap Query [message #507421 is a reply to message #507385]

Sun, 15 May 2011 02:07

Michel Cadot
Messages: 68501
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

gv$archive_gap

Regards
Michel

Report message to a moderator

Re: Rac Dataguard Gap Query [message #507553 is a reply to message #507385]

Mon, 16 May 2011 18:26

dasuwal@gmail.com
Messages: 20
Registered: June 2009

Junior Member

Thanks Michael,

Although the archive logs are applied as per SCN number, how can I determine what is the NEXT archivelog (out of 3 different threads) that will be applied to standby.

Thanks,
D.

Report message to a moderator

Re: Rac Dataguard Gap Query [message #507554 is a reply to message #507553]

Mon, 16 May 2011 18:32

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>how can I determine what is the NEXT archivelog (out of 3 different threads) that will be applied to standby.

 1* select group#, status from v$log
  2  /

    GROUP# STATUS
---------- ----------------
	 1 INACTIVE
	 2 CURRENT
	 3 INACTIVE

the "current" REDO group will be archived to next sequence number

Report message to a moderator

Re: Rac Dataguard Gap Query [message #507558 is a reply to message #507553]

Mon, 16 May 2011 23:19

Michel Cadot
Messages: 68501
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Join with gv$archived_log.

Regards
Michel

Report message to a moderator

Previous Topic:	High number of DG slave processes on primary when link to standby is down
Next Topic:	Check RFS server is working

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 25 03:44:22 CDT 2023