Dear all,

I have nightly backup on 10g database: level 0 on Sunday and on other days level 1 incremental backups. However, what I don't understand is why my level 1 backup file size is larger than my level 0 backup file, 9.5GB vs 4.3GB? The level 0 backup is like cold backup, this backup file size is bigger than incremental file.

From the log file, I didn't see any error. Here are my scripts for both level 0 and level 1 backups:

backup as compressed backupset incremental level 0
(database include current controlfile);
sql 'alter system archive log current';
backup as compressed backupset filesperset 5
archivelog all;


backup as compressed backupset incremental level 1
(database include current controlfile);
sql 'alter system archive log current';
backup as compressed backupset filesperset 5
archivelog all;

Can anyone shed light on this, if you see error any where?


Thanks in advance,
Unna