In Open World 2009, my second presentation was a joint session with my friend Timothy Chien who works for Oracle as Principal Product Manager of Database HA products. The room was almost full (~900 people).Thanks to all attendees. It seems this topic is still hot 
. You can find Tim’s and my part below:
October 19, 2009
“Oracle Database Backup-and-Recovery Best Practices and New Features” Material
4 Comments »
RSS feed for comments on this post. TrackBack URI
thanks for good sharing
Comment by yasin saygılı — October 25, 2009 @ 7:25 pm |
Question regarding the backup for Husnu Sensoy:
If you backup compress your database like you showed:
run{
backup as compressed backupset
check logical incremental level 1
for recover of copy with
tag DAILY_COPY database
filesperset 1;
recover copy of database with
tag DAILY_COPY;
}
You then show how to restore to your backup with the following command:
switch database to copy;
your backup compressed right? What will happen? Your backup will automatically uncompressed?
Comment by Steeve — October 27, 2009 @ 8:46 pm |
Hi Steeve,
Let me try to explain what that script does.
In the first execution, first part of the script ( backup as comp…) understands that it is not possible to get an incremental backup to recover a database copy because there is no backup to be used as a base backup. So it starts to copy all datafiles of database into FRA (those are image copies not backupsets (no compression)).
In following runs, first part of the script takes incremental compressed backupset backup that contains the changes since previous execution. And the second part(recover copy…) recovers (rolls forwards is a better term maybe) the image copies by using this incremental backupset and makes image copies recent.
Finally “switch database to copy” command has nothing to do with backupsets but image copies. Command simply update the control file to replace actual file names with image copy names. So there is no automatic uncompression staff.
Regards,
HS
Comment by kocakahin — October 27, 2009 @ 10:02 pm |
Hi,
Realy very good afford for sharing nice materials.
Thanks and regards,
Gitesh
http://www.dbametrix.com
Comment by dbametrix — November 4, 2009 @ 8:06 pm |