Plug and unplug Pluggable database (PDB) in the same container database

Plug pdb5 and unplug pdb4 in the same container database (CDB)


SQL> show pdbs
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           READ WRITE NO
         4 PDB2                           READ WRITE NO
         5 PDB4                           READ WRITE NO
         6 PDB3                           READ WRITE NO

SQL> alter pluggable database pdb4 close immediate;
Pluggable database altered.

SQL> alter pluggable database pdb4 unplug into '/tmp/pdb4.xml';
Pluggable database altered.

SQL> drop pluggable database pdb4;
Pluggable database dropped.

SQL> show pdbs
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           READ WRITE NO
         4 PDB2                           READ WRITE NO
         6 PDB3                           READ WRITE NO
SQL> --- plug the PDB
SQL> create pluggable database pdb5 using '/tmp/pdb4.xml' file_name_convert=('/u01/app/oracle/oradata/prdcdb/pdb4/','/u01/app/oracle/oradata/prdcdb/pdb5/');
Pluggable database created.

SQL> show pdbs
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           READ WRITE NO
         4 PDB2                           READ WRITE NO
         5 PDB5                           MOUNTED
         6 PDB3                           READ WRITE NO

SQL> alter pluggable database pdb5 open;
Pluggable database altered.

SQL> show pdbs
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           READ WRITE NO
         4 PDB2                           READ WRITE NO
         5 PDB5                           READ WRITE NO
         6 PDB3                           READ WRITE NO

Comments

Post a Comment

Popular posts from this blog

Tuples in Python

 Tuples Basically Tuples in Python are very similar to Lists, but, Tuples are immutable which means that they can not be modified/changed. We generally use Tuples to make sure the values are not changed like, dates, Year, and days of the week or dates on a Calendar.  Creating a Tuple: >>> my_t1=(1,2,3) >>> my_t2=('one','two','three') >>> my_t1 (1, 2, 3) >>> my_t2 ('one', 'two', 'three') -- check the length of tupple: >>> len(my_t1) 3 >>> len(my_t2) 3 -- Tuples can have mixed objects as like Lists. >>> my_t3=(1,'two',3,'four') >>> my_t3 (1, 'two', 3, 'four') -- indexing with tuples  >>> my_t3=(1,'two',3,'four') >>> my_t3[2] 3 Immutable Tuples We can not modify the value. Here is the example: >>> my_t3=(1,'two',3,'four') >>> my_t3[2]=4 Traceback (most recent call last):  ...
Read more

Auditing in Oracle database

Unified Auditing: Oracle Database 12c Release 1 introduces a new auditing feature called Unified Auditing (12.1). Oracle Unified Auditing modifies the database's fundamental auditing capabilities. In earlier versions of Oracle, each component has its own audit trail. With unified auditing, all auditing is compiled into a single repository and view. Due to the fact that all audit data is now in a single location and a single format, there is a double simplification as a result. This data is made available in a consistent format in the UNIFIED AUDIT TRAIL data dictionary view, which is made possible by the unified audit trail, which is stored in a read-only table in the AUDSYS schema in the SYSAUX tablespace.  DBAs can build audit rules and then assign them to various users using Oracle 12c Unified Auditing, which has the same advantages as giving users varying system capabilities based on their responsibilities. The unified_audit_trail database will contain all of the audit records....
Read more

Boolean in Python

What is a Boolean? Ture or False (Make sure to use initial letter as a capital) For Example, >>> True True >>> true Traceback (most recent call last):   File "<stdin>", line 1, in <module> NameError: name 'true' is not defined Examples: >>> x= True >>> type(x) <class 'bool'> >>> 9 > 8 True >>> 8> 9 False  How to define/assign a variable without value? >>> x Traceback (most recent call last):   File "<stdin>", line 1, in <module> NameError: name 'x' is not defined Here is the way, you could define the variable without defining/assigning the value >>> x=None >>> x
Read more