Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: recovery strategies for multi-terabyte database

Re: recovery strategies for multi-terabyte database

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Mon, 16 Aug 2004 18:00:08 -0700
Message-ID: <1092704454.739095@yasure>


Joel Garry wrote:

> Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1092447562.913049_at_yasure>...
> 

>>Prem K Mehrotra wrote:
>>
>>
>>>Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1092406609.341901_at_yasure>...
>>>
>>>
>>>>Rob De Langhe wrote:
>>>>
>>>>
>>>>
>>>>>Hi,
>>>>>
>>>>>we are interested to know what DBAs have selected as realistic recovery
>>>>>(and corresponding backup) strategy for a database with multiple
>>>>>terabytes of data.
>>>>>
>>>>>Internet talks everywhere about backup performances, but nowhere the
>>>>>actual recovery method is discussed for such a large database. Even when
>>>>>doing online backups, you still need a way to get this huge dbase back
>>>>>into a consistent mode, or get a set of data backup in the dbase.
>>>>>
>>>>>We are using Solaris-9, Oracle 9.2, SAN storage, Veritas Netbackup, and
>>>>>LTO tape robot.
>>>>>
>>>>>TIA for any suggestions
>>>>>
>>>>>Rob
>>>>
>>>>Get a duplicate storage array likely NetApp, EMC, Hitachi, or IBM and
>>>>use the snap-mirror capability to mirror changed blocks to the second
>>>>array. Be sure the duplicate array is at least 500 miles away from
>>>>the primary and connect them with a T3.
>>>>
>>>>Then don't waste your time backing up anything.
>>>
>>>Dan:
>>>
>>>Pardon my ignorance, what happends if something got corrpted, you
>>>accidently deleted some data/table or for whatever reaosn you have to
>>>do point in time recovery. How will one accomplish that using
>>>snap-mirror type of backups.
>>
>>Corruption:
>>Same thing that happens when you have a tape containing corrupt blocks.
>>
>>Deletion:
>>Learn about how snap works ... learn about how table flashback works.
>>Implement the appropriate solution.
>>
>>Point-in-time:
>>Archive logs
>>
>>To be truthful I was being a bit flippant. I do believe in backups.
>>But not like I used to. I haven't had to run for a backup tape in
>>more than 5 years. And I don't believe anyone is backing up today's
>>mutli-terabyte databases to tape anymore.
> 
> 
> Is http://groups.google.com/groups?selm=3FA92229.F1ECFA%40remove_spam.peasland.com&output=gplain
> out of date?
> 
> jg
> --
> @home.com is bogus.
> I think it is more important to be able to recover from mistakes than
> to avoid them.  You can't avoid them.

Ok ... a few people are. Though I can't imagine why.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Aug 16 2004 - 20:00:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US