CDB 实例的启动与关闭

SYS@cdb1> show con_name;
SYS@cdb1> shutdown immediate;

查看后台进程
[oracle@orcl19c ~]$ ps -ef | grep ora_ | grep -v grep

[oracle@orcl19c ~]$ export ORACLE_SID=cdb1
[oracle@orcl19c ~]$ sqlplus / as sysdba

启动数据库实例到 nomount 状态
SYS@cdb1> startup nomount;

查看实例状态
SYS@cdb1> select instance_name,status from v$instance;
查看 v$pdbs 动态性能视图，显示没有结果
SYS@cdb1> select name,con_id,open_mode from v$pdbs;

SYS@cdb1> alter database mount;
SYS@cdb1> select instance_name,status from v$instance;

查看 pdb 情况，显示 pdb 也处于 mounted 状态
SYS@cdb1> col name for a10
SYS@cdb1> select name,con_id,open_mode from v$pdbs;
SYS@cdb1> show pdbs

SYS@cdb1> alter database open;

SYS@cdb1> select name,status from v$instance;
SYS@cdb1> show pdbs

SYS@cdb1> show pdbs

SYS@cdb1> conn sys/oracle@pdb1 as sysdba
SYS@pdb1> show pdbs
open 打开 pdb1
SYS@pdb1> alter database open;
SYS@pdb1> show pdbs;

SQL>CONNECT sys@CDB1 AS SYSDBA
SQL> ALTER PLUGGGABLE DATABASE ALL OPEN;
SQL> select name,con_id,open_mode from v$pdbs;

SYS@pdb1> show pdbs;
SYS@pdb1> shutdown immediate;
SYS@pdb1> show pdbs

SYS@pdb1> conn / as sysdba
SYS@cdb1> show pdbs
在 cdb 中使用 alter pluggable database 语句 open 打开 pdb
SYS@cdb1> alter pluggable database pdb1 open;
SYS@cdb1> show pdbs

SYS@cdb1> alter pluggable database pdb1 close immediate;
SYS@cdb1> show pdbs

SYS@cdb1> alter pluggable database all open;
SYS@cdb1> show pdbs;

SYS@cdb1> show pdbs
SYS@cdb1> alter pluggable database pdb1 save state;