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: O816 Startup Fails

Re: O816 Startup Fails

From: Klaus.Zeuch <Klaus.Zeuch_at_t-online.de>
Date: 2000/06/21
Message-ID: <8ircqo$sco$16$1@news.t-online.com>#1/1

Hi,

maybe ORA-204 should be read ORA-00204: A disk I/O failure was detected on reading the control file; i.e. control file lost?

If that's the case:
startup nomount
create controlfile...(if you're lucky you generated a copy of your controlfile with alter database backup controlfile to trace - file contains the proper create controlfile statement; if you don't have a backup consult your documentation for correct syntax)
alter database mount
alter database open

maybe that you must recover your database before mounting (recover database - archived redo logs available?) if the last shutdown was not normal or immediate

You should mirror your controlfiles - modify your init.ora

Hth

Klaus

"Jean De Bulge" <nospam.jbulck_at_hotmail.com> schrieb im Newsbeitrag news:cL945.9480$iW.200611_at_news.chello.be...
> Since a powercut yesterday my O816 on NT4 doesn't startup anymore.
> (the processes are there, but they don't mount the database (?))
> I've performed a CHKDSK, but that doesn't show any problems...
> I can copy the *dbf files, so I assume they are still readable.
> The Alert file terminates as follows:
>
> RECO started with pid=7
> SNP0 started with pid=8
> SNP1 started with pid=9
> SNP2 started with pid=10
> SNP3 started with pid=11
> Wed Jun 21 21:56:07 2000
> starting up 1 shared server(s) ...
> starting up 1 dispatcher(s) for network address
> '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
> Wed Jun 21 21:56:09 2000
> alter database mount exclusive
> Wed Jun 21 21:57:21 2000
> ORA-204 signalled during: alter database mount exclusive...
>
> Does anybody know ORA-204?
> Does anybody knows good sources to investigate what's wrong?
>
> Thank you very much!
> J.
>
>
Received on Wed Jun 21 2000 - 00:00:00 CDT

Original text of this message

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