Re: emergency rescue needed

From: Tim Gorman <tim_at_evdbt.com>
Date: Sun, 06 Feb 2005 20:43:01 -0700
Message-ID: <BE2C31D5.23054%tim@evdbt.com>

If you have access to MetaLink, then can't you open a TAR? After all, that's their job and you're paying them quite well for it. At least open a TAR while you're pinging this list -- the more brains working on it, the better for you...

When using MetaLink, use the error message number and text as search keywords. For instance, if you are getting an ORA-01578 message, then searching on the phrase "ORA-1578" immediately brings up at least two dozen bulletins, references, and FAQs, literally *tons* of information on MetaLink for dealing with block corruption, including instructions and procedures.

It is a mistake to assume that you know the solution and then to search on keywords related to your proposed solution. Start with the error messages as search keywords and work from there.

on 2/6/05 6:41 PM, Fuad Arshad at fuadar_at_yahoo.com wrote:

> what is the problem what errors are you getting need
> more detail
> --- sol beach <sol.beach_at_gmail.com> wrote:
> 

>> I had/have a test DB where a number of files got
>> corrupted.
>> I just HAVE be able to open this DB.
>> I am willing to sacrafice the data in the corrupted
>> files.
>> What are the steps to do so?
>> It is something along the lines of STARTUP NOMOUNT
>> ALTER TABLESPACE ???? OFFLINE;
>> DROP TABLESPACE ?????;
>> STARTUP MOUNT;
>> ALTER DATABASE OPEN;
>>
>> I've just looked in Metalink & did not find where
>> this procedure is documented.
>> --
>> http://www.freelists.org/webpage/oracle-l
>>

> 
> --
> http://www.freelists.org/webpage/oracle-l
> 

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Feb 06 2005 - 22:44:51 CST