ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > Oracle > clone oracle 12c pluggable databases

clone oracle 12c pluggable databases

原创 Oracle 作者：fuyiwbl 时间：2014-06-21 00:32:16 0 删除 编辑

PDB(pluggable databases）是Oracle 12c 引入的一个新特性，如其名，在oracle 12c 中PDB可以在CDB(container database)中进行“插拔”，除此之外PDB还有很多吸引人的东西，如更简单快捷创建一个PDB的副本。
    以下内容介绍如何在同一个CDB中克隆PDB。


1.将需要克隆的PDB设置为READ ONLY 模式

点击(此处)折叠或打开

  1. [oracle@oracle12c ~]$ sqlplus / as sysdba

  3. SQL*Plus: Release 12.1.0.1.0 Production on Fri Jun 20 23:29:38 2014

  5. Copyright (c) 1982, 2013, Oracle. All rights reserved.


  8. Connected to:
  9. Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
  10. With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
  11. SQL> set line 300
  12. SQL> select NAME,OPEN_MODE from v$pdbs where name='PDBORCL12C';

  14. NAME OPEN_MODE
  15. ------------------- ------------------
  16. PDBORCL12C READ WRITE
  17. SQL> alter pluggable database pdborcl12c close immediate;

  19. Pluggable database altered.

  21. SQL> select NAME,OPEN_MODE from v$pdbs where name='PDBORCL12C';

  23. NAME OPEN_MODE
  24. --------------------- -------------------
  25. PDBORCL12C MOUNTED
  26. SQL> alter pluggable database pdborcl12c open read only;

  28. Pluggable database altered.

  30. SQL> select NAME,OPEN_MODE from v$pdbs where name='PDBORCL12C';

  32. NAME OPEN_MODE
  33. ---------------------- -----------------
  34. PDBORCL12C READ ONLY
  35. SQL> exit

2.确定空间需求

点击(此处)折叠或打开

  1. sqlplus / as sysdba
  2. SQL*Plus: Release 12.1.0.1.0 Production on Fri Jun 20 23:46:08 2014
  3. Copyright (c) 1982, 2013, Oracle. All rights reserved.
  4. Connected to:
  5. Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
  6. With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
  7. SQL> alter session set container=pdborcl12c;
  8. Session altered.
  9. SQL> set line 300
  10. SQL> col tablespace_name for a32
  11. SQL> col file_name for a128
  12. SQL> select tablespace_name,file_name,bytes/1024/1024 MB from dba_data_files;
  13. TABLESPACE_NAME FILE_NAME MB
  14. ----------------- -------------------------------------------------------------------------------------------------------------------------------- ----------
  15. SYSTEM /oracle/12c/oradata/ORCL12C/F8BDD749BE6A231CE043230A0A0A7F5C/datafile/o1_mf_system_9pkzo0vz_.dbf 270
  16. SYSAUX /oracle/12c/oradata/ORCL12C/F8BDD749BE6A231CE043230A0A0A7F5C/datafile/o1_mf_sysaux_9pkzo118_.dbf 680
  17. USERS /oracle/12c/oradata/ORCL12C/F8BDD749BE6A231CE043230A0A0A7F5C/datafile/o1_mf_users_9pkzp768_.dbf 512
  18. SQL> select tablespace_name,file_name,bytes/1024/1024 MB from dba_temp_files
  19. TABLESPACE_NAME          FILE_NAME                                                                 MB
  20. -------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------
  21. TEMP                 /oracle/12c/oradata/ORCL12C/F8BDD749BE6A231CE043230A0A0A7F5C/datafile/o1_mf_temp_9pkzoz5y_.dbf                      507
  22. SQL> exit

空间需求2593MB。

3.为克隆PDB创建目录

点击(此处)折叠或打开

  1. [oracle@oracle12c ORCL12C]$ pwd
  2. /oracle/12c/oradata/ORCL12C
  3. [oracle@oracle12c ORCL12C]$ mkdir pdborcl12c_clone
  4. [oracle@oracle12c ORCL12C]$ ls -l
  5. total 20
  6. drwxr-x---. 2 oracle oinstall 4096 May 6 23:13 controlfile
  7. drwxr-x---. 2 oracle oinstall 4096 May 6 23:14 datafile
  8. drwxr-x---. 3 oracle oinstall 4096 May 6 23:24 F8BDD749BE6A231CE043230A0A0A7F5C
  9. drwxr-x---. 2 oracle oinstall 4096 May 6 23:41 onlinelog
  10. drwxr-xr-x. 2 oracle oinstall 4096 Jun 21 00:02 pdborcl12c_clone


4.配置db_create_file_dest参数

点击(此处)折叠或打开

  1. sqlplus / as sysdba

  3. SQL*Plus: Release 12.1.0.1.0 Production on Sat Jun 21 00:07:50 2014

  5. Copyright (c) 1982, 2013, Oracle. All rights reserved.


  8. Connected to:
  9. Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
  10. With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

  12. SQL> alter system set db_create_file_dest='/oracle/12c/oradata/ORCL12C/pdborcl12c_clone' ;

  14. System altered.


5.克隆PDB

点击(此处)折叠或打开

  1. sqlplus / as sysdba

  3. SQL*Plus: Release 12.1.0.1.0 Production on Sat Jun 21 00:19:45 2014

  5. Copyright (c) 1982, 2013, Oracle. All rights reserved.


  8. Connected to:
  9. Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
  10. With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
  11. SQL> create pluggable database pdborcl12c_clone from pdborcl12c;

  13. Pluggable database created.

  15. SQL> alter pluggable database pdborcl12c_clone open;

  17. Pluggable database altered.

  19. SQL> select name,open_mode from v$pdbs;

  21. NAME             OPEN_MODE
  22. ------------------------------ ----------
  23. PDB$SEED         READ ONLY
  24. PDBORCL12C         READ ONLY
  25. PDBORCL12C_CLONE     READ WRITE

  27. SQL> conn system/oracle@localhost:1521/pdborcl12c_clone
  28. Connected.
  29. SQL> show con_name

  31. CON_NAME
  32. ------------------------------
  33. PDBORCL12C_CLONE


6.将源PDB改为OPEN模式

点击(此处)折叠或打开

  1. SQL> connect / as sysdba
  2. Connected.
  3. SQL> alter session set container=cdb$root;

  5. Session altered.
  6. SQL> alter pluggable database pdborcl12c close immediate;

  8. Pluggable database altered.

  10. SQL> alter pluggable database pdborcl12c open;

  12. Pluggable database altered.

  14. SQL> select name,open_mode from v$pdbs;

  16. NAME             OPEN_MODE
  17. ------------------------------ ----------
  18. PDB$SEED         READ ONLY
  19. PDBORCL12C         READ WRITE
  20. PDBORCL12C_CLONE     READ WRIT


本文乃付义原创文章，请勿转载。如须转载请详细标明转载出处。


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

0
0
上一篇： 没有了~
下一篇： 没有了~
请登录后发表评论 登录
全部评论
fuyiwbl

注册时间：2013-02-18

  • 博文量
    1
  • 访问量
    6223

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593