真实的国产乱ⅩXXX66竹夫人,五月香六月婷婷激情综合,亚洲日本VA一区二区三区,亚洲精品一区二区三区麻豆

成都創(chuàng)新互聯(lián)網(wǎng)站制作重慶分公司

oracle升級(jí)后數(shù)據(jù)文件路徑變?yōu)榇髮?創(chuàng)新互聯(lián)

進(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”都是大寫,而以前都是小寫。

oracle升級(jí)后數(shù)據(jù)文件路徑變?yōu)榇髮?></p><p>查詢官方文檔
Directory for Datafiles and Controlfiles Become Uppercase in 18.3 DBCA. (Doc ID 2542927.1)</p><p>在18.3.0.0版本開始,內(nèi)部設(shè)計(jì)上的變化導(dǎo)致了此問題。</p><p>同時(shí)還指向一個(gè)internal的文檔,無權(quán)限瀏覽:</p><p>BUG:29294715
 - 18.3 DBCA UPPERCASING DB_UNIQUE_NAME FOR DIRECTORY OF DATA FILES AND CONTROL FILES.</p><p>進(jìn)一步分析發(fā)現(xiàn),我們將數(shù)據(jù)庫升級(jí)到19c,并將compatible由11.2.0.4改為19.3.0.0后,數(shù)據(jù)文件路徑就改為大寫了。</p><p>使用文件系統(tǒng)作為存儲(chǔ)介質(zhì)的數(shù)據(jù)庫未出現(xiàn)此問題。</p>

<p>Directory for Datafiles and Controlfiles Become Uppercase in 18.3 DBCA. (Doc ID 2542927.1)</p><h3>APPLIES TO:</h3>
<p>Oracle Database Configuration Assistant - Version 18.3.0.0.0 and later
<br/>
Information in this document applies to any platform.
</p><h3>SYMPTOMS</h3>
<p>When you specified lowercase 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

其他資訊

在線咨詢

微信咨詢

電話咨詢

028-86922220(工作日)

18980820575(7×24)

提交需求

返回頂部