Home » RDBMS Server » Server Administration » mismatch in redo log files and database is not open
mismatch in redo log files and database is not open [message #52175] Sun, 07 July 2002 06:21 Go to next message
durga
Messages: 3
Registered: July 2002
Junior Member
Errors in file D:OracleadminorclbdumporclLGWR.TRC:
ORA-00314: log 2 of thread 1, expected sequence# 110 doesn't match 106
ORA-00312: online log 2 thread 1: 'D:ORACLEORADATAORCLREDO03.LOG'

Report message to a moderator

Re: mismatch in redo log files and database is not open [message #52177 is a reply to message #52175] Sun, 07 July 2002 12:39 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
To be in the safer side, make sure, you have a uptodate complete database backup before attempting any of these

If your control files and datafiles are all upto date and only the online redo files are whining you can try this:

SQL> RECOVER DATABASE UNTIL CANCEL
SQL> alter database open resetlogs

ELSE
u need to do recover database.

Report message to a moderator

Re: mismatch in redo log files and database is not open [message #52228 is a reply to message #52175] Wed, 10 July 2002 04:00 Go to previous message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
heyy Mahesh u r right,
but u forgot one option..
b4 performing the above steps , you must restore the datafiles and control files in to their original position and then say the commands u mentioned...

sai

Report message to a moderator

Previous Topic: Strange listener problem - help needed pls
Next Topic: ORA-01034: ORACLE not available, ORA-27101: shared memory realm does not exist
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Sep 27 02:27:24 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.