Re: Oracle Database Server Died, doesn't come back up

[ snip ]

> ORA-01157: cannot identify/lock data file 11 - see DBWR trace file
> ORA-01110: data file 11: '/raid5/ora/817/XXXXxxxxxxxxx.dbf'
>
> SVRMGR> quit
> Server Manager complete.
>
> The specified datafile does not exist.
Of course not. But the control file shows that it did - this is the cause of the error.

>
> I did a find in the oracle path but there are no DBWR files.
Look in $ORACLE_BASE/$SID/bdump for the file (it will also be described in the alert log - same directory).

>
> I looked at the error messages and based on those, I ran the "alter
> system check datafiles" command after shutting down the server and
> touching a file name of the missing file. Now if finds the file and
> instead of the lock error, it says that it can't read beyond the first
> block or something.
>
> I presume the problem is a mismatch of an entry in the catalog for a
> file and the fact that the file didn't get created for some reason. I
> just don't know what commands to use to remove the entry from the
> catalogs. Any queries on dba_data_files seems to fail at this point.
>
> Anything you can suggest for me to try will be welcome.
Recover from a backup. Read the Backup &Recovery docs.

>
> Bob
>

-- 
Ron Reidy
Oracle DBA