-- One more question on the above script
recover copy of database with tag daily1 until time 'sysdate - 1'; backup incremental level 1 for recover of copy with tag daily1 database; backup as compressed backupset archivelog all not backed up; allocate channel for maintenance type disk; delete noprompt obsolete device type disk; release channel;
RMAN>sql ‘alter database datafile 7 offline’; RMAN>switch datafile 7 to copy; RMAN>recover datafile 7; RMAN>sql ‘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.Can you, please, explain what will the problem? What is the difference in restoring and switching usual image copies and updatable ?
If you want to use incrementally updated image copy, the image copy is located in /u02/imagecopyThank 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
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 copiesYes, precisely.
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).