oracle升级后数据文件路径变为大写

拼搏现实的明天。 2023-01-22 03:56 3阅读 0赞

进行数据文件维护时，发现数据文件的名称存在大小写差异。

在某个时间点以后创建的数据文件，名称中的[db\_name和“datafile][db_name_datafile]”都是大写，而以前都是小写。

![在这里插入图片描述][20210517142832648.png]

查询官方文档 Directory for Datafiles and Controlfiles Become Uppercase in 18.3 DBCA. (Doc ID 2542927.1)

在18.3.0.0版本开始，内部设计上的变化导致了此问题。

同时还指向一个internal的文档，无权限浏览：

*  18.3 DBCA UPPERCASING DB\_UNIQUE\_NAME FOR DIRECTORY OF DATA FILES AND CONTROL FILES.

进一步分析发现，我们将数据库升级到19c，并将compatible由11.2.0.4改为19.3.0.0后，数据文件路径就改为大写了。

使用文件系统作为存储介质的数据库未出现此问题。

Directory for Datafiles and Controlfiles Become Uppercase in 18.3 DBCA. (Doc ID 2542927.1)

APPLIES TO:  
Oracle Database Configuration Assistant - Version 18.3.0.0.0 and later  
Information in this document applies to any platform.

## SYMPTOMS   When you specified lowercase “DB\_UNIQUE\_NAME” variable(for example:orcl) in DB:18.3 DBCA to create DB instance   after the instance be created, you will find the directory of data files and control files contains uppercase DB\_UNIQUE\_NAME which you specified. ##

## /u01/app/oracle/oradata/ORCL ##

This result is different from the previous version(DB:12.2/DB:12.1).

If we save the DBCA scripts which can be generated by DBCA, we could see that even if you specified lowercase DB\_UNIQUE\_NAME in DBCA,  
the script is to create uppercase DB\_UNIQUE\_NAME in the directory path of data files and control files.

$ pwd  
…/…oracle/admin/orcl/scripts  
scripts\]$ grep “ORCL” \*.sql  
cloneDBCreation.sql:LOGFILE GROUP 1  
(’…oradata/ORCL/redo01.log’) SIZE 200M,  
cloneDBCreation.sql:GROUP 2 (’…oradata/ORCL/redo02.log’) SIZE  
200M,  
cloneDBCreation.sql:GROUP 3 (’…/oradata/ORCL/redo03.log’) SIZE  
200M RESETLOGS;  
cloneDBCreation.sql:LOGFILE GROUP 1  
(’…oradata/ORCL/redo01.log’) SIZE 200M,  
cloneDBCreation.sql:GROUP 2 (’…oradata/ORCL/redo02.log’) SIZE  
200M,  
…  
plug\_PDBSeed.sql:host mkdir -p …/oradata/ORCL/pdbseed;  
plug\_PDBSeed.sql:host mkdir -p …/oracle/oradata/ORCL/pdbseed;  
…  
rmanRestoreDatafiles.sql:set newname for datafile 4 to  
‘…oradata/ORCL/undotbs01.dbf’ ;  
rmanRestoreDatafiles.sql:set newname for datafile 7 to  
‘…oradata/ORCL/users01.dbf’ ;  
CHANGES  
Using DB:18.3 DBCA to create database instance and specified lowercase “DB\_UNIQUE\_NAME” variable.

CAUSE  
It is a limitation according to current design.

SOLUTION  
The following method can avoid this issue.

STEP 1: Generate the DBCA Scripts.  
STEP 2: Change the uppercase DB\_UNIQUE\_NAME to lowercase DB\_UNIQUE\_NAME manually.  
STEP 3: Execute these scripts to create DB instance.

来自 “ 开源世界 ” ，链接：[http://ym.baisou.ltd/post/537.html][http_ym.baisou.ltd_post_537.html]，如需转载，请注明出处，否则将追究法律责任。

[db_name_datafile]: http://github.crmeb.net/u/defu
[20210517142832648.png]: /images/20221020/d244cd4d33b4428ebef36bee6c713ce3.png
[http_ym.baisou.ltd_post_537.html]: http://ym.baisou.ltd/post/537.html