Thursday, January 7, 2016

unplug and plug the pluggable database.


22:29:43 CDB$ROOT@ORCL> select * from cdb_pdbs;
    PDB_ID PDB_NAME            DBID    CON_UID GUID                             STATUS        CREATION_SCN     CON_ID
---------- ------------- ---------- ---------- -------------------------------- ------------- ------------ ----------
         3 PDB1          3345156736 3345156736 F0832BAF14721281E045000000000001 NORMAL             3238038          1
         2 PDB$SEED      4080030308 4080030308 F081641BB43F0F7DE045000000000001 NORMAL             1720754          1
         4 MICHAELPDB1   4078413767 4078413767 28B29D2DABB27F6FE055000000000001 NORMAL             3239858          1
Elapsed: 00:00:00.01
22:29:44 CDB$ROOT@ORCL> select * from v$containers;
    CON_ID       DBID    CON_UID GUID                             NAME         OPEN_MODE  RES OPEN_TIME                   CREATE_SCN TOTAL_SIZE
---------- ---------- ---------- -------------------------------- ------------ ---------- --- --------------------------- ---------- ----------
         1 1365223133          1 DD7C48AA5A4504A2E04325AAE80A403C CDB$ROOT     READ WRITE NO  06-JAN-16 09.44.12.979 PM            0  975175680
         2 4080030308 4080030308 F081641BB43F0F7DE045000000000001 PDB$SEED     READ ONLY  NO  06-JAN-16 09.44.12.980 PM      1720754  283115520
         3 3345156736 3345156736 F0832BAF14721281E045000000000001 PDB1         READ WRITE NO  06-JAN-16 10.19.36.099 PM      3238038  291045376
         4 4078413767 4078413767 28B29D2DABB27F6FE055000000000001 MICHAELPDB1  READ WRITE NO  06-JAN-16 10.28.58.525 PM      3239858  283115520
Elapsed: 00:00:00.00
22:29:47 CDB$ROOT@ORCL> alter pluggable database michaelpdb1 close;
Pluggable database altered.
Elapsed: 00:00:00.30
22:29:58 CDB$ROOT@ORCL> select * from cdb_pdbs;
    PDB_ID PDB_NAME            DBID    CON_UID GUID                             STATUS        CREATION_SCN     CON_ID
---------- ------------- ---------- ---------- -------------------------------- ------------- ------------ ----------
         3 PDB1          3345156736 3345156736 F0832BAF14721281E045000000000001 NORMAL             3238038          1
         2 PDB$SEED      4080030308 4080030308 F081641BB43F0F7DE045000000000001 NORMAL             1720754          1
         4 MICHAELPDB1   4078413767 4078413767 28B29D2DABB27F6FE055000000000001 NORMAL             3239858          1
Elapsed: 00:00:00.01
22:30:06 CDB$ROOT@ORCL> select * from v$containers;
    CON_ID       DBID    CON_UID GUID                             NAME         OPEN_MODE  RES OPEN_TIME                   CREATE_SCN TOTAL_SIZE
---------- ---------- ---------- -------------------------------- ------------ ---------- --- --------------------------- ---------- ----------
         1 1365223133          1 DD7C48AA5A4504A2E04325AAE80A403C CDB$ROOT     READ WRITE NO  06-JAN-16 09.44.12.979 PM            0  975175680
         2 4080030308 4080030308 F081641BB43F0F7DE045000000000001 PDB$SEED     READ ONLY  NO  06-JAN-16 09.44.12.980 PM      1720754  283115520
         3 3345156736 3345156736 F0832BAF14721281E045000000000001 PDB1         READ WRITE NO  06-JAN-16 10.19.36.099 PM      3238038  291045376
         4 4078413767 4078413767 28B29D2DABB27F6FE055000000000001 MICHAELPDB1  MOUNTED        06-JAN-16 10.29.58.171 PM      3239858          0
