From: ctemp01@hotmail.com (ctemp)
Newsgroups: comp.databases.oracle.server
Subject: Re: Recovery Question
Date: 8 Aug 2001 13:11:09 -0700
Organization: http://groups.google.com/
Lines: 10
Message-ID: <4d44e6cf.0108081211.c0dd407@posting.google.com>
References: <9k9pus$5ak$1@oac2.hsc.uth.tmc.edu> <D15ED542E12BD3119FFE00805F6551F00BF5E4B8@mailwhqnews.cerner.com>
NNTP-Posting-Host: 141.156.74.226
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 997301469 5217 127.0.0.1 (8 Aug 2001 20:11:09 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 8 Aug 2001 20:11:09 GMT


It seems you didn't read all information in this thread which
obviously contains the answer for your question.

1. restore all the database files from the LAST cold backup (last
Sunday).
2. startup mount
3. recover database using backup controlfile;
4. ...
5. alter database open resetlog;
6. cold backup database IMMEDIATELY.