I have weekly full and daily archived RMAN backup directory to tape. I want to do clone on another server. I have all information HANDLE , TAG etc. What is the best way to restore to another server and clone database. Do I need to restore tape contents to disk and clone?
1)Using DUPLICATE TARGET DATABASE command
On clonedb do following:
rman target <targetconnectiondetails> catalog <catalogdbdetails> auxiliary /
allocate channel ch1 <copy the channel allocation command from source database >
set until database to_time('till what time you need data')
duplicate target database to 'clonedbname'
2)From 11g you can use ACTIVE DATABASE DUPLICATE. which does not rely on backups
You just need to install the tape software on the clone server and have the same configuration as the original server so the software can find the files that relate to the original database.the rman command then just need to correctly reference the tape config file (tsm.opt) for example.
This works fine for duplication since 9i