13 Replies Latest reply: Jul 27, 2009 10:54 AM by 26741 RSS

    Rman level 0 incremental backup – why restore needs older backups?

    user632098
      I am on Oracle 10.2.0.3 on HP UNIX 11.2

      I have always been doing rman level 0 backup using commands like:
      backup as compressed backupset
      level 0 incremental
      Format 'dbfile_%U%_%t'
      database;

      I thought level 0 incremental is full backup, i.e., does backup of every block in the file.

      My backup was done on July 20,2009 6:00PM and ended on 6:30PM.
      Now I am doing point in time recovery to restore database until July 20, 6:31PM.
      Restore should only need backup files from July 20, 2009 6:00PM onwards, But for some reason
      restore requires backup files as old as from July 10, 2009.

      I thought level 0 incremental does full backup, i.e, it does not need older backups.
      Can any one explain why? Does it have to do with use of compressed?

      I will think in I just did level 0 (without incremental), then for sure I will not need older backups. Using level 0 compressed will do the same, i.e., full backup without requiring older backups. Is that right?