This content has been marked as final.
Show 9 replies
-
1. Re: Is this script taking Image copies ?
vlethakula Jan 21, 2013 3:35 PM (in response to BlueSkies)Yes, the script takes updated RMAN incrementla image copies.1 person found this helpful
We need to use switch command which will make the controlfile to point to the backup of datafiles present on disk.
For eg: You have lost user datafile 7
rman>switch datafile 7 to copy;
rman>recover datafile 7;
rman>alter database datafile 7 online;
The problem with incremental updated backups is that, after any failure like above, if we restore them it will alter the name and the location of datafile. After restoration you have to manual rename them to original location.
Incase of database failure
rman>switch database to copy;
rman>recover database;
rman>alter database open
Edited by: vlethakula on Jan 21, 2013 7:35 AM -
2. Re: Is this script taking Image copies ?
Mihael Jan 21, 2013 3:26 PM (in response to vlethakula)The problem with incremental updated backups is that, after any failure like above, if we restore them it will alter the name and the location of datafile. After restoration you have to manual rename them to original location.
Can you, please, explain what will the problem? What is the difference in restoring and switching usual image copies and updatable ? -
3. Re: Is this script taking Image copies ?
vlethakula Jan 21, 2013 3:37 PM (in response to Mihael)For eg:
Your datafile 6 is located in
/u01/oradata/test/test06.dbf
Now you have lost datafile 6, when you restore from backup using rman restore command
resotre datafile 6 -------------> It resotres into same location /u01/oradata/test/test06.dbf
If you want to use incrementally updated image copy, the image copy is located in /u02/imagecopy
After switch datafile 6 to copy ------------> The new location of datafile would be /u02/imagecopy/bk_6
Check this demo:
http://gavinsoorma.com/2009/07/rman-recovery-using-the-switch-database-to-copy-command/ -
4. Re: Is this script taking Image copies ?
Pinela Jan 21, 2013 4:45 PM (in response to Mihael)Basically,1 person found this helpful
when you restore a datafile (with no additional information) you restore it to the location of the datafile indicated in the CF. From location A (the backup piece) to location B (in the CF).
when you switch a datafile to a datafile copy you tell the CF to update the location it contains of datafile Y. So if you took a backup file copy to location A, when you switch, you tell the CF to update its location from location B, to location A.
which means that the datafile may be in a strange place.
br,
jpinela. -
5. Re: Is this script taking Image copies ?
Mihael Jan 21, 2013 6:55 PM (in response to vlethakula)If you want to use incrementally updated image copy, the image copy is located in /u02/imagecopy
Thank you for answer. But I think that it is the same if we use usual image copies, created by "backup as copy".
After switch datafile 6 to copy ------------> The new location of datafile would be /u02/imagecopy/bk_6 -
6. Re: Is this script taking Image copies ?
Hemant K Chitale Jan 22, 2013 1:58 AM (in response to BlueSkies)This is the "Incrementally Updated Backups" strategy which Oracle documents but some of us are not comfortable with.
See http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmbckba.htm#CHDEHBFF
Why I am not comfortable ?
(1) It causes the backup to be local to the database server -- i.e. on the same SAN as the target database ! (unless you really connect two different SANs to the database server)
(2) It provides for only 1 backup of the database to be available at any time (unless you religiously make backups from this location to tape every day)
(3) It provides the ability to switch to the latest backup but not older backups (unless you make backups to tape and thus ensure that you have image backups of different days on different tapes).
It is too easy for a DBA / SA to not follow the three "unless" recommendations that I've added.
Hemant K Chitale -
7. Re: Is this script taking Image copies ?
BlueSkies Jan 22, 2013 2:43 AM (in response to Hemant K Chitale)Thanks everyone.
With Incrementally Updated Backups , If my DB's combined datafile size ie. SUM(DBA_DATA_FILES.BYTES) is 2TB , then I need a disk based backup location of 2TB in size for storing Image copies. Right ? -
8. Re: Is this script taking Image copies ?
Hemant K Chitale Jan 22, 2013 3:04 AM (in response to BlueSkies)1 person found this helpfulIf my DB's combined datafile size ie. SUM(DBA_DATA_FILES.BYTES) is 2TB , then I need a disk based backup location of 2TB in size for storing Image copies
Yes, precisely.
RMAN BackupSets may be smaller. Compressed Backupsets are even smaller. But Image Copy backups are exactly the same size as the datafiles.
Hemant K Chitale -
9. Re: Is this script taking Image copies ?
Mihael Jan 22, 2013 9:13 AM (in response to Hemant K Chitale)Why I am not comfortable ?
I think that these backups are convenient. We use two backups with different tag, one of them is current, and the second has lag of several days. Both are located on remote storage mounted by nfs. We can recover database using any of them and also use "switch" because switch command has "tag" option.
(1) It causes the backup to be local to the database server -- i.e. on the same SAN as the target database ! (unless you really connect two different SANs to the database server)
(2) It provides for only 1 backup of the database to be available at any time (unless you religiously make backups from this location to tape every day)
(3) It provides the ability to switch to the latest backup but not older backups (unless you make backups to tape and thus ensure that you have image backups of different days on different tapes).