Clone a pluggable database for existing PDB, clone the PDB within the same CDB, Cloning Pluggable Databases - Oracle

Clone a pluggable database for existing PDB, clone the PDB within the same CDB, Cloning Pluggable Databases - Oracle 

A container database can contain multiple PDBs, so we can either create new PDB’s or clone existing PDBs. Here i am going to do pdb cloning within the cdb.

 •                     Connect and check the existing PDBs.


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


 •                     Connect to the container and clone the pluggable:


•                     Set the file dest location:

            ALTER SYSTEM SET DB_CREATE_FILE_DEST = '+DATA';

•                     Execute the script to clone:

            create pluggable database RFINUAT from FINUAT3;

•                     Now make the existing PDB ( FINUAT3) from read only to read write:

            SQL> alter session set CONTAINER=FINUAT3;

            SQL> shutdown immediate;

            Pluggable Database closed.

            SQL> startup

            Pluggable Database opened.

 •                     start the new cloned PDB( RFINUAT)

            SQL> alter session set container=RFINUAT;

            Session altered.

            SQL> startup

            Pluggable Database opened.

 Note: - The cloned Pluggable database is always in mounted stage

 •                     Check the container status:

 

•                     Where can I find Alert log in pluggable Database

A Single copy of Alert log is generated which contains warnings and alert information for all PDBs.

XML version of alert can be found in "Diag Alert" and text formatted Alert log can be found in "Diag Trace" of the container database.

•                      Where can I find trace files in pluggable Database

All traces generated from all PDBs are currently found in "Diag Trace" of the container database.

Note:-You can find both (alert and trace) details by selecting from v$diag_info;

 

Some more articles you might also be interested in :-

   Pluggable Database in Details

   Clone a Pluggable Database

   Drop a Pluggable Database

   


Comments

Post a Comment

Popular posts from this blog

Remove ACL and privileges, Drop ACL in oracle

Image
  Remove ACL and privileges, Drop ACL in oracle See the Network and ACL assignments as below -                                    o    Unassign ACL           begin              dbms_network_acl_admin.unassign_acl(              acl   => 'utl_mail_test.xml',              host => '172.16.20.18',                lower_port   => 25,              upper_port   => NULL              );              commit;          end; ...
Read more

ORA-02050: transaction rolled back, some remote DBs may be in-doubt

ORA-02050: transaction rolled back, some remote DBs may be in-doubt Indicates that a communication error occurred during the two-phase commit. The two phase-commit mechanism is used to ensure data integrity in a distributed transaction. Example of handling the In-Doubt Transactions - in this example we are taking two servers ACCT and FIN.   Got error ORA-02050: transaction rolled back, some remote DBs may be in-doubt at FIN Server Scenario- LOCAL_TRAN_ID and GLOBAL_TRAN_ID are same.   Execute below query in SYS user at FIN server. SQL> SELECT LOCAL_TRAN_ID , STATE FROM dba_2pc_pending ; LOCAL_TRAN_ID  GLOBAL_TRAN_ID         STATE -------------   --------------- ---------------- 3.12 .2 54         --------. 3.12 . 254    collecting   Here local id and Global id is same, so it is the global coordinator. State column is collecting means this ...
Read more

Distributed transaction, Oracle Distributed Transactions, distributed transaction in oracle

Distributed transaction, Oracle Distributed Transactions, distributed transaction in oracle A distributed transaction modifies data related to two or more databases, it contains DML statements than span many nodes. For a distributed transaction to be successful all or none of the database nodes involved in the transaction need to commit or rollback the whole transaction. Note the difference between a distributed and a remote transaction; a remote transaction contains one or more DML statements that are executed on the SAME remote node, consider the examples below:- Example of Distributed transaction: insert into table@remotesite; insert into mytable: --local table commit;   Example of Remote transaction: insert into table@remotesite; commit;   Database links are used to communicate between the databases performing distributed transactions. In a distributed environment, it is fundamental that the global name of a database is unique in the network so that eac...
Read more