troubleshooting Question

create new oracle instance by copying medatat from other oracle instance

Avatar of marrowyung
marrowyung asked on
Oracle Database
7 Comments1 Solution38 ViewsLast Modified:

right now we want to create a new Oracle instance A by copying the metadata from other Oracle instance B

please let me know if the following steps are ok:

# 1)  Create a 300G new FS /ora/u40 for instance A

# 2)  export HUETL02 with metadata
export ORACLE_SID=instance B
expdp \"/ as sysdba\" full=y directory=<instance B>  dumpfile="<instance B>_20200509.dmp" content=metadata_only logfile=exp_<instance B>.log
# 3) Create new instance instance A
3.1 create pfile
3.2 create database
3.3 execute script
SQL> @?/rdbms/admin/catalog.sql    
SQL> @?/rdbms/admin/catproc.sql    
SQL> @?/rdbms/admin/utlrp.sql
SQL> @?/sqlplus/admin/pupbld.sql(run as system)
# 4) Create user tablespace for instance A
# 5) import instance A

export ORACLE_SID=instance A
impdp \"/ as sysdba\" full=y directory=<instance A> dumpfile="HUETL02_20200509.dmp" full=y logfile=imp_<instance A >.log

is the steps ok?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 7 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros