rac中文名文件名添加到本地路徑解決辦法

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

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


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

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

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

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

3. SQL>alter table netdata add datafile '測(cè)試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/測(cè)試DATA'
    

12. 
    

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)閉庫(kù)，復(fù)制文件

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

1. --grd
   

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

3. 
   

4. 
   

5. --oracle
   

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

7. 
   

8. 
   

9. mount 庫(kù)
   

10. --grid
    

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

12. --oracle
    

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

14. 
    

15. 
    

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.
    

18. 
    

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
    

23. 
    

24. 
    

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

26. 
    

27. Database altered.

關(guān)閉庫(kù)，再次復(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庫(kù)

點(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)閉庫(kù)

數(shù)據(jù)庫(kù)已經(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
   

2. 
   

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

4. 
   

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

6. 
   

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
    

11. 
    

12. 
    

13. 
    

14. 
    

15. SQL> /
    

16. 
    

17. 
    

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í)，請(qǐng)繼續(xù)關(guān)注億速云網(wǎng)站，小編會(huì)繼續(xù)努力為大家?guī)?lái)更多實(shí)用的文章！