Shulou(Shulou.com)05/31 Report--

This article mainly introduces the "rac Chinese name file name added to the local path solution", in the daily operation, I believe that many people have doubts in the rac Chinese name file name added to the local path solution, the editor consulted all kinds of information, sorted out a simple and easy-to-use method of operation, hoping to answer the "rac Chinese name file name added to the local path solution" doubt is helpful! Next, please follow the editor to study!

The method of adding Chinese name to local path in oracle rac

Fault simulation (do not test in production environment)

Click (here) to collapse or open

[grid@rac1-213-11] # su-oracle

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

SQL > alter table netdata add datafile 'Test DATA'

An error occurred in the query on the second node

Click (here) to collapse or open

[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/ Test 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/ Han DATA'

Close the library and copy the file

Click (here) to collapse or open

-- grd

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

-- oracle

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

Mount library

-- 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/ Test DATA' to'/ u01OnOnOnOnOnApp oracleUniverse productUniverse 11.2.0Universe dbAction1According to dbsUniplex netdata05.dbf'

Database altered.

Close the library and copy the file to asm again

Click (here) to collapse or open

[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 library

Click (here) to collapse or open

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

Modify file path

Click (here) to collapse or open

SQL > alter database rename file'/ u01ActionActionActionproduct 11.2.0According to dbAction1According to dbsUniGetdata05.dbf'to'+ DATA1/DEVDB/DATAFILE/netdata05.dbf'

SQL > Database altered.

Close the library

The database is normal.

Click (here) to collapse or open

[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

Node 2 View

Click (here) to collapse or open

[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

At this point, the study on "rac Chinese name file name added to the local path solution" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.