This content has been marked as final. Show 5 replies
Step 1: Figure out what database version you have.
Step 2: Figure out what operating system and version you have.
Step 3: Read the docs.
Works every time.
DB version =126.96.36.199
OS= RHEL 5.5
docs are at http://tahiti.oracle.com: enjoy.
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