This content has been marked as final. Show 8 replies
At a high level, you will need to clone the Oracle binaries, then clone the database.1 person found this helpful
How To Clone An Existing RDBMS Installation Using OUI [ID 300062.1]
How to Manually Backup - Restore or Clone a Database to Another Node [ID 562556.1]
Clone a Database With RMAN Without Connecting To Target Database [ID 732624.1]
Clone/Refresh Non-prod database from production [ID 1338233.1]
Besides the excellent docs shared by Srini, you can also use EM for the same task,
Just my 2 cents
Thank you so much both!
I'll review the documents you have provided reference for and will get back.
Thank you so much for sharing the valuable URLs.
I am reading through "Cloning An Existing Oracle10g Release 2 (10.2.0.x) RDBMS Installation Using OUI [ID 559304.1]" and I have few questions.
<li> This MOS says:
If that is the case, how should I clone ASM-Home?
NOTE: This note should only be used for cloning single-instance (non-RAC) homes. It should not be used for cloning RAC, CRS or ASM homes.
One of the environments that I have to migrate to a new server has ASM installed as well. And couple of oracle databases (10.2.0.5) on that server are using ASM for storage.
<li>If were to do a fresh installation of 10gR2 RDBMS and ASM homes (on Redhat Linux 64-bit), I guess I need to contact Oracle Support (open an SR) to access the software, right?
<li>How to check from existing installation which patches I need to download and apply to this fresh installation in order to make it same as the existing installation? "opatch lsinventory" gives me a long list of number/fixes - I don't know which patch(es) to download.
Edited by: user130038 on May 22, 2013 3:48 AM
Edited by: user130038 on May 22, 2013 3:55 AM
http://dba-expert.blogspot.ae/2013/04/clone-duplicate-database-with-rman.html1 person found this helpful
Thanks but my database is on ASM.
Yes, you need to install ASM on the new server. If you don't have the media / downloaded installers used for the install on the first server, you can log an SR with Oracle Support for a fresh download / media CD.
Hemant K Chitale
Thank you so much Hemant!
I have opened an SR with Oracle Support for downloads.