ORA-01157: cannot identify/lock data file 2 - see DBWR trace file ORA-01110: data file 2: '/home/oracle/oradata/esal/undotbs01.dbf' 6将undotbs01离线; SQL> alter database datafile '/home/oracle/oradata/esal/undotbs01.dbf' offline drop; Database altered. SQL> alter database open; D...
ORA-01110: data file 2: '/u01/app/oracle/oradata/orcl/undotbs01.dbf' 解决方案如下: 1.删除表空间文件与创建表空间文件 SQL> alter database datafile '/u01/app/oracle/oradata/orcl/undotbs01.dbf' offline drop; Database altered. SQL> alter database open 2 ; Database altered. SQL> create ...
ls -l /path/to/your/oracle/datafiles 使用SQL查询数据库文件的状态和路径: sql SELECT FILE_NAME, STATUS FROM DBA_DATA_FILES; SELECT FILE_NAME FROM V$CONTROLFILE; 检查文件权限: 确保Oracle数据库运行的用户(如oracle用户)具有对数据库文件的读取和写入权限。 bash ls -l /path/to/your/oracle/data...
SQLPLUS>ALTER DATABASE DATAFILE 2,3,4,5,6,7,8,9,10,11,12 ONLINE; 数据库已更改。 打开数据库。 SQLPLUS>ALTER DATABASE OPEN RESETLOGS; 数据库已更改。 查看V$DATAFILE,文件状态已经是ONLINE了。 TS# FILE# NAME STATUS CHECKPOINT_CHANGE# --- --- --- --- --- 0 1 E:\ORACLE9I\ORA9I\SYS...
sql>alter database open; RA-01157: 无法标识/锁定数据文件 10 - 请参阅 DBWR 跟踪文件ORA-01110: 数据文件 10: 'D:\ORACLE\ORADATA\ORCL\USERS02.DBF' 解决过程如下: 1. startup mount 2. alter database open ORA-01157: cannot identify/lock data file 10 - see DBWR trace file ...
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file ORA-01110: data file 5: '/data2/PMS_DATA.dbf' 問題解決如下: [oracle@Pyzs-DB-Test3 oracle]$ sqlplus /nolog SQL*Plus: Release 9.2.0.6.0 - Production on Wed Jul 25 08:53:17 2007 ...
ORA-01110: data file 21: '/U01/app/oracle/oradata/TEST/TEST_new_index04.dbf' 看问题提示无法读取21号文件,根据错误可以基本判断出来应该是文件在offline状态。 查看数据文件的状态,可以看到21号文件TEST_new_index04.dbf 目前是在RECOVER状态。
/u01/app/oracle/oradata/orcl/system01.dbf 2 /u01/app/oracle/oradata/orcl/sysaux01.dbf 3 /u01/app/oracle/oradata/orcl/undotbs01.dbf FILE# --- NAME --- 4 /u01/app/oracle/oradata/orcl/users01.dbf 5 /u01/app/oracle/oradata/orcl/users02.dbf SQL> alter database datafile 5 offline;...
jeanron@TEST> select file_name,status,online_status from dba_data_files; FILE_NAME STATUS ONLINE_ --- --- --- /U01/app/oracle/oradata/TEST/TE
ALTER DATABASE DATAFILE 2 ONLINE * ERROR 位于第 1 行: ORA-01190: 控制文件或数据文件2来自于最后一个 RESETLOGS 之前 ORA-01110: 数据文件 2: 'E:\ORACLE9I\ORA9I\UNDOTBS01.DBF' 接下来由于VDATAFILE中的CHECKPOINT_CHANGE#仍然大于VDATAFILE中的CHECKPOINT_CHANGE#仍然大于VRECOVER_FILE中的CHANGE#,决定用...