Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> A way to restore a DB
Dear gurus !
We are evaluating a "strange" way to "recover" a production DB.
This is a 3.7 TB database, still growing, with LOTS of data inserted every 5
minutes (and several partitions belonging to several tables get dropped each
day - we keep historical data for 90 days back), which we used to backup
with RMAN to HP Omniback controlled tapes.
We had a failure, and it took almost 48 hours to restore/recover the DB (in
addition to backed DB files, I had to restore thousands of archived logs
from tapes and apply them to the DB).
We can not afford to have the DB down for 2 days.
Now, we decided to give up RMAN hot backup, actually to give up backup (in
it's classic meaning) at all.
I'll explain why: It's very important for us to get the DB up & running ASAP
after a crash. We want the DB operating much more than we care about
historical data that reside in our DB. Our goal is to enable the inserts
(which run every 5 minutes, as I have stated) ASAP.
So, we plan to do the following backup/recovery procedures:
What do you say ?
Any reviews of my steps and the idea in general ?
And , do you have a script that can re-engineer a DB (as in my step 1) ?
Thanks a lot in advance.
Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit
The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.
This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact Postmaster_at_fatcity.com for clarification.
------_=_NextPart_001_01C293CD.41B3DB00--
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: andreyb_at_elrontelesoft.com 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Sun Nov 24 2002 - 09:23:37 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).