Avatar of marrowyung

asked on 

create new oracle instance by copying medatat from other oracle instance


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?
Oracle Database

Avatar of undefined
Last Comment

8/22/2022 - Mon