| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Logical Backup for a large database
Just 8Gb table, you should be able to just type the data back in if you loose it, what would it take, 15 minutes?
"Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275
Fuelspot
73 Princeton Street
North, Chelmsford 01863
-----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: mitchell_at_comnet.ca
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: ListGuru_at_fatcity.com (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).
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: ListGuru_at_fatcity.com (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). Received on Thu Aug 30 2001 - 07:51:17 CDT
 |
 |