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?

----- Signature and Disclaimer -----

Written by W. Curtis Preston (@wcpreston). For those of you unfamiliar with my work, I've specialized in backup & recovery since 1993. I've written the O'Reilly books on backup and have worked with a number of native and commercial tools. I am now Chief Technical Architect at Druva, the leading provider of cloud-based data protection and data management tools for endpoints, infrastructure, and cloud applications. These posts reflect my own opinion and are not necessarily the opinion of my employer.

4 thoughts on “Oracle's incremental update feature (10g)

  1. rrobins says:

    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.

  2. kc5ddg says:

    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?

  3. Syed imran says:

    Hi,

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

    any way thank’s

    Syed Imran
    (Sr. Oracle Dba) 🙄

Leave a Reply

Your email address will not be published. Required fields are marked *