oracle 12c asm 创建pdb | ORACEL 12C | ORACLE技术论坛

Please consider registering
guest

Log In

Lost password?
Advanced Search:

— Forum Scope —



— Match —



— Forum Options —




Wildcard usage:
*  matches any number of characters    %  matches exactly one character

Minimum search word length is 4 characters - maximum search word length is 84 characters

Topic RSS
oracle 12c asm 创建pdb
2014 年 03 月 10 日
17:15
slowsoul
Guest

最近单位要求测试hp ia 平台上的12c,建完库后,进行pdb简单测试,发现在asm环境下的:

 

SQL*Plus: Release 12.1.0.1.0 Production on Mon Mar 10 17:10:35 2014

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

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SQL> show con_name

CON_NAME
——————————
CDB$ROOT
SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 PDB$SEED READ ONLY NO
3 CRMDB1 READ WRITE NO
4 CRMDB2 READ WRITE NO
SQL> alter session set container=pdb$seed;

Session altered.

SQL> select file_name from dba_data_files;

FILE_NAME
——————————-

FILE_NAME
——————————————————————————--
+DATADG/N12CDB/F43823DEEA016DADE04484349712023A/DATAFILE/system.261.841836305
+DATADG/N12CDB/F43823DEEA016DADE04484349712023A/DATAFILE/sysaux.263.841836325

 

pdb$seed 文件格式是asm系统生成的,如果建立新pdb from seedpdb 时候 指定 file_convert_name 无法创建:

 

SQL> CREATE PLUGGABLE DATABASE crmdb3 ADMIN USER dbmgr IDENTIFIED BY dbmgr
2 DEFAULT TABLESPACE D_LOG_01
3 DATAFILE '+DATADG' SIZE 10G AUTOEXTEND OFF
4 PATH_PREFIX = '+DATADG/N12CDB/CRMDB3/'
5 FILE_NAME_CONVERT = ('+DATADG/N12CDB/F43823DEEA016DADE04484349712023A/', '+DATADG/N12CDB/CRMDB3/');
CREATE PLUGGABLE DATABASE crmdb3 ADMIN USER dbmgr IDENTIFIED BY dbmgr
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level
ORA-19504: failed to create file "+DATADG/N12CDB/CRMDB3/"

 

 

只能CREATE PLUGGABLE DATABASE crmdb3 ADMIN USER dbmgr IDENTIFIED BY dbmgr 创建pdb ,是否这个文件目录只能系统指定无法,手工修改?

还有创建pdb 怎么 还存在新的tempfile ? 

 

 

 

 

2014 年 03 月 10 日
17:17
slowsoul
Guest

SQL> alter session set container=crmdb1 ;

Session altered.

SQL> select file_name from dba_temp_files;

FILE_NAME
——————————————————————————--
+DATADG/N12CDB/F43AABF3BA42121DE04484349712023A/TEMPFILE/temp.274.841847143

 

临时表空间不是公用的吗,怎么创建完pdb后 会有 新的临时文件被创建

2014 年 03 月 10 日
17:20
惜分飞
Admin
Forum Posts: 349
Member Since:
2010 年 07 月 31 日
Offline

 我现在没有asm的12c环境,但是根据我的经验,FILE_NAME_CONVERT这里看那直接写磁盘组名称是比较靠谱

 

另外你确认下+DATADG/N12CDB/CRMDB3目录是否存在

Q Q:107644445  

Tel:13429648788

个人Blog(惜分飞)

提供专业ORACLE技术支持(数据恢复,安装实施,升级迁移,备份容灾,故障诊断,系统优化等)

    

       
   

评论功能已关闭。