Hi all,
We are about to implement TDP for Oracle on one of our databases, and I'm now trying to plan the best configuration for this. One question that came up was how we efficiently generate a backupset to a tape volume to be stored offsite. My understanding is that TDPO backs up the data to the named file space in tdpo.opt, and that when generating a backupset the whole active file space will then be copied to the destination volume/s. But as all files are unique, all RMAN backups that have not been expired still exist as active. My idea was once a month to create a backupset of a cold backup, and store it offsite, but now I would end up with all RMAN files on that volume. To my knowledge there is no way of limiting which files that is copied to the backupset within a file space. One idea that came to mind was to use two tdpo.opt files with different file spaces. This way I could once a month run a cold backup that goes to an alternative file space, and then I generate a backupset from this. I would then have a RMAN script that expire the old backups and hence I would only have the files that I really want to take offsite. So here is when I turn to you here, because I wonder if this can be implemented as I described, or is there another better way? Best regards, Andreas Almroth Senior System Analyst Technology Group - O&M MTN Cameroon
