平武建站

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

这篇文章主要介绍“rac中文名文件名添加到本地路径解决办法”，在日常操作中，相信很多人在rac中文名文件名添加到本地路径解决办法问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”rac中文名文件名添加到本地路径解决办法”的疑惑有所帮助！接下来，请跟着小编一起来学习吧！

创新互联公司拥有十多年成都网站建设工作经验,为各大企业提供成都网站设计、成都网站建设服务，对于网页设计、PC网站建设（电脑版网站建设）、App定制开发、wap网站建设（手机版网站建设）、程序开发、网站优化（SEO优化）、微网站、空间域名等，凭借多年来在互联网的打拼，我们在互联网网站建设行业积累了很多网站制作、网站设计、网络营销经验，集策划、开发、设计、营销、管理等网站化运作于一体，具备承接各种规模类型的网站建设项目的能力。

oracle rac中文名添加到本地路径的办法


故障模拟(生产环境勿测试)

点击(此处)折叠或打开

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

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

  3. SQL>alter table netdata add datafile '测试DATA'



在第二个节点上查询出现错误

点击(此处)折叠或打开

  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'

关闭库，复制文件

点击(此处)折叠或打开

  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.




关闭库，再次复制文件至asm

点击(此处)折叠或打开

  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库

点击(此处)折叠或打开

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




修改文件路径

点击(此处)折叠或打开

  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.


关闭库






数据库已经正常

点击(此处)折叠或打开

  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




节点2查看

点击(此处)折叠或打开

  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

到此，关于“rac中文名文件名添加到本地路径解决办法”的学习就结束了，希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习，快去试试吧！若想继续学习更多相关知识，请继续关注创新互联网站，小编会继续努力为大家带来更多实用的文章！


文章标题：rac中文名文件名添加到本地路径解决办法
网页网址：http://pwwzsj.com/article/jcgdeg.html

其他资讯