ITPub博客

首页 > 数据库 > Oracle > 创建、克隆pdb---oracle 12c 学习(1)

创建、克隆pdb---oracle 12c 学习(1)

原创 Oracle 作者:lsq_008 时间:2014-12-09 12:03:15 0 删除 编辑
SQL> select * from v$version;

BANNER                                                                               CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production              0
PL/SQL Release 12.1.0.2.0 - Production                                                    0
CORE    12.1.0.2.0      Production                                                                0
TNS for Linux: Version 12.1.0.2.0 - Production                                            0
NLSRTL Version 12.1.0.2.0 - Production                                                    0

SQL> select sys_context('userenv','con_name') from dual;

SYS_CONTEXT('USERENV','CON_NAME')
------------------------------------------------------------------------------------------------------------------------------------
CDB$ROOT

SQL> select con_id,dbid,con_uid,guid,name,open_mode,create_scn,total_size,block_size from v$pdbs;

    CON_ID       DBID    CON_UID GUID                             NAME         OPEN_MODE  CREATE_SCN TOTAL_SIZE BLOCK_SIZE
---------- ---------- ---------- -------------------------------- ------------ ---------- ---------- ---------- ----------
         2 4264868981 4264868981 0951B9CFB39C2060E0530100007F6961 PDB$SEED     READ ONLY     1594434  870318080       8192
         3 3977202490 3977202490 09521ABB982E7F0BE0530100007FD46A XJNY         READ WRITE    1753354  917504000       8192

--创建一个新PDB  
SQL> CREATE PLUGGABLE DATABASE wapdb ADMIN USER wapadmin IDENTIFIED BY  wapadmin ;

Pluggable database created.

SQL> select con_id,dbid,con_uid,guid,name,open_mode,create_scn,total_size,block_size from v$pdbs;

    CON_ID       DBID    CON_UID GUID                             NAME       OPEN_MODE  CREATE_SCN TOTAL_SIZE BLOCK_SIZE
---------- ---------- ---------- -------------------------------- ---------- ---------- ---------- ---------- ----------
         2 4264868981 4264868981 0951B9CFB39C2060E0530100007F6961 PDB$SEED   READ ONLY     1594434  870318080       8192
         3 3977202490 3977202490 09521ABB982E7F0BE0530100007FD46A XJNY       READ WRITE    1753354  917504000       8192
         4 4211777660 4211777660 0986C60CA76145FDE0530100007F304E WAPDB      MOUNTED       1896905          0       8192

--克隆一个新pdb
SQL> create pluggable database mbs from wapdb;
create pluggable database mbs from wapdb
*
ERROR at line 1:
ORA-65139: Mismatch between XML metadata file and data file
/home/db/oracle/oradata/SMS/0986C60CA76145FDE0530100007F304E/datafile/o1_mf_system_b856b39h_.dbf for value of fcpsb (1897165 in the
plug XML file, 1904147 in the data file)


尝试将wapdb以read only模式打开
SQL> alter session set container=wapdb;

Session altered.

SQL> alter database open read only;

Database altered.

SQL> alter session set container=cdb$root;

Session altered.

SQL> select sys_context('userenv','con_name') from dual;

SYS_CONTEXT('USERENV','CON_NAME')
------------------------------------------------------------------------------------------------------------------------------------
CDB$ROOT

SQL> create pluggable database mbs from wapdb;

Pluggable database created.

SQL> alter pluggable database mbs open;

Warning: PDB altered with errors.

SQL> select con_id,dbid,con_uid,guid,name,open_mode,create_scn,total_size,block_size from v$pdbs;

    CON_ID       DBID    CON_UID GUID                             NAME       OPEN_MODE  CREATE_SCN TOTAL_SIZE BLOCK_SIZE
---------- ---------- ---------- -------------------------------- ---------- ---------- ---------- ---------- ----------
         2 4264868981 4264868981 0951B9CFB39C2060E0530100007F6961 PDB$SEED   READ ONLY     1594434  870318080       8192
         3 3977202490 3977202490 09521ABB982E7F0BE0530100007FD46A XJNY       READ WRITE    1753354  917504000       8192
         4 4211777660 4211777660 0986C60CA76145FDE0530100007F304E WAPDB      READ ONLY     1896905  870318080       8192
         5 1281880106 1281880106 0987D2D2C15B4758E0530100007F4AA4 MBS        READ WRITE    1905674  891289600       8192
可见,在克隆pdb时,需要将源pdb已read only模式打开

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

上一篇: ora_rowscn伪列测试
请登录后发表评论 登录
全部评论
十余年大型金融及电信系统数据库管理经验,曾服务于中国建设银行、中国移动。对oracle,mysql数据库有深入了解。 擅长python开发,独立开发了开源数据库自动化监控运维平台Power Monitor。

注册时间:2008-02-29

  • 博文量
    335
  • 访问量
    1369107