【kingsql分享】Oracle 18c可插拔数据库舰队新玩法

1.设置CDB舰队队长

SQL> select instance_name from v$instance;

INSTANCE_NAME

----------------

ORCLCDB

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 ORCLPDB1                       READ WRITE NO

SQL> select file_name from cdb_data_files;

FILE_NAME

--------------------------------------------------------------------------------

/opt/oracle/oradata/ORCLCDB/system01.dbf

/opt/oracle/oradata/ORCLCDB/sysaux01.dbf

/opt/oracle/oradata/ORCLCDB/undotbs01.dbf

/opt/oracle/oradata/ORCLCDB/users01.dbf

/opt/oracle/oradata/ORCLCDB/ORCLPDB1/system01.dbf

/opt/oracle/oradata/ORCLCDB/ORCLPDB1/sysaux01.dbf

/opt/oracle/oradata/ORCLCDB/ORCLPDB1/undotbs01.dbf

/opt/oracle/oradata/ORCLCDB/ORCLPDB1/users01.dbf

SQL> ALTER DATABASE SET lead_cdb = TRUE;

Database altered.

SQL> GRANT sysoper,sysdba to system container=all;

Grant succeeded.

2.设置CDB舰队成员

SQL> select instance_name from v$instance;

INSTANCE_NAME

----------------

kingdb

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 PDB2                           READ WRITE NO

SQL> CREATE PUBLIC DATABASE LINK l_orclcdb CONNECT TO system IDENTIFIED BY oracle USING 'ORCLCDB';

Database link created.

SQL> ALTER DATABASE SET lead_cdb_uri='dblink:l_orclcdb';

3.从CDB舰队队长来查看数据库舰队

SQL> select instance_name from v$instance;

INSTANCE_NAME

----------------

ORCLCDB

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 ORCLPDB1                       READ WRITE NO

         5 PDB2                           MOUNTED

4.CDB舰队成员进行增加PDB操作

SQL> select instance_name from v$instance;

INSTANCE_NAME

----------------

kingdb

SQL> create pluggable database pdb_mem1 admin user kingsql identified by oracle

  2  file_name_convert =('/opt/oracle/oradata/KINGDB/pdbseed','/opt/oracle/oradata/KINGDB/pdb_mem1');

Pluggable database created.

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 PDB2                           READ WRITE NO

         4 PDB_MEM1                       MOUNTED

SQL> alter pluggable database pdb_mem1 open;

Pluggable database altered.

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 PDB2                           READ WRITE NO

         4 PDB_MEM1                       READ WRITE NO

5.查看CDB舰队队长信息

SQL> select instance_name from v$instance;

INSTANCE_NAME

----------------

ORCLCDB

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 ORCLPDB1                       READ WRITE NO

         5 PDB2                           MOUNTED

         6 PDB_MEM1                       MOUNTED

6.查看CDB舰队队长的数据文件信息

SQL> select file_name from cdb_data_files;

FILE_NAME

--------------------------------------------------------------------------------

/opt/oracle/oradata/ORCLCDB/system01.dbf

/opt/oracle/oradata/ORCLCDB/sysaux01.dbf

/opt/oracle/oradata/ORCLCDB/undotbs01.dbf

/opt/oracle/oradata/ORCLCDB/users01.dbf

/opt/oracle/oradata/ORCLCDB/ORCLPDB1/system01.dbf

/opt/oracle/oradata/ORCLCDB/ORCLPDB1/sysaux01.dbf

/opt/oracle/oradata/ORCLCDB/ORCLPDB1/undotbs01.dbf

/opt/oracle/oradata/ORCLCDB/ORCLPDB1/users01.dbf

8 rows selected.

可见，CDB舰队成员信息只是逻辑的注册过来

转载请注明出处

hongzhuohui@qq.com

本来好几年没有更新博客了，最近我的学生们都在勤劳的写博客，所以带动了我。。

--------------------------------------------------------------------------------------------------------------

我曾发现有写网站直接拷贝粘贴，连图片都能复制，请把作者也加上谢谢O(∩_∩)O

--------------------------------------------------------------------------------------------------------------

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28389881/viewspace-2222159/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28389881/viewspace-2222159/