==========================================================================================================

                              How To Clone A Pluggable Database Of Existing PDB 

==========================================================================================================

Here, we will Clone a Pluggable database from existing PDBS  "FINUAT1", residing in the same container on same database server .

Step 1 

[oracle@nvihfludcont01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Thu Dec 30 16:17:10 2021

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> show pdbs

  CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         3 FINUAT1                                     READ WRITE NO

SQL>

Step 2 

First We need to start the PDB in read only , which need to be cloned.

SQL>

SQL> shutdown immediate ;

Pluggable Database closed.

SQL> select name,open_mode from v$pdbs;

NAME                                     OPEN_MODE

---------------------------------------- ----------

FINUAT1                                  MOUNTED

SQL> startup open read only ;

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 FINUAT1                        READ ONLY  NO

SQL>

SQL>

Step 3   Than we need connect to the CDB

SQL> show con_name

CON_NAME

------------------------------

CDB$ROOT

Step 4  Please set the desire datafile location for new PDB

SQL> ALTER SYSTEM SET DB_CREATE_FILE_DEST = '+DATA';

System altered.

SQL> show parameter DB_CREATE_FILE_DEST

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_create_file_dest                  string      +DATA

SQL>

SQL>

Step 5 

SQL> set timing on ;

SQL> set time on

17:42:47 SQL> create pluggable database FINUAT3 from FINUAT1 ;

Pluggable database created.

Elapsed: 00:40:14.69

Step 6   After the PDB Cloned We need to validate 

SQL> show pdbs

   CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 FINUAT1                        READ ONLY  NO

         4 FINUAT3                        MOUNTED

SQL> alter database open ;

Database altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         4 FINUAT3                        READ WRITE NO

SQL>

Thank you to All ....

Thank you for giving your valuable time to read the above information.