Home » SQL & PL/SQL » SQL & PL/SQL » sequence no higher than other (oracle 10g)
sequence no higher than other [message #433876] Fri, 04 December 2009 13:24 Go to next message
tannad
Messages: 43
Registered: January 2008
Location: mumbai
Member
HI,
We need to verify that sequences last number in one primary db is higher than on failover db after failing back to primary db

Suppose

LAR@PRIDB -- primary db
MAY@FALDB -- failover db

and there are 70 sequences like ABC_SEQ.. CBA_SEQ

how to check last number in one primary db is higher than on failover db
Re: sequence no higher than other [message #433878 is a reply to message #433876] Fri, 04 December 2009 13:32 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>how to check last number in one primary db is higher than on failover db
Hmmmmm, I expect them to be the same values; which is whole point of standby.

In some/many/most cases the standby can not be queried.
It seems to me this request came from a Pointy Hair Boss who likely could not spell S-Q-L after being spotted the S & L.

Post Operating System (OS) name & version for DB server system.
Post results of
SELECT * from v$version
Re: sequence no higher than other [message #433879 is a reply to message #433876] Fri, 04 December 2009 13:44 Go to previous message
tannad
Messages: 43
Registered: January 2008
Location: mumbai
Member
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for HPUX: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

Previous Topic: how to alter a package being called in a scheduled Job
Next Topic: finding the missing sequences in a column
Goto Forum:
  


Current Time: Fri Dec 02 18:21:19 CST 2016

Total time taken to generate the page: 0.40333 seconds