Oracle 19C Multitenant 常用命令

常用命令

SQL> show pdbs;--(显示当前库中的PDB， 如果在root$container中显示所有的PDB，如果在PDB 中只显示当前PDB)

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           READ WRITE NO
         5 PDB2                           MOUNTED
SQL> alter session set  container=pdb1;--改变当前容器

Session altered.

SQL> show pdbs;--显示当前PDB

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         3 PDB1                           READ WRITE NO
SQL> alter pluggable database pdb1  close immediate;--(关闭当前PDB, 因为当前的container为PDB1 不能关闭其他的PDB,这里忘记写了)

Pluggable database altered.

SQL> alter pluggable database pdb1 open;--打开当前PDB，（也可以用 我们之前的 startup, shutdown 来开启和关闭PDB）

Pluggable database altered.

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         3 PDB1                           READ WRITE NO
SQL> alter session set container=cdb$root;

Session altered.

SQL> show pdbs;--显示所有PDB

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           READ WRITE NO
         5 PDB2                           MOUNTED

SQL> alter pluggable database pdb2 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
         5 PDB2                           READ WRITE NO
SQL> alter pluggable database pdb2 save state;--保存PDB 状态，关闭整个CDB数据库后，再次启动PDB 的状态，比如在关闭数据库前 PDB2  的状态为READ WRITE，save state后关闭数据库，再次启动数据库 PDB2 还是READ WRITE 状态

Pluggable database altered.

SQL> show con_name;

CON_NAME
------------------------------
CDB$ROOT
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1543500832 bytes
Fixed Size                  9135136 bytes
Variable Size             939524096 bytes
Database Buffers          587202560 bytes
Redo Buffers                7639040 bytes
Database mounted.
Database opened.
SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           READ WRITE NO
         5 PDB2                           READ WRITE NO
SQL> alter pluggable database  pdb2 close immediate;

Pluggable database altered.

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           READ WRITE NO
         5 PDB2                           MOUNTED
SQL> alter pluggable database pdb2 save state;

Pluggable database altered.

SQL> show con_name;

CON_NAME
------------------------------
CDB$ROOT
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area 1543500832 bytes
Fixed Size                  9135136 bytes
Variable Size             939524096 bytes
Database Buffers          587202560 bytes
Redo Buffers                7639040 bytes
Database mounted.
Database opened.
SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           READ WRITE NO
         5 PDB2                           MOUNTED