ORA-01157: cannot identify/lock data file 1 - see DBWR trace file

最新推荐文章于 2025-09-09 13:51:03 发布

原创最新推荐文章于 2025-09-09 13:51:03 发布 · 3.3k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #oracle

DBA 专栏收录该内容

1073 篇文章

订阅专栏

该博客记录了一次Oracle数据库启动过程中遇到的问题，包括PRCR-1079错误、CRS-5017错误，原因在于无法锁定数据文件system.259.1086602859，导致资源action失败。文章详细展示了错误日志和数据文件检查，最后提到磁盘组丢失。解决策略可能涉及数据恢复和资源重新配置。

部署运行你感兴趣的模型镜像

#srvctl start database -d xiqu
PRCR-1079 : Failed to start resource ora.xiqu.db
CRS-5017: The resource action "ora.xiqu.db start" encountered the following error: 
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '+TEST/xiqu/datafile/system.259.1086602859'
. For details refer to "(:CLSN00107:)" in "/opt/grid/products/11.2.0/log/wqqone2/agent/crsd/oraagent_oracle//oraagent_oracle.log".

CRS-5017: The resource action "ora.xiqu.db start" encountered the following error: 
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '+TEST/xiqu/datafile/system.259.1086602859'
. For details refer to "(:CLSN00107:)" in "/opt/grid/products/11.2.0/log/wqqone1/agent/crsd/oraagent_oracle//oraagent_oracle.log".

CRS-2674: Start of 'ora.xiqu.db' on 'wqqone2' failed
CRS-2674: Start of 'ora.xiqu.db' on 'wqqone1' failed
CRS-2632: There are no more servers to try to place resource 'ora.xiqu.db' on that would satisfy its placement policy

17:09:32 idle xiqu2>startup
ORACLE instance started.

Total System Global Area 1.6803E+10 bytes
Fixed Size		    2269992 bytes
Variable Size		 6174018776 bytes
Database Buffers	 1.0603E+10 bytes
Redo Buffers		   23031808 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '+TEST/xiqu/datafile/system.259.1086602859'

17:15:00 idle xiqu2>select file#,ts#,name from v$datafile;

     FILE#	  TS# NAME
---------- ---------- --------------------------------------------------
	 1	    0 +TEST/xiqu/datafile/system.259.1086602859
	 2	    1 +TEST/xiqu/datafile/sysaux.258.1086602863
	 3	    2 +TEST/xiqu/datafile/undotbs1.256.1086602865
	 4	    4 +TEST/xiqu/datafile/undotbs2.265.1086602867
	 5	    5 +TEST/xiqu/datafile/users.261.1086602825
	 6	    2 +TEST/xiqu/datafile/undotbs1.268.1086602847
	 7	    4 +TEST/xiqu/datafile/undotbs2.257.1086602849
	 8	    6 +TEST/xiqu/datafile/test.267.1086602853
	 9	    8 +TEST/xiqu/datafile/directory.263.1086602869
	10	    9 +TEST/xiqu/datafile/tbs1.266.1086602839
	11	   10 +TEST/xiqu/datafile/tbs_shoe.262.1086602869
	12	   10 +TEST/xiqu/datafile/tbs_shoe.264.1086602867
	13	   11 +TEST/xiqu/datafile/spatest.260.1086602855

13 rows selected.

沃日，磁盘组没了！！！

ASMCMD> cd +TEST/xiqu/datafile/
ASMCMD-8001: diskgroup 'TEST' does not exist or is not mounted
ASMCMD> lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512   4096  1048576      6143     5518                0            5518              0             Y  OCRVOTE/
MOUNTED  NORMAL  N         512   4096  1048576   1829376   497600           457344           20128              4             N  SSDDG/