Clone using DBCA

Clone the primary database ILTST19C to DB19C on remote server.

PRIMARY DATABASE – >
Hostname -> dbprod.dbaclass.comDBNAME – > ILTST19C
AUXILARY DB – > ( Means the to be cloned database ) .
Hostname -> dbtest.dbaclass.comDBNAME – > DB19C
Run the dbca command from the Auxillary 19C ORACLE_HOME
export ORACLE_HOME=/oracle/app/oracle/product/19.3.0/dbhome_1
cd $ORACLE_HOME/bin
SYNTAX:
./dbca -silent -createDuplicateDB -gdbName {CLONE_DB_NAME} -primaryDBConnectionString <hostname:port/service> -sid {CLONE_DB_SID} -databaseConfigType SINGLE -initParams db_unique_name={CLONE_DB_NAME} -sysPassword {PRIMARY_DB_SYS_PWD} -datafileDestination {CLONE_DATAFILE_LOC}
Example
./dbca -silent -createDuplicateDB -gdbName DB19C -primaryDBConnectionString dbprod.dbaclass.com:1522/ILTST19C -sid DB19C -databaseConfigType SINGLE -initParams db_unique_name=DB19C -sysPassword dbaclass234# -datafileDestination /data/datafile
Prepare for db operation22% completeListener config step44% completeAuxiliary instance creation67% completeRMAN duplicate89% completePost duplicate database operations100% complete Look at the log file "/oracle/app/oracle/cfgtoollogs/dbca/DB19C/DB19C.log" for further details.
Check the datafiles:
SQL> select file_name from dba_data_files;

Page updated

Google Sites

Report abuse