RE: *ALWAYS* test your recovery plan!

been there, done that

-----Original Message-----
Sent: Tuesday, February 05, 2002 12: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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: ksmith2_at_myfirstlink.net

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).