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))
ORA-00314: log 3 of thread 1, expected sequence# 207 doesn't match 198 [message #533431] Wed, 30 November 2011 00:15 Go to next message
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.
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 Go to previous messageGo to next message
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;
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 Go to previous messageGo to next message
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?
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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'

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 Go to previous messageGo to next message
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]
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 Go to previous messageGo to next message
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'

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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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!!!
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
pbardale7
Messages: 28
Registered: November 2011
Location: India
Junior Member
how should i do restore back up and recover
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 Go to previous messageGo to next message
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?
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 Go to previous messageGo to next message
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




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 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I doubt this would help someone than had this problem a year and an half ago.

Regards
Michel
Previous Topic: backup all datafiles only using RMAN
Next Topic: Duplicating a Database with RMAN
Goto Forum:
  


Current Time: Thu Mar 28 04:17:15 CDT 2024