Login Form






Lost Password?
No account yet? Register (FREE)

Search Backup Central

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. This blog is not owned by my employer nor does it officially represent any company.
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
Add NewSearchRSS
rrobins - RMAN backup copy of   | Registered | 2007-05-11 14: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.
Only registered users can write comments!

Copyright (C) 2007 Alain Georgette / Copyright (C) 2006 Frantisek Hliva. All rights reserved.

 
< Prev   Next >

Sponsored Links