Duplicate your database using RMAN. Then export/import the table that was dropped.
Of course, this means that you need to have an extra 150 Gb of disk space lying around.
-----Original Message-----
Sent: Monday, August 27, 2001 5:11 PM
To: Multiple recipients of list ORACLE-L
DBAs
Last week one of my user dropped a table since we don't have any backup
except for rman backup. It is not allowe me to do any recovery on 7/24
database. Anyway we recreate the table(we are lucky, this table hold
parameters)
This make me think of situation of lossing very important big table. We have
about 1000 tables with bigget one of 8GB .
Is there any idea how to perform a logical backup on a database with 150GBs.
Or take a TSPITR in case of those kind of thing happen again. From my
case, imp/exp looks impossibe from point of view of timing and spacing. The
question will be the same for TSOITR on large database. Is there any other
way to prepre those kind of situation.
Mitchell
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mitchell
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christopher Spence
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
Jay Hostetter
Oracle DBA
D. & E. Communications
Ephrata, PA USA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jay Hostetter
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
