Indy - First, I would urge you to contact Oracle Support. You pay them for
support and they are pretty good at walking you through a recovery. A
problem with an email list like this is that you may get a variety of
opinions. For many issues that is good, but in a critical situation,
multiple opinions can be distracting. Aside from the fact that this list has
a delay time of up to 2 hours.
What is the situation with the rest of your database? Did you shut off
access to your database by other users when this situation occurred? Do you
have the option of recovering the entire database to just before the
failure, or will you need to recover this tablespace on another server, then
move it back to the production database?
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Monday, June 02, 2003 6:20 AM
To: Multiple recipients of list ORACLE-L
Please Reply Ur Suggestion at the earliest
One of DBA had dropped the Wrong tablespace for the PArtitioned table. The
Datafile exist on the system. How to recover the Tablespace as it contains
crucial data. RMAN backup also available along with Archive as well as
Correct timing of Dropping the Datafile
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
