-
RMAN incremental backup
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
-
How much redo are you creating during the week? I don't see anything that is deleting the archive logs above. It could be most of your backup size is in archive logs.
-
Before each backup I have:
crosscheck backup;
delete expired backup;
crosscheck archivelog all;
After backup I have:
resync catalog;
Each day I have about 4GB archived backups.
Thanks,
Unna
-
Originally Posted by Unna
Before each backup I have:
crosscheck backup;
delete expired backup;
crosscheck archivelog all;
After backup I have:
resync catalog;
Each day I have about 4GB archived backups.
Thanks,
Unna
You should make sure you have block change tracking turned on.
Otherwise you might be getting more than an incremental backup.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|