Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP with Crashed Database
It sounds like you may have restored your database (will would need to have
restored all the datafiles from the cold backup, not just the files that may
have been lost), but have the online redo logs from the crashed database.
If this is the case,
I would remove these redo logs,
mount the database, use 'recover database until cancel' (this should return
to the prompt straight away)
then enter 'alter database resetlogs;'
HTH Neil
Tony Stone wrote in message <37F462D1.3D58EFA8_at_hotmail.com>...
>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
>
Received on Fri Oct 01 1999 - 03:25:53 CDT
![]() |
![]() |