一、环境
11g rac
rhel 6.8

二、报错信息
SQL> select file_name from dba_data_files;
ERROR:
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6:
'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/DATAfsczracdatafilefinance.DBF'

三、处理过程
花了几分钟,清理了一下思路,写好脚本就开始整。

1、默认归档已打开SQL>archiveloglist;DatabaselogmodeArchiveModeAutomaticarchivalEnabledArchivedestination+DATA/archOldestonlinelogsequence20Nextlogsequencetoarchive22Currentlogsequence22SQL>SQL>2、offline表空间SQL>altertablespaceFINANCEoffline;Tablespacealtered.3、cp数据文件ASMCMD[+data/FSCZRAC/datafile]>cp/u01/app/oracle/product/11.2.0/dbhome_1/dbs/DATAfsczracdatafilefinance.DBF+data/fsczrac/datafile/DATAfsczracdatafilefinance.DBFcopying/u01/app/oracle/product/11.2.0/dbhome_1/dbs/DATAfsczracdatafilefinance.DBF->+data/fsczrac/datafile/DATAfsczracdatafilefinance.DBFASMCMD[+data/FSCZRAC/datafile]>4、修改控制文件中的数据文件路径SQL>alterdatabaserenamefile'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/DATAfsczracdatafilefinance.DBF'to'+data/fsczrac/datafile/DATAfsczracdatafilefinance.DBF';Databasealtered.5、恢复表空间SQL>recovertablespacefinance;Mediarecoverycomplete.6、表空间onlineSQL>altertablespacefinanceonline;Tablespacealtered.7、验证SQL>colfile_namefora60SQL>selectfile_name,file_id,online_statusfromdba_data_files;FILE_NAMEFILE_IDONLINE_-----------------------------------------------------------------------------+DATA/fsczrac/datafile/users.259.9674756414ONLINE+DATA/fsczrac/datafile/undotbs1.258.9674756413ONLINE+DATA/fsczrac/datafile/sysaux.257.9674756412ONLINE+DATA/fsczrac/datafile/system.256.9674756411SYSTEM+DATA/fsczrac/datafile/undotbs2.269.9674758315ONLINE+DATA/fsczrac/datafile/datafsczracdatafilefinance.dbf6ONLINE6rowsselected.SQL>