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

ORA-01157: cannot identify/lock data file string - see DBWR trace file
Cause: The background process was either unable to find one of the data files or failed to lock it because the file was already in use. The database will prohibit access to this file but other files will be unaffected. However the first instance to open the database will need to access all online data files. Accompanying error from the operating system describes why the file could not be identified.
Action: Have operating system make file available to database. Then either open the database or do ALTER SYSTEM CHECK DATAFILES.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:36

ORA-01157：无法识别/锁定数据文件字符串 - 请参阅DBWR跟踪文件,
.原因：后台进程无法找到其中一个数据文件或无法锁定，因为该文件已在使用。数据库将禁止访问此文件，但其他文件将不受影响。但是第一个实例打开数据库将需要访问所有在线数据文件。操作系统附带的错误描述了无法识别文件的原因。,
.操作：将操作系统make文件提供给数据库。然后打开数据库或执行ALTER SYSTEM CHECK DATAFILES。,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题