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

Hi Mattma,

A bit more info.

You've lost the most recent backup. Do you have an earlier backup and all the redo logs since the previous backup (please have an earlier backup and the redo logs, pretty please) ?

Was the database up and running when you had the disk crash or was it shutdown (please be shutdown, pretty please)?

Do you have your redo logs mirrored or was the lost redo log the only member (please have a second member, pretty please)?

Was the undo data file from the current undo tablespace (please be from a non current undo tablespace, pretty please).

This is for real and isn't some exam question ?

The control file doesn't worry me, neither does the temp file. The redo log is a bit of a concern and the lost undo file is real concern.

Supply the above answers and we'll see what we can do.

Cheers

Richard

mattma wrote:
>
> 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 - 04:16:01 CDT