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>
Thursday, January 7, 2016
unplug and plug the pluggable database.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment