วันเสาร์ที่ 12 มกราคม พ.ศ. 2556

How do I startup PDB & CDB ?


How do I start up a Pluggable database ?

When connect to current PDB:
SQL> alter pluggable database open;

When connect to root:
SQL> alter pluggable database pdb6 open;

How do I shutdown / close a Pluggable database ?

When connect to current PDB:
SQL> alter pluggable database close;

When connect to root:
SQL> alter pluggable database pdb6 close;


How do I shut down / Startup the Container Database ?

Use startup / Shutdown command similar to startup / shutdown of Non CDB.
When the container database is shutdown  , no PDB is accessible.
In a CDB, the root and all of the PDBs share a single instance, or, when using Oracle RAC, multiple concurrent database instances. You start up and shut down an entire CDB, not individual PDBs. However, when the CDB is open, you can change the open mode of an individual PDB by using the ALTER PLUGGABLE DATABASE statement.

Enjoy 12c, Official is comming soon !!, very exciting !

ไม่มีความคิดเห็น:

แสดงความคิดเห็น