Link to home
Start Free TrialLog in
Avatar of sdruss
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
Avatar of Peter Chan
Peter Chan
Flag of Hong Kong image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of johnsone
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.
Avatar of sdruss
sdruss

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!
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.
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