设为首页 加入收藏

TOP

oracle12c学习之三nocdb转换成pdb
2015-07-24 10:33:22 来源: 作者: 【 】 浏览:1
Tags:oracle12c 学习 之三 nocdb 换成 pdb
01:23:06 sys@orcl> select name, decode(cdb, 'YES', 'Multitenant Option enabled', 'Regular 12c Database: ') "Multitenant Option" , open_mode, con_id from v$database; 

NAME Multitenant Option OPEN_MODE CON_ID 
--------- -------------------------- -------------------- ------------- 
ORCL Regular 12c Database: READ WRITE 0

可见该数据库是传统的数据库,不是cdb
下面我们把这个数据库转换成cdb
01:27:24 sys@orcl> select name from v$datafile; 

NAME 
---------------------------------------------------------------------------------------------------------------------------------- 
+DATA/ORCL/DATAFILE/system.354.874717421 
+DATA/ORCL/DATAFILE/undotbs2.352.874718065 
+DATA/ORCL/DATAFILE/sysaux.322.874717327 
+DATA/ORCL/DATAFILE/undotbs1.326.874717527 
+DATA/ORCL/DATAFILE/kiwi.328.874718845 
+DATA/ORCL/DATAFILE/users.329.874717527 

6 rows selected. 

Elapsed: 00:00:00.01 
01:27:33 sys@orcl> shutdown immediate; 
Database closed. 
Database dismounted. 
ORACLE instance shut down. 
01:28:46 sys@orcl> startup restrict mount exclusive; 
ORACLE instance started. 

Total System Global Area 2488635392 bytes 
Fixed Size 2291424 bytes 
Variable Size 721422624 bytes 
Database Buffers 1744830464 bytes 
Redo Buffers 20090880 bytes 
Database mounted.

01:29:11 sys@orcl> alter database open read only; 

Database altered. 

Elapsed: 00:00:04.42 
01:30:28 sys@orcl> begin 
01:32:27 2 dbms_pdb.describe(PDB_DESCR_FILE => '/u02/noncdb/orcl.xml'); 
01:32:27 3 end; 
01:32:27 4 /

create pluggable database orcl using '/u02/noncdb/orcl.xml' copy;

alter session set container=orcl;
在执行这个脚本转换成pdb
@?/rdbms/admin/noncdb_to_pdb.sql

】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇oracle建立dblink以及建立定时任务 下一篇Oracle学习(18)【DBA向】:分布..

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容:

·TCP/UDP协议_百度百科 (2025-12-26 12:20:11)
·什么是TCP和UDP协议 (2025-12-26 12:20:09)
·TCP和UDP详解 (非常 (2025-12-26 12:20:06)
·Python 教程 - W3Sch (2025-12-26 12:00:51)
·Python基础教程,Pyt (2025-12-26 12:00:48)