This content has been marked as final. Show 4 replies
Rudi wrote:Yes is certified.
We running Oracle 11gR2 EE.
We have storage backup procedures in place,which use Split Mirror technology, i.e BCV
We want to use RMAN to duplicate the source DB, using the BCV copy
Is this possible/feasible?
Check documentation (withepaper) with your vendor (BCV) about perform backup using BCV and RMAN.
See this example.
Is recommended read note below:
RMAN and Split Mirror Disk Backups [ID 302615.1]
Never done it, but since you can detach and mount the storage, you should be able to start the database and use it as a source for duplicate.
My concern would be conflicts with the tnsnames and listener that is needed for duplicate. If you can account for them you should be good.
On our SAN we use to do a swap copy. Then I would just change the DBID and I had a copy.
Thanks for the reply.
My intention is not to backup using RMAN from the BCV.Instead I want RMAN to use this BCV as the storage for our reporting DB
I will elaborate further my intended workflow.
Btw,the reporting DB will have a new name and all the SqlNet files will be in place.
Please let me know what you think.
On the target
In the existing production server (source) :
1.Put the DB in backup mode
2.Split the disks
4.Keep record of SCN
4.Register the new backups as datafile copy
On the target server (target)
1.Mount the report DB
2.perform incomplete recovery the report DB until the SCN
2 issues I'm not sure about :
a.How to I sync the report DB controlfile,so it will "see" the new backup?
b.Do I need a RMAN repository?
Edited by: Rudi on Jan 7, 2013 5:12 AM
Just to complete the picture :
The BCV will be mounted on the reporting server.