rac中文名文件名添加到本地路径解决办法

共计 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 小编会继续努力为大家带来更多实用的文章！