Re: FYI: *ALWAYS* test your recovery plan!

From: <Jared.Still_at_radisys.com>
Date: Tue, 05 Feb 2002 13:00:07 -0800
Message-ID: <F001.00406B27.20020205125900@fatcity.com>

Thanks for the info Jesse. Interesting problem with OmniBack.

Re the table truncation: been there, done that. Had problems with SQL*backtrack that took a couple of hours to resolve. It was a *very* bad time for it.

The developer's privileges were quickly reduced on the production database, something to which he gladly consented. ( hint, hint :)

Jared

"Jesse, Rich" <Rich.Jesse_at_qtiworld.com>
Sent by: root_at_fatcity.com
02/05/02 12:31 PM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        FYI: *ALWAYS* test your recovery plan!

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:
INET: Jared.Still_at_radisys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------