共計 3504 個字符，預計需要花費 9 分鐘才能閱讀完成。
這篇文章主要介紹“rac 中文名文件名添加到本地路徑解決辦法”，在日常操作中，相信很多人在 rac 中文名文件名添加到本地路徑解決辦法問題上存在疑惑，丸趣 TV 小編查閱了各式資料，整理出簡單好用的操作方法，希望對大家解答”rac 中文名文件名添加到本地路徑解決辦法”的疑惑有所幫助！接下來，請跟著丸趣 TV 小編一起來學習吧！
oracle rac 中文名添加到本地路徑的辦法
故障模擬(生產環境勿測試)
點擊 (此處) 折疊或打開
[grid@rac1-213-11 ~]# su – oracle
[grid@rac1-213-11 ~]$ sqlplus / as sysdba
SQL alter table netdata add datafile 測試 DATA
在第二個節點上查詢出現錯誤
點擊 (此處) 折疊或打開
[oracle@rac2-213-12 trace]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun Jul 1 22:07:21 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL select file_name from dba_data_files;
ERROR:
ORA-01157: cannot identify/lock data file 9 – see DBWR trace file
ORA-01110: data file 9: /u01/app/oracle/product/11.2.0/db_1/dbs/ 測試 DATA
SQL select file_name from dba_data_files;
ERROR:
ORA-01157: cannot identify/lock data file 9 – see DBWR trace file
ORA-01110: data file 9: /u01/app/oracle/product/11.2.0/db_1/dbs/ 嫻????ìDATA
關閉庫，復制文件
點擊 (此處) 折疊或打開
–grd
[grid@rac1-213-11 ~]$ srvctl stop database -d devdb
–oracle
[oracle@rac1-213-11 dbs]$ cp 測試 DATA netdata05.dbf
mount 庫
–grid
[grid@rac1-213-11 ~]$ srvctl start database -d devdb -o mount
–oracle
[oracle@rac1-213-11 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun Jul 1 22:39:54 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
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
Database altered.
關閉庫，再次復制文件至 asm
點擊 (此處) 折疊或打開
[grid@rac1-213-11 ~]$ srvctl stop database -d devdb
ASMCMD cp /u01/app/oracle/product/11.2.0/db_1/dbs/netdata05.dbf .
copying /u01/app/oracle/product/11.2.0/db_1/dbs/netdata05.dbf – +DATA1/DEVDB/DATAFILE/netdata05.dbf
ASMCMD quit
mount 庫
點擊 (此處) 折疊或打開
[grid@rac1-213-11 ~]$ srvctl start database -d devdb -o mount
修改文件路徑
點擊 (此處) 折疊或打開
SQL alter database rename file /u01/app/oracle/product/11.2.0/db_1/dbs/netdata05.dbf to +DATA1/DEVDB/DATAFILE/netdata05.dbf
SQL Database altered.
關閉庫
數據庫已經正常
點擊 (此處) 折疊或打開
[oracle@rac1-213-11 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun Jul 1 22:49:49 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL select open_mode from v$database;
OPEN_MODE
——————–
READ WRITE
節點 2 查看
點擊 (此處) 折疊或打開
[oracle@rac2-213-12 trace]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun Jul 1 22:07:21 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL /
FILE_NAME
——————————————————————————–
+DATA1/devdb/datafile/users.269.937046643
+DATA1/devdb/datafile/undotbs1.276.937046643
+DATA1/devdb/datafile/sysaux.277.937046643
+DATA1/devdb/datafile/system.268.937046635
+DATA1/devdb/datafile/undotbs2.267.937047083
+DATA1/devdb/datafile/netdata.284.937049537
+DATA1/devdb/datafile/netdata02.dbf
+DATA1/devdb/datafile/netdata03.dbf
+DATA1/devdb/datafile/netdata05.dbf
到此，關于“rac 中文名文件名添加到本地路徑解決辦法”的學習就結束了，希望能夠解決大家的疑惑。理論與實踐的搭配能更好的幫助大家學習，快去試試吧！若想繼續學習更多相關知識，請繼續關注丸趣 TV 網站，丸趣 TV 小編會繼續努力為大家帶來更多實用的文章！
