(wrong string) – why restore needs older backups?
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 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. Received on Sun Jul 26 2009 - 03:26:11 CDT