Re: HELP with Crashed Database

Tony Stone wrote:

> I am able to connect and mount my database, but not able to open it.
> I am running Oracle 7.2.2 on Novell.
> I am getting an ORA-00314 -- log 2 of thread 1 expected sequence #
> doesn't match and ORA-00312 online log 2 thread 1:
> 'sys:oranw\database\wglog1.ora when I attempt to open the database. I
> believe that I am having a problem with my my online log files.
> An suggestions on how to repair my database so that I can open it.
> I have been doing cold backups - this is the situation after restoring
> the files after my hard drive crashed.
>
> Thank you.
>
> Tony Stone

Hi Tony,
it seems that this online redo-log file doesn't match by the system-change-number in the controlfile. Try to select from v$log and v$logfile while the instance is mounted. Have y look to the column v$log.FIRST_CHANGE# and check if the values of the different logfile groups seems to be ok.

Greetings,
Tobias Hitzfeld Received on Fri Oct 01 1999 - 05:59:05 CDT