| 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: *ALWAYS* test your recovery plan!
Rich,
I've always said to test your recovery plan frequently.
The standard joke here (when we were starting to test Rman with Edm) was
that:
"We can back-up anything. It's the restore part that is giving us trouble".
Glad at least you can get your db back.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Tuesday, February 05, 2002 3:31 PM
To: Multiple recipients of list ORACLE-L
So, here we are, restoring production from tape. Our recovery methods are sound (we have two or three ways back, depending on circumstances) as we will have ZERO loss of data with minimal downtime in off-hours, but we hit a bit of a snag today.
We need to recover all datafiles from tape. The tape we need is an incremental, but due to an apparent bug in HP's OmniBack software, it thinks it needs to recover all datafiles from the full backup, then all of them from the incremental. This has the effect of almost doubling our recovery time. Since our DB files are "only" about 23GB, we need to effectively restore 46GB. Now if this were 150GB...
Long story short: TEST YOUR DATABASE RECOVERY! We've tested before, so this must've cropped up in an Omniback upgrade.
BTW, our production DB is fine, except for the 3M row table a developer truncated... ;)
Hope this helps someone!
Rich Jesse System/Database Administrator Rich.Jesse_at_qtiworld.com Quad/Tech International, Sussex, WI USA
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 Tue Feb 05 2002 - 15:05:20 CST
 |
 |