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 [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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).
