Home » Server Options » Data Guard » DataGuard (Oracle 10g, Windows 2003 server)
DataGuard [message #413757] Fri, 17 July 2009 09:46 Go to next message
waseem62002
Messages: 4
Registered: July 2009
Location: Mumbai
Junior Member
i have primary database and standby database in one machine, both database is up and running,


Now log sequence are not matching or not syncorize with primary

in primary database

SQL>select max(sequence#) from V$log_history;

MAX(SEQUENCE#)
------------
228

in Standby database


SQL>select max(sequence#) from V$log_history;

MAX(SEQUENCE#)
------------
214

Can any help to synchornize the log
Re: DataGuard [message #413849 is a reply to message #413757] Fri, 17 July 2009 16:24 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Do you see any errors listed in V$ARCHIVE_DEST or the alert logs of the databases?
Previous Topic: Manual setup of Logical Standby 10g
Next Topic: Data Guard after upgrade to 10g
Goto Forum:
  


Current Time: Thu Mar 28 11:54:48 CDT 2024