Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: HELP with Crashed Database

Re: HELP with Crashed Database

From: Neil C <btsscrth_at_bt.com>
Date: Fri, 1 Oct 1999 09:25:53 +0100
Message-ID: <7t1r5f$1r6$1@pheidippides.axion.bt.co.uk>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US