Home » Server Options » Data Guard » ORA-00314 on standby (Oracle 10.2.0.4, Solaris 5.10)
ORA-00314 on standby [message #415388] Mon, 27 July 2009 09:38 Go to next message
lotusdeva
Messages: 201
Registered: March 2005
Senior Member
Hi, we are on Oracle 10.2.0.4, Data Guard + RMAN. We have been manually deleting archive logs from primary and standy via the following after we back those up:

delete noprompt archivelog until time 'sysdate - 7';



Over the weekend the file system got to 100% on standy, so we deleted some backups that already went to tape on standby, which cleared up the space. However, when trying to 'startup mount' on standby, we have observed the following (on standy):

ORA-00314: log 4 of thread 1, expected sequence# 4635 doesn't match 4633
ORA-00312: online log 4 thread 1: '/data/dbf/TEST/stdby04.log'



There seems to be only this one sequence that is not matching. I am not sure how to resovle this error. I am not sure if it is caused becasue archive logs do not match on primary and standy or because standy went to 100% in tems of disk space and something did not synch correctly . Any ideas? Thank you!
Re: ORA-00314 on standby [message #415412 is a reply to message #415388] Mon, 27 July 2009 10:32 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

00314, 00000, "log %s of thread %s, expected sequence# %s doesn't match %s"
// *Cause:  The online log is corrupted or is an old version.
// *Action: Find and install correct version of log or reset logs.

[Updated on: Mon, 27 July 2009 10:36]

Report message to a moderator

Re: ORA-00314 on standby [message #415416 is a reply to message #415412] Mon, 27 July 2009 10:38 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Also checkc Document Nr 6786022.8 & 18373.1
Previous Topic: Database cloning.
Next Topic: DG primary and secondary on different version of oracle
Goto Forum:
  


Current Time: Thu Mar 28 05:42:43 CDT 2024