OraFAQ Forum: Data Guard

Home » Server Options » Data Guard » ORA-00314 (10.2.0.1)

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

ORA-00314 [message #545401]

Wed, 29 February 2012 02:33

andy huang
Messages: 498
Registered: July 2011

Senior Member

Dear all,
When i open the primary database in my dataguard env,it raise error, is there any way to solve it?

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00314: log 1 of thread 1, expected sequence# 77 doesn't match 0
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/oracl/redo01.log'

Report message to a moderator

Re: ORA-00314 [message #545403 is a reply to message #545401]

Wed, 29 February 2012 02:40

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-00314: 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.

Regards
Michel

Report message to a moderator

Re: ORA-00314 [message #545409 is a reply to message #545403]

Wed, 29 February 2012 03:38

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks,
Michel,can it solve by clearing the redo file?

Report message to a moderator

Re: ORA-00314 [message #545414 is a reply to message #545409]

Wed, 29 February 2012 04:13

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Action: Find and install correct version of log or reset logs

Regards
Michel

Report message to a moderator

Re: ORA-00314 [message #545506 is a reply to message #545414]

Wed, 29 February 2012 20:29

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks,
Michel,but i can not find the correct version of log,is the only way to reset logs?

Report message to a moderator

Re: ORA-00314 [message #545507 is a reply to message #545506]

Wed, 29 February 2012 21:04

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Are you sure; Your getting this message in primary database Or standby database

Report message to a moderator

Re: ORA-00314 [message #545508 is a reply to message #545507]

Wed, 29 February 2012 21:12

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks,
It is in primary database.

Report message to a moderator

Re: ORA-00314 [message #545509 is a reply to message #545508]

Wed, 29 February 2012 21:21

andy huang
Messages: 498
Registered: July 2011

Senior Member

hi,
There is a only redo01.log,how can i find the correct version of log?

[root@hxl /]# find . -name 'redo01.log'
./u01/app/oracle/oradata/oracl/redo01.log

Report message to a moderator

Re: ORA-00314 [message #545512 is a reply to message #545509]

Wed, 29 February 2012 22:46

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

post results of following OS command

ls -ltr /u01/app/oracle/oradata/oracl/*

Report message to a moderator

Re: ORA-00314 [message #545516 is a reply to message #545512]

Wed, 29 February 2012 23:47

andy huang
Messages: 498
Registered: July 2011

Senior Member

hi,

[oracle@hxl ~]$ ls -ltr /u01/app/oracle/oradata/oracl/*
-rw-r-----  1 oracle oinstall  20979712 Feb 28 11:08 /u01/app/oracle/oradata/oracl/temp01.dbf
-rw-r-----  1 oracle oinstall  52429312 Feb 29 06:32 /u01/app/oracle/oradata/oracl/redo02.log
-rw-r-----  1 oracle oinstall  52429312 Feb 29 06:32 /u01/app/oracle/oradata/oracl/redo03.log
-rw-r-----  1 oracle oinstall  52429312 Feb 29 06:33 /u01/app/oracle/oradata/oracl/redo01.log
-rw-r-----  1 oracle oinstall   5251072 Mar  1 04:21 /u01/app/oracle/oradata/oracl/users01.dbf
-rw-r-----  1 oracle oinstall  36708352 Mar  1 04:21 /u01/app/oracle/oradata/oracl/undotbs01.dbf
-rw-r-----  1 oracle oinstall 503324672 Mar  1 04:21 /u01/app/oracle/oradata/oracl/system01.dbf
-rw-r-----  1 oracle oinstall 283123712 Mar  1 04:21 /u01/app/oracle/oradata/oracl/sysaux01.dbf
-rw-r-----  1 oracle oinstall  10493952 Mar  1 04:21 /u01/app/oracle/oradata/oracl/hxl01.dbf
-rw-r-----  1 oracle oinstall   7225344 Mar  1 05:18 /u01/app/oracle/oradata/oracl/control03.ctl
-rw-r-----  1 oracle oinstall   7225344 Mar  1 05:18 /u01/app/oracle/oradata/oracl/control02.ctl
-rw-r-----  1 oracle oinstall   7225344 Mar  1 05:18 /u01/app/oracle/oradata/oracl/control01.ctl

Report message to a moderator

Previous Topic:	oracle 9i logical standby
Next Topic:	what is the most common mode in dataguard

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 08 03:08:25 CDT 2025