Elapsed: 00:00:00.01
22:30:09 CDB$ROOT@ORCL>
22:30:13 CDB$ROOT@ORCL> alter pluggable database michaelpdb1 unplug into '/u01/oracle/harvey/michaelpdb1.xml';
Pluggable database altered.
Elapsed: 00:00:01.35
22:31:41 CDB$ROOT@ORCL> select * from cdb_pdbs;                    
    PDB_ID PDB_NAME            DBID    CON_UID GUID                             STATUS        CREATION_SCN     CON_ID
---------- ------------- ---------- ---------- -------------------------------- ------------- ------------ ----------
         3 PDB1          3345156736 3345156736 F0832BAF14721281E045000000000001 NORMAL             3238038          1
         2 PDB$SEED      4080030308 4080030308 F081641BB43F0F7DE045000000000001 NORMAL             1720754          1
         4 MICHAELPDB1   4078413767 4078413767 28B29D2DABB27F6FE055000000000001 UNPLUGGED          3239858          1
Elapsed: 00:00:00.04
22:32:10 CDB$ROOT@ORCL> select * from v$containers;
    CON_ID       DBID    CON_UID GUID                             NAME         OPEN_MODE  RES OPEN_TIME                   CREATE_SCN TOTAL_SIZE
---------- ---------- ---------- -------------------------------- ------------ ---------- --- --------------------------- ---------- ----------
         1 1365223133          1 DD7C48AA5A4504A2E04325AAE80A403C CDB$ROOT     READ WRITE NO  06-JAN-16 09.44.12.979 PM            0  975175680
         2 4080030308 4080030308 F081641BB43F0F7DE045000000000001 PDB$SEED     READ ONLY  NO  06-JAN-16 09.44.12.980 PM      1720754  283115520
         3 3345156736 3345156736 F0832BAF14721281E045000000000001 PDB1         READ WRITE NO  06-JAN-16 10.19.36.099 PM      3238038  291045376
         4 4078413767 4078413767 28B29D2DABB27F6FE055000000000001 MICHAELPDB1  MOUNTED        06-JAN-16 10.31.41.694 PM      3239858          0
Elapsed: 00:00:00.02
22:32:21 CDB$ROOT@ORCL> drop pluggable database michaelpdb1;
Pluggable database dropped.
Elapsed: 00:00:00.73
22:32:34 CDB$ROOT@ORCL> select * from cdb_pdbs;      
    PDB_ID PDB_NAME            DBID    CON_UID GUID                             STATUS        CREATION_SCN     CON_ID
---------- ------------- ---------- ---------- -------------------------------- ------------- ------------ ----------
         3 PDB1          3345156736 3345156736 F0832BAF14721281E045000000000001 NORMAL             3238038          1
         2 PDB$SEED      4080030308 4080030308 F081641BB43F0F7DE045000000000001 NORMAL             1720754          1
Elapsed: 00:00:00.01
22:32:40 CDB$ROOT@ORCL> select * from v$containers;
    CON_ID       DBID    CON_UID GUID                             NAME         OPEN_MODE  RES OPEN_TIME                   CREATE_SCN TOTAL_SIZE
---------- ---------- ---------- -------------------------------- ------------ ---------- --- --------------------------- ---------- ----------
         1 1365223133          1 DD7C48AA5A4504A2E04325AAE80A403C CDB$ROOT     READ WRITE NO  06-JAN-16 09.44.12.979 PM            0  975175680
         2 4080030308 4080030308 F081641BB43F0F7DE045000000000001 PDB$SEED     READ ONLY  NO  06-JAN-16 09.44.12.980 PM      1720754  283115520
         3 3345156736 3345156736 F0832BAF14721281E045000000000001 PDB1         READ WRITE NO  06-JAN-16 10.19.36.099 PM      3238038  291045376
