Login Form






Lost Password?
No account yet? Register (FREE)

Search Backup Central

Twitter Updates

Twitter Updates

    follow me on Twitter

    Disclaimer

    The opinions contained within this website, it's blog(s), forums, and Wikis, are those of the original poster and do not represent the position of my (or any other) employer.
    Oracle's incremental update feature (10g) PDF Print E-mail
    Written by W. Curtis Preston   
    Friday, 11 May 2007
    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?

    Comments
    Search RSS
    rrobins  - RMAN backup copy of   |2007-05-11 11:08:22
    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.
    Douglas Striff  - VTL RMAN   |2008-09-25 06:59:42
    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?
    Only registered users can write comments!

    3.26 Copyright (C) 2008 Compojoom.com / Copyright (C) 2007 Alain Georgette / Copyright (C) 2006 Frantisek Hliva. All rights reserved."

     
    < Prev   Next >

    Sponsored Links