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