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?
marrowyungSenior Database Architecture (Data)

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
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