ORA-01115 IO error reading block from file string (block # string)Cause: The device on which the file resides is probably off line.Action: Restore access to the device, then retry the operation.
alter database datafile 'F:\ORCLDATA\DATA01.DAT' offline drop; 错误:除非使用了介质恢复,否则不允许紧急脱机
如果是归档数据库,使用 alter database datafile 'F:\ORCLDATA\DATA01.DAT' offline;
svrmgrl>connect internal
svrmgrl>startup mount
svrmgrl>alter database datafile 'F:\ORCLDATA\DATA01.DAT' offline drop;
svrmgrl>alter database open;
错误:除非使用了介质恢复,否则不允许紧急脱机
alter database datafile 'F:\ORCLDATA\DATA01.DAT' offline;
svrmgrl>connect internal
svrmgrl>startup mount
svrmgrl>alter database datafile 'F:\ORCLDATA\DATA01.DAT' offline drop;
svrmgrl>alter database open;