This change has to do with the ability to recover through an incarnation. It really does not change the basic fact that you have to have a base level 0 backup... it's just that now, that level 0 backup can exist in a previous incarnation if compatible is set correctly. RF Robert G. Freeman Master Principal Consultant, Oracle Corporation, Oracle ACE Author of various books on RMAN, New Features and this shorter signature line. Blog: http://robertgfreeman.blogspot.com ________________________________ From: Leyi Zhang (Kamus) <kamusis@xxxxxxxxx> To: karlarao@xxxxxxxxx Cc: "mccdba1@xxxxxxxxx" <mccdba1@xxxxxxxxx>; "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx> Sent: Sat, June 19, 2010 11:08:12 PM Subject: Re: RMAN incremental backup level ??? Maybe there are someone, haven't noticed incremental backkup changed in someway after 10g, just like me :-) If NO level 0 backup exists, what would happen when you issue a level 1 backup? I shared this reading to listers. Briefly, it depends on compatibility initial parameter. http://download.oracle.com/docs/cd/E11882_01/backup.112/e10642/rcmcncpt.htm +++++++++ Differential Incremental Backups In a differential level 1 backup, RMAN backs up all blocks that have changed since the most recent incremental backup at level 1 (cumulative or differential) or level 0. For example, in a differential level 1 backup, RMAN determines which level 1 backup occurred most recently and backs up all blocks modified after that backup. If no level 1 is available, then RMAN copies all blocks changed since the base level 0 backup. If no level 0 backup is available in either the current or parent incarnation, then the behavior varies with the compatibility mode setting. If compatibility is >=10.0.0, RMAN copies all blocks that have been changed since the file was created. Otherwise, RMAN behaves as it did in previous releases, by generating a level 0 backup. +++++++++ -- Kamus <kamusis@xxxxxxxxx> Visit my blog for more : http://www.dbform.com Join ACOUG: http://www.acoug.org On Sat, Jun 19, 2010 at 9:52 AM, Leyi Zhang (Kamus) <kamusis@xxxxxxxxx> wrote: > Actually start from 10gR1 doc, there's only incremental level 0 and 1, > no 2,3,4 anymore. > http://download.oracle.com/docs/cd/B14117_01/server.101/b10735/bkup.htm#1034168 > > I think Karl mentioned MOS note should be 733535.1 > > "Yes the backup incremental level 2 is supported in Oracle10g. > Reference to this level was removed > from the documentation for simplicity sake. Realistically, a level 2 = > a differential level 1." > > -- > Kamus <kamusis@xxxxxxxxx> > > Visit my blog for more : http://www.dbform.com > Join ACOUG: http://www.acoug.org > > > > On Fri, Jun 18, 2010 at 11:54 PM, Karl Arao <karlarao@xxxxxxxxx> wrote: >> Afaik Yes .. I think the level 2 will still work but it will still be >> treated as level1.. >> And There's a mos note about this.. I'll post it here once I get hold of it.. >> >> I encountered this one when I was fixing an rman backup script on a client.. >> >> - Karl Arao >> >> On Friday, June 18, 2010, dba1 mcc <mccdba1@xxxxxxxxx> wrote: >>> I look ORACLE RMAN 11G user's guide and found RMAN incremental backup only >>> have level 0 and 1. >>> >>> Is it true after ORACLE 10GR2 there is no level 2, 3, 4 incremental backup >>> for RMAN? >>> >>> Thanks. >>> >>> >>> >>> -- >>> //www.freelists.org/webpage/oracle-l >>> >>> >>> >> >> -- >> Karl Arao >> karlarao.wordpress.com >> karlarao.tiddlyspot.com >> -- >> //www.freelists.org/webpage/oracle-l >> >> >> > -- //www.freelists.org/webpage/oracle-l