oracle升級(jí)后數(shù)據(jù)文件路徑變?yōu)榇髮?/h1>

進(jìn)行數(shù)據(jù)文件維護(hù)時(shí)，發(fā)現(xiàn)數(shù)據(jù)文件的名稱存在大小寫差異。

目前創(chuàng)新互聯(lián)公司已為近千家的企業(yè)提供了網(wǎng)站建設(shè)、域名、虛擬空間、網(wǎng)站運(yùn)營(yíng)、企業(yè)網(wǎng)站設(shè)計(jì)、甘南網(wǎng)站維護(hù)等服務(wù)，公司將堅(jiān)持客戶導(dǎo)向、應(yīng)用為本的策略，正道將秉承"和諧、參與、激情"的文化，與客戶和合作伙伴齊心協(xié)力一起成長(zhǎng)，共同發(fā)展。

在某個(gè)時(shí)間點(diǎn)以后創(chuàng)建的數(shù)據(jù)文件，名稱中的db_name和“datafile”都是大寫，而以前都是小寫。

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.

網(wǎng)站標(biāo)題：oracle升級(jí)后數(shù)據(jù)文件路徑變?yōu)榇髮?
路徑分享：http://weahome.cn/article/gehece.html