DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: RMAN incremental backup

  1. #1
    Join Date
    Nov 2000
    Posts
    164

    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

  2. #2
    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.

  3. #3
    Join Date
    Nov 2000
    Posts
    164
    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

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Quote Originally Posted by Unna View Post
    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
  •  


Click Here to Expand Forum to Full Width