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

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.

sk8ratma_at_yahoo.com (mattma) wrote in message news:<7e050eec.0208200056.605f0eef_at_posting.google.com>...
> Can anyone help me figure out how to start my oracle database when the
> following files are missing?
> 1. one of my 3 control files (control03.ctl)
> 2. one of the redo logs (redo03.dbf)
> 3. one of the temp files (temp01.dbf)
> 4. the undo file (undotbs01.dbf)
>
> My hard disk failed and my most recent backups were on the disk that
> failed which contained the missing files from above. I know - should
> have backed up more dilligently...
>
> The dbf files that actually contain data are all intact. Just can't
> see to get the database to start.
>
> I have tried the following
> 1. regular start using sqlplus /nolog
> result: ORA-00205: error in identifying controlfile, check alert log
> for more info
>
> 2. created fake files by
> a. copying control01.ctl into control03.ctl and placing in the
> original dir
> b. copying redo01.dbf into redo03.dbf and placing in original dir
> c. making fake temp01.dbf and fake undotbs.dbf
> result: ORA-01122: database file 2 failed verification check
> ORA-01110: data file 2: '/store2/oradata/go/undotbs01.dbf'
> ORA-01251: Unknown File Header Version read for file number 2
>
> 3. run "startup force" command inside sqlplus
> result: ORA-03113: end-of-file on communication channel
>
> In all cases, the database "mounts" but will not start properly - when
> you sqlplus into the database it says
> ORA-01033: ORACLE initialization or shutdown in progress
>
> I am running Oracle 9i (9.0.1.0.0).
> I don't have to get it to start - as long as I can dump / export my
> data into something I can access.
>
> Thank you in advance!
Received on Tue Aug 20 2002 - 11:08:29 CDT