recovering oracle database missing control, undotbs and redo files

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

1. copying control01.ctl into control03.ctl and placing in the original dir
2. copying redo01.dbf into redo03.dbf and placing in original dir
3. 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
4. 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 - 03:56:43 CDT