(wrong string) €“ why restore needs older backups?

From: zigzagdna <zigzagdna_at_yahoo.com>
Date: Sun, 26 Jul 2009 01:26:11 -0700 (PDT)
Message-ID: <7fe4c1bc-8f2d-47c2-b8e7-1b13c6d6eb3e_at_k30g2000yqf.googlegroups.com>

I am on Oracle 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'

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. Received on Sun Jul 26 2009 - 03:26:11 CDT

Original text of this message