Elapsed: 00:00:00.01
22:32:42 CDB$ROOT@ORCL> create pluggable database pdb2 using '/u01/oracle/harvey/michaelpdb1.xml' nocopy;
Pluggable database created.
Elapsed: 00:00:02.15
22:33:13 CDB$ROOT@ORCL> select * from cdb_pdbs;
    PDB_ID PDB_NAME            DBID    CON_UID GUID                             STATUS        CREATION_SCN     CON_ID
---------- ------------- ---------- ---------- -------------------------------- ------------- ------------ ----------
         3 PDB1          3345156736 3345156736 F0832BAF14721281E045000000000001 NORMAL             3238038          1
         2 PDB$SEED      4080030308 4080030308 F081641BB43F0F7DE045000000000001 NORMAL             1720754          1
         4 PDB2          4078413767 4078413767 28B29D2DABB27F6FE055000000000001 NEW                3241128          1
Elapsed: 00:00:00.01
22:33:15 CDB$ROOT@ORCL> select * from v$containers;
    CON_ID       DBID    CON_UID GUID                             NAME         OPEN_MODE  RES OPEN_TIME                   CREATE_SCN TOTAL_SIZE
---------- ---------- ---------- -------------------------------- ------------ ---------- --- --------------------------- ---------- ----------
         1 1365223133          1 DD7C48AA5A4504A2E04325AAE80A403C CDB$ROOT     READ WRITE NO  06-JAN-16 09.44.12.979 PM            0  975175680
         2 4080030308 4080030308 F081641BB43F0F7DE045000000000001 PDB$SEED     READ ONLY  NO  06-JAN-16 09.44.12.980 PM      1720754  283115520
         3 3345156736 3345156736 F0832BAF14721281E045000000000001 PDB1         READ WRITE NO  06-JAN-16 10.19.36.099 PM      3238038  291045376
         4 4078413767 4078413767 28B29D2DABB27F6FE055000000000001 PDB2         MOUNTED        06-JAN-16 10.33.13.169 PM      3241128          0
Elapsed: 00:00:00.01
22:33:18 CDB$ROOT@ORCL> alter pluggable database pdb2 open read write;
Pluggable database altered.
Elapsed: 00:00:05.95
22:33:35 CDB$ROOT@ORCL> select * from cdb_pdbs;
    PDB_ID PDB_NAME            DBID    CON_UID GUID                             STATUS        CREATION_SCN     CON_ID
---------- ------------- ---------- ---------- -------------------------------- ------------- ------------ ----------
         3 PDB1          3345156736 3345156736 F0832BAF14721281E045000000000001 NORMAL             3238038          1
         2 PDB$SEED      4080030308 4080030308 F081641BB43F0F7DE045000000000001 NORMAL             1720754          1
         4 PDB2          4078413767 4078413767 28B29D2DABB27F6FE055000000000001 NORMAL             3241128          1
Elapsed: 00:00:00.09
22:33:36 CDB$ROOT@ORCL> select * from v$containers;
    CON_ID       DBID    CON_UID GUID                             NAME         OPEN_MODE  RES OPEN_TIME                   CREATE_SCN TOTAL_SIZE
---------- ---------- ---------- -------------------------------- ------------ ---------- --- --------------------------- ---------- ----------
         1 1365223133          1 DD7C48AA5A4504A2E04325AAE80A403C CDB$ROOT     READ WRITE NO  06-JAN-16 09.44.12.979 PM            0  975175680
         2 4080030308 4080030308 F081641BB43F0F7DE045000000000001 PDB$SEED     READ ONLY  NO  06-JAN-16 09.44.12.980 PM      1720754  283115520
         3 3345156736 3345156736 F0832BAF14721281E045000000000001 PDB1         READ WRITE NO  06-JAN-16 10.19.36.099 PM      3238038  291045376
         4 4078413767 4078413767 28B29D2DABB27F6FE055000000000001 PDB2         READ WRITE NO  06-JAN-16 10.33.29.532 PM      3241128  283115520
Elapsed: 00:00:00.04
22:33:38 CDB$ROOT@ORCL> 

No comments: