Oracle's incremental update feature (10g)

If you've got Oracle 10g, this is a really cool feature that allows for synthetic full backups inside Oracle.

If you're backing up to disk with Oracle (actual disk, not a VTL), you can select COPY as the backup type instead of BACKUPSET.  A backupset is the "normal" backup, which is basically a blob of data that contains one or more data files (think tar file).  A COPY, on the other hand, is simply that.  It's a copy of the oracle data file, which is why this backup type exists only on disk.  (It's called an image copy.)

If you have an image copy on disk, you can perform an incremental backup and have that incremental backup update the image copy, resulting in a new full backup without having to actually take another full backup (i.e. a synthetic full).  That could help a lot when backing up large databases — as long as you've got enough room to store an entire copy of your database.

One bummer is that there doesn't appear to be a way to move that image copy to tape inside RMAN.  You could back up the files with regular backup software, but I don't think you'd be able to use RMAN to restore with them, as RMAN will only know about the current, updated version of the  backup set.  If you wanted to restore a previous version, it wouldn't know what to do with that.

I wonder if you could use these image copies to restore outside of RMAN, as in a user-managed backup.  Then I wonder if you could apply redo logs to those restored datafiles.  Wish I had some time to play with Oracle to find out.

Anyone know the answers to my questions?

Written by W. Curtis Preston (@wcpreston), four-time O'Reilly author, and host of The Backup Wrap-up podcast. I am now the Technology Evangelist at Sullivan Strickler, which helps companies manage their legacy data

4 comments
  • As I understand it, the RMAN command BACKUP COPY OF will create a backupset of the image copy and can send it to tape.
    You could then have your most up-to-date copy sitting on disk, and send it to tape on a regular basis.

  • I have a similar question myself. I am looking at trying to figure out if a VTL solution is the way to go. We use DD gateways right now to file based and are looking to replace that so we can relocate the backup and are considering a VTL. Is this a wise move and would it allow for incrementals and fulls?

  • Hi,

    If u can add more about incremental backups using Rman and their levels.

    any way thank’s

    Syed Imran
    (Sr. Oracle Dba) ๐Ÿ™„