Re: recovering oracle database missing control, undotbs and redo files

From: mattma <sk8ratma_at_yahoo.com>
Date: 20 Aug 2002 19:24:25 -0700
Message-ID: <7e050eec.0208201824.6607b1cf@posting.google.com>

Hello! Unfortunately, I can't seem to mount the database

SQL> startup mount pfile=/srv/ora/theravada/dbs/initgo.ora ORACLE instance started.

Total System Global Area 235693104 bytes

Fixed Size                   279600 bytes
Variable Size             167772160 bytes
Database Buffers           67108864 bytes
Redo Buffers                 532480 bytes

ORA-00205: error in identifying controlfile, check alert log for more info

i also tried startup force and it gives the same message. I've tried to mount it also by creating bogus control03.ctl file, and then it gives me errors on missing undotbs01.dbf and redo01.dbf.

Any other ideas?

-matthew

dyou98_at_aol.com (D.Y.) wrote in message news:<f369a0eb.0208200808.4dcecec7_at_posting.google.com>...
> There is a chance you can bring up your database.
>
> If your database was shutdown when disk crash happened,
> startup mount
> alter database datafile '/store2/oradata/go/undotbs01.dbf' offline
> drop;
> alter database datafile '../temp01.dbf' offline drop; -- (skip this
> step if temp01.dbf was created as a tempfile)
> open database resetlogs;
> Then drop and recreate your temp and rollback tablespaces.
>
> If your database was running when disk crashed, run recover database
> before
> openning with resetlogs. This may work if you didn't have uncommited
> transactions at the time of crash. Never ran into this situation
> myself. So
> no gauranttee it will work. But it's worth a try.
>
>
Received on Tue Aug 20 2002 - 21:24:25 CDT