Re: RMAN Restore with Incremental

From: Charlotte Hammond <charlottejanehammond_at_yahoo.com>
Date: Thu, 3 Apr 2008 09:47:43 -0700 (PDT)
Message-ID: <416697.90148.qm@web50210.mail.re2.yahoo.com>

Ah - I get what's happened now (I think). The "base" full backup for my incremental backup was a "backup database" not a "backup incremental level 0 database", so it wasn't really a proper base for the incremental level 1.

Therefore the incremental level 1 had to backup everything (and hence was the backup of choice for the restore).

This raises the question - what is the purpose of the "full" database backup? Is it just an "incremental level 0" that can't be used with incrementals? If so, why have it?

Thank you!
Charlotte

Original Message ---- From: Robert Freeman <robertgfreeman_at_yahoo.com> To: Charlotte Hammond <charlottejanehammond_at_yahoo.com> Sent: Thursday, April 3, 2008 2:44:38 PM Subject: Re: RMAN Restore with Incremental

The smaller backup set size could reflect a change in the underlying data, a mass delete of rows for example. Without a block change tracking file, one block change in a datafile will cause the entire datafile to be backed up in an incremental. Hense, the BCTF is pretty darned important! :-)

Robert G. Freeman
Author:
Oracle Database 11g New Features (Oracle Press) Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Feature
Blog: http://robertgfreeman.blogspot.com (Oracle Press)

Original Message ---- From: Charlotte Hammond <charlottejanehammond_at_yahoo.com> To: Robert Freeman <robertgfreeman_at_yahoo.com> Cc: oracle-l_at_freelists.org Sent: Thursday, April 3, 2008 7:29:12 AM Subject: Re: RMAN Restore with Incremental

Hi Robert,

You're right on two counts: I'm not using block change tracking, and yes, 409400 does contain all the datafiles. However it's only about 70% of the size of the full backup set (both are compressed backupsets). When would an incremental backup backup the entire database (except if every single block has changed, which would seem unlikely) - does it switch to do a full backup if X% of blocks have changed?

Thanks
Charlotte

Original Message ---- From: Robert Freeman <robertgfreeman_at_yahoo.com> To: charlottejanehammond_at_yahoo.com Sent: Wednesday, April 2, 2008 5:08:03 PM Subject: Re: RMAN Restore with Incremental

Sometimes an incremental backup will end up backing up the entire database. This is particularly true if you are not using a block change tracking file. In fact, if you are using retention criteria and the FRA you might well see the base level 0 GO AWAY because, according to the retention criteria, it is really no longer needed.

List the details of your 409400 backup contents. I bet you find all the datafiles in it.

You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost. http://tc.deals.yahoo.com/tc/blockbuster/text5.com

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 03 2008 - 11:47:43 CDT

This message: [ Message body ]
Next message: Allen, Brandon: "RE: Reading UNDO and displaying it in v$session"
Previous message: M Rafiq: "RE: Multiple listeners (9i/10g) on Windows"
Maybe in reply to: Charlotte Hammond: "RMAN Restore with Incremental"
Next in thread: Robert Freeman: "Re: RMAN Restore with Incremental"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message