OraFAQ Forum: Backup & Recovery » ORA-00314: log 3 of thread 1, expected sequence# 207 doesn't match 198

Home » RDBMS Server » Backup & Recovery » ORA-00314: log 3 of thread 1, expected sequence# 207 doesn't match 198 (oracle, 11g. (11.2.0.1.0) , Linux (Red Hat 5.0))

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

ORA-00314: log 3 of thread 1, expected sequence# 207 doesn't match 198 [message #533431]

Wed, 30 November 2011 00:15

pbardale7
Messages: 28
Registered: November 2011
Location: India

Junior Member

Hi Experts,

While starting up my database i am getting this error.

by mistake i had moved log files, and after some time again i inserted those log files again into same directory i am getting this error. please guide me soon

thank you

Regards,

Pravin.

Report message to a moderator

Re: ORA-00314: log 3 of thread 1, expected sequence# 207 doesn't match 198 [message #533432 is a reply to message #533431]

Wed, 30 November 2011 00:18

Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku

Senior Member

Follow these steps:

SQL> startup mount;
SQL> recover database until cancel;
SQL> alter database open resetlogs;

Report message to a moderator

Re: ORA-00314: log 3 of thread 1, expected sequence# 207 doesn't match 198 [message #533433 is a reply to message #533432]

Wed, 30 November 2011 00:24

pbardale7
Messages: 28
Registered: November 2011
Location: India

Junior Member

hey, that wont affect on my entries?

I have near about 5lakhs of records in my database i want that entries to be in database.

will those steps will delete my entered entries?

Report message to a moderator

Re: ORA-00314: log 3 of thread 1, expected sequence# 207 doesn't match 198 [message #533435 is a reply to message #533433]

Wed, 30 November 2011 00:27

Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku

Senior Member

You're already corrupted redo log files, so you need to take the database in nomount mount and clear redo log files. In order to clear redo log files, you need to open the database with RESETLOGS option, for this you perform a cancel based incomplete recovery (which performs nothing, just imitiates the recovery) and open the database with resetlogs option. This command recreates redo log files

Report message to a moderator

Re: ORA-00314: log 3 of thread 1, expected sequence# 207 doesn't match 198 [message #533439 is a reply to message #533435]

Wed, 30 November 2011 00:32

pbardale7
Messages: 28
Registered: November 2011
Location: India

Junior Member

After Startup mount

for next step i got :

SQL> recover database until cancel;
ORA-00279: change 10539338 generated at 11/30/2011 11:02:10 needed for thread 1
ORA-00289: suggestion :
/eagledatabase/oracle/flash_recovery_area/EAGLE/archivelog/2011_11_29/o1_mf_1_20
7_%u_.arc
ORA-00280: change 10539338 for thread 1 is in sequence #207

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log
'/eagledatabase/oracle/flash_recovery_area/EAGLE/archivelog/2011_11_29/o1_mf_1_2
07_%u_.arc'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/eagledatabase/oracle/oradata/Eagle/system01.dbf'

Report message to a moderator

Re: ORA-00314: log 3 of thread 1, expected sequence# 207 doesn't match 198 [message #533440 is a reply to message #533439]

Wed, 30 November 2011 00:35

Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku

Senior Member

Type Cancel after "recover database until cancel" command and use "open resetlogs" to open the database
If it's a production database, contact Oracle Support immediately, or perform my suggestions after testing them on the test server

For more information, refer to the following metalink note:
ORA-314 Attempting to Startup Database following Restore from Cold Backup [ID 330793.1]

Report message to a moderator

Re: ORA-00314: log 3 of thread 1, expected sequence# 207 doesn't match 198 [message #533441 is a reply to message #533440]

Wed, 30 November 2011 00:40

pbardale7
Messages: 28
Registered: November 2011
Location: India

Junior Member

Thank you very much Kamran!!!

open reset log is not working...

I have done as follows:

SQL> recover database until cancel;
ORA-00279: change 10539338 generated at 11/30/2011 11:02:10 needed for thread 1
ORA-00289: suggestion :
/eagledatabase/oracle/flash_recovery_area/EAGLE/archivelog/2011_11_29/o1_mf_1_20
7_%u_.arc
ORA-00280: change 10539338 for thread 1 is in sequence #207

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/eagledatabase/oracle/oradata/Eagle/system01.dbf'

ORA-01112: media recovery not started

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/eagledatabase/oracle/oradata/Eagle/system01.dbf'

Report message to a moderator

Re: ORA-00314: log 3 of thread 1, expected sequence# 207 doesn't match 198 [message #533442 is a reply to message #533441]

Wed, 30 November 2011 00:42

Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku

Senior Member

This means that you're not lucky as the SYSTEM datafile is inconsistent. You have only one option - to restore/recover the database from backup

Report message to a moderator

Re: ORA-00314: log 3 of thread 1, expected sequence# 207 doesn't match 198 [message #533443 is a reply to message #533442]

Wed, 30 November 2011 00:46

pbardale7
Messages: 28
Registered: November 2011
Location: India

Junior Member

What i have to do now?

whats problem, still i didnt understand can you please eloberate it?

Thank you!!!

Report message to a moderator

Re: ORA-00314: log 3 of thread 1, expected sequence# 207 doesn't match 198 [message #533444 is a reply to message #533443]

Wed, 30 November 2011 00:48

Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku

Senior Member

You database is corrupted as the system file has changed, and it's inconsistent. So you need to restore the backup and perform recovery

Report message to a moderator

Re: ORA-00314: log 3 of thread 1, expected sequence# 207 doesn't match 198 [message #533449 is a reply to message #533444]

Wed, 30 November 2011 01:14

pbardale7
Messages: 28
Registered: November 2011
Location: India

Junior Member

how should i do restore back up and recover

Report message to a moderator

Re: ORA-00314: log 3 of thread 1, expected sequence# 207 doesn't match 198 [message #533450 is a reply to message #533449]

Wed, 30 November 2011 01:14

Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku

Senior Member

Do you have sufficient RMAN backups? Do you take backup of the database? Is it a production database? Who's responsible of this database?

Report message to a moderator

Re: ORA-00314: log 3 of thread 1, expected sequence# 207 doesn't match 198 [message #583155 is a reply to message #533449]

Fri, 26 April 2013 06:07

qais_muf
Messages: 1
Registered: February 2010
Location: LAHORE

Junior Member

connect db using RMAN catalog then use the following

RESTORE DATABASE;

then

RECOVER DATABASE;

at last

ALTER DATABASE OPEN RESETLOGS;

I hope this would help you.

Qais

Report message to a moderator

Re: ORA-00314: log 3 of thread 1, expected sequence# 207 doesn't match 198 [message #583163 is a reply to message #583155]

Fri, 26 April 2013 07:42

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

Senior Member
Account Moderator

I doubt this would help someone than had this problem a year and an half ago.

Regards
Michel

Report message to a moderator

Previous Topic:	backup all datafiles only using RMAN
Next Topic:	Duplicating a Database with RMAN

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 12 01:11:46 CDT 2025