這篇文章主要介紹“rac中文名文件名添加到本地路徑解決辦法”，在日常操作中，相信很多人在rac中文名文件名添加到本地路徑解決辦法問題上存在疑惑，小編查閱了各式資料，整理出簡單好用的操作方法，希望對大家解答”rac中文名文件名添加到本地路徑解決辦法”的疑惑有所幫助！接下來，請跟著小編一起來學(xué)習(xí)吧！

創(chuàng)新互聯(lián)公司擁有十多年成都網(wǎng)站建設(shè)工作經(jīng)驗(yàn),為各大企業(yè)提供成都網(wǎng)站設(shè)計(jì)、成都網(wǎng)站建設(shè)服務(wù)，對于網(wǎng)頁設(shè)計(jì)、PC網(wǎng)站建設(shè)（電腦版網(wǎng)站建設(shè)）、App定制開發(fā)、wap網(wǎng)站建設(shè)（手機(jī)版網(wǎng)站建設(shè)）、程序開發(fā)、網(wǎng)站優(yōu)化（SEO優(yōu)化）、微網(wǎng)站、空間域名等，憑借多年來在互聯(lián)網(wǎng)的打拼，我們在互聯(lián)網(wǎng)網(wǎng)站建設(shè)行業(yè)積累了很多網(wǎng)站制作、網(wǎng)站設(shè)計(jì)、網(wǎng)絡(luò)營銷經(jīng)驗(yàn)，集策劃、開發(fā)、設(shè)計(jì)、營銷、管理等網(wǎng)站化運(yùn)作于一體，具備承接各種規(guī)模類型的網(wǎng)站建設(shè)項(xiàng)目的能力。

oracle rac中文名添加到本地路徑的辦法


故障模擬(生產(chǎn)環(huán)境勿測試)

點(diǎn)擊(此處)折疊或打開

1. [grid@rac1-213-11 ~]# su - oracle

2. [grid@rac1-213-11 ~]$ sqlplus / as sysdba

3. SQL>alter table netdata add datafile '測試DATA'

在第二個(gè)節(jié)點(diǎn)上查詢出現(xiàn)錯(cuò)誤

點(diǎn)擊(此處)折疊或打開

1. [oracle@rac2-213-12 trace]$ sqlplus / as sysdba

2. SQL*Plus: Release 11.2.0.4.0 Production on Sun Jul 1 22:07:21 2018

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

4. Connected to:

5. Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

6. With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

7. Data Mining and Real Application Testing options

8. SQL> select file_name from dba_data_files;

9. ERROR:

10. ORA-01157: cannot identify/lock data file 9 - see DBWR trace file

11. ORA-01110: data file 9: '/u01/app/oracle/product/11.2.0/db_1/dbs/測試DATA'

13. SQL> select file_name from dba_data_files;

14. ERROR:

15. ORA-01157: cannot identify/lock data file 9 - see DBWR trace file

16. ORA-01110: data file 9: '/u01/app/oracle/product/11.2.0/db_1/dbs/嫻????ìDATA'

關(guān)閉庫，復(fù)制文件

點(diǎn)擊(此處)折疊或打開

1. --grd

2. [grid@rac1-213-11 ~]$ srvctl stop database -d devdb

5. --oracle

6. [oracle@rac1-213-11 dbs]$ cp "測試DATA" netdata05.dbf

9. mount 庫

10. --grid

11. [grid@rac1-213-11 ~]$ srvctl start database -d devdb -o mount

12. --oracle

13. [oracle@rac1-213-11 ~]$ sqlplus / as sysdba

16. SQL*Plus: Release 11.2.0.4.0 Production on Sun Jul 1 22:39:54 2018

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

19. Connected to:

20. Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

21. With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

22. Data Mining and Real Application Testing options

25. SQL> alter database rename file '/u01/app/oracle/product/11.2.0/db_1/dbs/測試DATA' to '/u01/app/oracle/product/11.2.0/db_1/dbs/netdata05.dbf';

27. Database altered.

關(guān)閉庫，再次復(fù)制文件至asm

點(diǎn)擊(此處)折疊或打開

1. [grid@rac1-213-11 ~]$ srvctl stop database -d devdb

2. ASMCMD> cp /u01/app/oracle/product/11.2.0/db_1/dbs/netdata05.dbf .

3. copying /u01/app/oracle/product/11.2.0/db_1/dbs/netdata05.dbf -> +DATA1/DEVDB/DATAFILE/netdata05.dbf

4. ASMCMD> quit

mount庫

點(diǎn)擊(此處)折疊或打開

1. [grid@rac1-213-11 ~]$ srvctl start database -d devdb -o mount

修改文件路徑

點(diǎn)擊(此處)折疊或打開

1. SQL> alter database rename file '/u01/app/oracle/product/11.2.0/db_1/dbs/netdata05.dbf' to '+DATA1/DEVDB/DATAFILE/netdata05.dbf';

2. SQL>Database altered.

關(guān)閉庫

數(shù)據(jù)庫已經(jīng)正常

點(diǎn)擊(此處)折疊或打開

1. [oracle@rac1-213-11 ~]$ sqlplus / as sysdba

2. SQL*Plus: Release 11.2.0.4.0 Production on Sun Jul 1 22:49:49 2018

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

4. Connected to:

5. Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

6. With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

7. Data Mining and Real Application Testing options

8. SQL> select open_mode from v$database;

9. OPEN_MODE

10. --------------------

11. READ WRITE

節(jié)點(diǎn)2查看

點(diǎn)擊(此處)折疊或打開

1. [oracle@rac2-213-12 trace]$ sqlplus / as sysdba

3. SQL*Plus: Release 11.2.0.4.0 Production on Sun Jul 1 22:07:21 2018

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

7. Connected to:

8. Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

9. With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

10. Data Mining and Real Application Testing options

15. SQL> /

18. FILE_NAME

19. --------------------------------------------------------------------------------

20. +DATA1/devdb/datafile/users.269.937046643

21. +DATA1/devdb/datafile/undotbs1.276.937046643

22. +DATA1/devdb/datafile/sysaux.277.937046643

23. +DATA1/devdb/datafile/system.268.937046635

24. +DATA1/devdb/datafile/undotbs2.267.937047083

25. +DATA1/devdb/datafile/netdata.284.937049537

26. +DATA1/devdb/datafile/netdata02.dbf

27. +DATA1/devdb/datafile/netdata03.dbf

28. +DATA1/devdb/datafile/netdata05.dbf

到此，關(guān)于“rac中文名文件名添加到本地路徑解決辦法”的學(xué)習(xí)就結(jié)束了，希望能夠解決大家的疑惑。理論與實(shí)踐的搭配能更好的幫助大家學(xué)習(xí)，快去試試吧！若想繼續(xù)學(xué)習(xí)更多相關(guān)知識(shí)，請繼續(xù)關(guān)注創(chuàng)新互聯(lián)網(wǎng)站，小編會(huì)繼續(xù)努力為大家?guī)砀鄬?shí)用的文章！

分享標(biāo)題：rac中文名文件名添加到本地路徑解決辦法
文章轉(zhuǎn)載：http://www.ekvhdxd.cn/article46/jcgdeg.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供虛擬主機(jī)、網(wǎng)站設(shè)計(jì)、App開發(fā)、云服務(wù)器、網(wǎng)站改版、外貿(mào)網(wǎng)站建設(shè)

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源： 創(chuàng)新互聯(lián)