Home » Server Options » Data Guard » ORA-00314 (10.2.0.1)
ORA-00314 [message #545401] Wed, 29 February 2012 02:33 Go to next message
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'
Re: ORA-00314 [message #545403 is a reply to message #545401] Wed, 29 February 2012 02:40 Go to previous messageGo to next message
Michel Cadot
Messages: 57612
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: ORA-00314 [message #545409 is a reply to message #545403] Wed, 29 February 2012 03:38 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks,
Michel,can it solve by clearing the redo file?
Re: ORA-00314 [message #545414 is a reply to message #545409] Wed, 29 February 2012 04:13 Go to previous messageGo to next message
Michel Cadot
Messages: 57612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Action: Find and install correct version of log or reset logs


Regards
Michel
Re: ORA-00314 [message #545506 is a reply to message #545414] Wed, 29 February 2012 20:29 Go to previous messageGo to next message
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?
Re: ORA-00314 [message #545507 is a reply to message #545506] Wed, 29 February 2012 21:04 Go to previous messageGo to next message
babuknb
Messages: 1703
Registered: December 2005
Location: NJ
Senior Member

Are you sure; Your getting this message in primary database Or standby database
Re: ORA-00314 [message #545508 is a reply to message #545507] Wed, 29 February 2012 21:12 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks,
It is in primary database.
Re: ORA-00314 [message #545509 is a reply to message #545508] Wed, 29 February 2012 21:21 Go to previous messageGo to next message
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

Re: ORA-00314 [message #545512 is a reply to message #545509] Wed, 29 February 2012 22:46 Go to previous messageGo to next message
BlackSwan
Messages: 21945
Registered: January 2009
Senior Member
post results of following OS command

ls -ltr /u01/app/oracle/oradata/oracl/*
Re: ORA-00314 [message #545516 is a reply to message #545512] Wed, 29 February 2012 23:47 Go to previous message
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
Previous Topic: oracle 9i logical standby
Next Topic: what is the most common mode in dataguard
Goto Forum:
  


Current Time: Sat Apr 19 08:17:49 CDT 2014

Total time taken to generate the page: 0.08063 seconds