Re: RMAN Incremental

Michael,

Another good treatment of the use of partitioning in DW to reduce backups is a paper by Jeff Maresh posted online at ³http://www.EvDBT.com/papers.htm², entitled ³Managing the Data Lifecycle².

-Tim

on 10/24/03 4:34 PM, Michael Kline at mkline1_at_comcast.net wrote:

> I'm working at a Data Warehouse and they are looking for backup
> possibilities...
>
> This is almost a TB, a baby, and it may be that RMAN with incremental could be
> a good solution.
>
> If say for instance there is a single tablespace of some 100 gig and they add
> 200,000,000 records to one of the tables and we do an incremental backup. Is
> the whole tablespace slated for backup?
>
> Also if this tablespace was lost, and we recover.. What happens during that
> process? Does RMAN basically have to filter through two complete copies of
> that tablespace or just once and then get changed blocks?
>
> What solutions have some doing this found to be "best practice"?
>
> Thanks.
>
> Michael Kline, Principal Consultant
> Business To Business Solutions, LLC
> Richmond, VA
> 804-744-1545
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: tim_at_sagelogix.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).