Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!rip!news.webusenet.com!peer01.cox.net!cox.net!border3.nntp.aus1.giganews.com!intern1.nntp.aus1.giganews.com!nntp.giganews.com!nntp.comcast.com!news.comcast.com.POSTED!not-for-mail
NNTP-Posting-Date: Fri, 08 Aug 2003 19:29:41 -0500
Message-ID: <3F343F5A.3090705@comcast.net>
Date: Fri, 08 Aug 2003 18:24:58 -0600
From: Ron Reidy <r_reidy@comcast.net>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: Oracle Database Server Died, doesn't come back up
References: <l8zvft7znsu.fsf@timevest.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 43
NNTP-Posting-Host: 12.208.239.34
X-Trace: sv3-y4h8NqShC9EylKwnb/L0fKflK+n50On0jLULVxZSoe4IsLS9yJUQy3b3u/+ELX/ETRsrRp9FZvgu+bf!THRLN3ej/D6OQBhW5+fXedXhO1RccPF7cMuTO+OwWM7NDOWVgN6IwA==
X-Complaints-To: abuse@comcast.net
X-DMCA-Complaints-To: dmca@comcast.net
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.1
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:240150



[ 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