DBA Hub

📋Steps in this guide1/2

Clone a database using dbca command in oracle 19c -New feature - DBACLASS DBACLASS

Oracle 19c new feature, to duplicate or clone database using dbca command with simple createduplicate command. First install oracle 19c oracle home and then

oracle clusteringintermediate
by OracleDba
13 views
1

2. Create file structure where the datafiles will be created.

mkdir -p /data/datafile
2

3. Run the dbca command from the NEW 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} 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} NOTE – Here sys password is the sys password of primary database. And cloning completed. 🙂 It took 5 minutes to clone a 15GB database. Check the datafiles: It created the listener also . And we have successfully cloned a database with just a simple command. In the next article i will explain how to clone a RAC database using DBCA.

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
./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

$ ./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 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 "/oracle/app/oracle/cfgtoollogs/dbca/DB19C/DB19C.log" for further details.

SQL> select file_name from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
/data/datafile/DB19C/system01.dbf
/data/datafile/DB19C/sysaux01.dbf
/data/datafile/DB19C/undotbs01.dbf
/data/datafile/DB19C/users01.dbf
/data/datafile/DB19C/ctlgsm_01.dbf
/data/datafile/DB19C/ctlgsmidx_01.dbf
/data/datafile/DB19C/pcgsm_01.dbf
/data/datafile/DB19C/pcgsmidx_01.dbf
/data/datafile/DB19C/cat_01.dbf
/data/datafile/DB19C/catidx_01.dbf
/data/datafile/DB19C/ctldata_01.dbf

FILE_NAME
--------------------------------------------------------------------------------
/data/datafile/DB19C/ctldataidx_01.dbf
/data/datafile/DB19C/pcdata_01.dbf
/data/datafile/DB19C/pcdataidx_01.dbf
/data/datafile/DB19C/inventorytps01.dbf
/data/datafile/DB19C/catdata01.dbf
/data/datafile/DB19C/catdataidx01.dbf

oracle@:...le/product/19.3.0/dbhome_1/dbs$ ps -ef | grep tns
  oracle 19577 10879   0 16:40:27 pts/1       0:00 grep tns
  oracle 15376     1   0 16:13:00 ?           0:01 /oracle/app/oracle/product/19.3.0/dbhome_1/bin/tnslsnr LISTENER -inherit

Comments (0)

Please to add comments

No comments yet. Be the first to comment!