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

讓客戶滿意是我們工作的目標(biāo),不斷超越客戶的期望值來自于我們對這個(gè)行業(yè)的熱愛。我們立志把好的技術(shù)通過有效、簡單的方式提供給客戶,將通過不懈努力成為客戶在信息化領(lǐng)域值得信任、有價(jià)值的長期合作伙伴,公司提供的服務(wù)項(xiàng)目有:國際域名空間、
雅安服務(wù)器托管、營銷軟件、網(wǎng)站建設(shè)、
陽新網(wǎng)站維護(hù)、網(wǎng)站推廣。
在某個(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' ;
網(wǎng)站標(biāo)題:oracle升級(jí)后數(shù)據(jù)文件路徑變?yōu)榇髮?創(chuàng)新互聯(lián)
本文鏈接:
http://weahome.cn/article/ddepsg.html