sdruss
asked on
Clone Oracle 12c Database
Need a step-by-step database clone/duplicate procedure. My platform is Solaris 11 OS, and Oracle 12c single-instance database. Oracle documentation I have found has more options than we need. Our scenario is to move our current development database to a different server with more resources. This new server is a physically different machine, however have access on the same network to both the old and new servers. Suspect we want to use the Recovery Manager (RMAN) duplicate option. Please provide detailed step-by-step and/or provide link to really good instruction. Appreciate the help. Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If the OS is the same and the directory structure is the same, then it really should be as simple as moving all the files and staring up the database. You really don't need RMAN. It can make things easier, but if everything is equal on both sides, I think doing it without RMAN can be faster.
ASKER
HuaMinChen - we don't have a RAM catalog, so I'm not sure how your solution would work. Need to duplicate my database currently running on an old resource depleted server, to a different machine/server with more resources. Thanks!
johnsone - if we just move all the files over from the current server to the new server, then both database will have the same database ID (DBID), don't think we want that. Note: we still want to use the old database server for some other database task. Thanks!
johnsone - if we just move all the files over from the current server to the new server, then both database will have the same database ID (DBID), don't think we want that. Note: we still want to use the old database server for some other database task. Thanks!
Database id is not an issue. You can change it with the DBNEWID utility -> http://docs.oracle.com/database/122/SUTIL/oracle-dbnewid-utility.htm#SUTIL014
Simple command line, only takes a couple of seconds.
Simple command line, only takes a couple of seconds.
i gave a somewhat lengthy comment on how to copy databases online here:
https://www.experts-exchange.com/questions/28971509/Copy-Oracle-database-from-11g-11-2-0-1-0-to-12c-12-1-0-2-0.html
in the end use johnsone's comment to give it a new id and name
https://www.experts-exchange.com/questions/28971509/Copy-Oracle-database-from-11g-11-2-0-1-0-to-12c-12-1-0-2-0.html
in the end use johnsone's comment to give it a new id and name