DBCA SILENT MODE NEW FEATURES IN DATABASE 19C DOC ID 2477805.1

DBCA SILENT MODE NEW FEATURES IN DATABASE 19C DOC ID 2477805.1

APPLIES TO:

Oracle Database Configuration Assistant

Information in this document applies to any platform.


PURPOSE

Provide details of the new features in 19c in dbca silent mode.

SCOPE

All database administrators using DBCA and working in multitenant environment 

DETAILS

Following are the new features in DBCA in the silent mode in 19C:

1) Create a PDB by cloning a remote PDB     You can use the "createFromRemotePDB"  parameter of the DBCA command createPluggableDatabase  to create a PDB by cloning a remote PDB.

  DBCA command line arguments for this new feature:

./dbca -createPluggableDatabase -createFromRemotePDB -remotePDBName -remoteDBConnString -sysDBAUserName -sysDBAPassword -dbLinkUsername -dbLinkUserPassword -sourceDB -pdbName

 

2) Relocate a PDB to another CDB,  You can use the DBCA command "relocatePDB" to relocate a PDB to another CDB.

  DBCA command line arguments for this new feature:

./dbca -silent  -relocatePDB -remotePDBName -remoteDBConnString -sysDBAUserName -sysDBAPassword -dbLinkUsername -dbLinkUserPassword -sourceDB -pdbName

3) Create a duplicate of a Non-CDB or an Oracle RAC database .

DBCA silent mode command  "createDuplicateDB"  will create a duplicate of a Non-CDB or an Oracle RAC database.

The database to be duplicated should be in archivelog mode.If the database to be duplicated is in a remote server, then there must be connectivity from the system where DBCA is running to the remote server.

The createDuplicateDB command can be used to duplicate the following types of databases:

Duplicate an Oracle RAC database as a non-multitenant container database (non-CDB)

Duplicate an Oracle RAC database as a pluggable database (PDB)

Duplicate an Oracle RAC database as an Oracle RAC database

Duplicate an Oracle RAC database as an Oracle RAC standby database

Duplicate a non-CDB as a non-CDB

Duplicate a non-CDB as a non-CDB standby database

Duplicate a non-CDB as an Oracle RAC database                    

                    

                    

Example for Single instance to Single Instance is as below:

 

./dbca -silent -createDuplicateDB -gdbName test -primaryDBConnectionString :1521/orcl.us.oracle.com -sid test -databaseConfigType SINGLE -initParams db_unique_name=test -sysPassword XXXXX

>

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 "/refresh/64bit/app/oracle/cfgtoollogs/dbca/test/test4.log" for further details.

Check below documentation for syntax and details : 

 Oracle® Database Database Administrator’s Guide 19c

 Creating and Configuring an Oracle Database                                                        

 https://docs-stage.oracle.com/en/database/oracle/oracle-database/19/administration.html