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

Thread: RMAN incremental backup

Hybrid View

  1. #1
    Join Date
    Nov 2000
    Posts
    162

    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
    162
    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,002
    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.
    this space intentionally left blank

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