duplicate Database Using Dbca Command In Oracle 19c

Duplicate Database Using Dbca Command In Oracle 19c 


syntax 
./dbca -silent -createDuplicateDB -gdbName {CLONE_DB_NAME} -primaryDBConnectionString  -sid  {CLONE_DB_SID} -databaseConfigType SINGLE -initParams db_unique_name={CLONE_DB_NAME}  -sysPassword {PRIMARY_DB_SYS_PWD} -datafileDestination {CLONE_DATAFILE_LOC}



ww                                                                           hostname=oralal                                                                                 {PRIMARY_DB_SYS_PWD}
./dbca -silent -createDuplicateDB -gdbName ODB19C -primaryDBConnectionString oralal:1521/test -sid ODB19C -databaseConfigType SINGLE -initParams db_unique_name=ODB19C -sysPassword 'sys' -datafileDestination /u02/app/oracle/DB19C


Prepare for db operation
22% complete
Listener config step
44% complete
Auxiliary instance creation

67% complete
RMAN duplicate

89% complete
Post duplicate database operations

100% complete

Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/ODB19C/ODB19C.log" for further details.


 cat /u01/app/oracle/cfgtoollogs/dbca/ODB19C/ODB19C.log|more
[ 2023-10-10 11:49:26.253 EDT ] Prepare for db operation
DBCA_PROGRESS : 22%
[ 2023-10-10 11:49:26.389 EDT ] Listener config step
DBCA_PROGRESS : 44%
[ 2023-10-10 11:49:26.556 EDT ] Auxiliary instance creation
DBCA_PROGRESS : 67%
[ 2023-10-10 11:49:46.987 EDT ] RMAN duplicate
DBCA_PROGRESS : 89%
[ 2023-10-10 11:52:27.750 EDT ] Post duplicate database operations
DBCA_PROGRESS : 100%
[ 2023-10-10 11:55:10.425 EDT ]



====



test:/u01/app/oracle/product/19.0.0/dbhome_1:Y  >>>>>>>  from 
ODB19C:/u01/app/oracle/product/19.0.0/dbhome_1:N  <<<<<< to 

 ps -ef|grep -i smon
oracle   3843427       1  0 11:35 ?        00:00:00 ora_smon_test
oracle   3850518       1  0 11:55 ?        00:00:00 ora_smon_ODB19C  <<<< database created