Home » Server Options » Data Guard » Rac Dataguard Gap Query (Oracle 10204 on solaris 10)
icon1.gif  Rac Dataguard Gap Query [message #507385] Sat, 14 May 2011 15:44 Go to next message
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.

Re: Rac Dataguard Gap Query [message #507421 is a reply to message #507385] Sun, 15 May 2011 02:07 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
gv$archive_gap

Regards
Michel
Re: Rac Dataguard Gap Query [message #507553 is a reply to message #507385] Mon, 16 May 2011 18:26 Go to previous messageGo to next message
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.

Re: Rac Dataguard Gap Query [message #507554 is a reply to message #507553] Mon, 16 May 2011 18:32 Go to previous messageGo to next message
BlackSwan
Messages: 25793
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
Re: Rac Dataguard Gap Query [message #507558 is a reply to message #507553] Mon, 16 May 2011 23:19 Go to previous message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Join with gv$archived_log.

Regards
Michel
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:
  


Current Time: Wed Jan 17 06:01:06 CST 2018

Total time taken to generate the page: 0.05903 seconds