设置还原表空间文件脱机故障

ommitting creation of archivelog 'D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\ARCHIVELOG\2009_09_02\O1_MF_1_479_59VR4KX4_.ARC'
Created Oracle managed file D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\ARCHIVELOG\2009_09_02\O1_MF_1_479_59VR4KX4_.ARC
Wed Sep 02 11:42:07 2009
alter database datafile 7 offline
Wed Sep 02 11:42:07 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_smon_1932.trc:
ORA-00376: file 7 cannot be read at this time
ORA-01110: data file 7: 'D:\TEST\JERRY_UNDO.DBF'

Wed Sep 02 11:42:07 2009
ORA-376 signalled during: alter database datafile 7 offline...
Wed Sep 02 11:42:07 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\udump\myoracle_ora_3064.trc:
ORA-00376: 此时无法读取文件 7
ORA-01110: 数据文件 7: 'D:\TEST\JERRY_UNDO.DBF'
ORA-00376: 此时无法读取文件 7
ORA-01110: 数据文件 7: 'D:\TEST\JERRY_UNDO.DBF'
ORA-00376: 此时无法读取文件 7
ORA-01110: 数据文件 7: 'D:\TEST\JERRY_UNDO.DBF'

Wed Sep 02 11:42:08 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_smon_1932.trc:
ORA-00376: file 7 cannot be read at this time
ORA-01110: data file 7: 'D:\TEST\JERRY_UNDO.DBF'

Wed Sep 02 11:42:09 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_smon_1932.trc:
ORA-00376: file 7 cannot be read at this time
ORA-01110: data file 7: 'D:\TEST\JERRY_UNDO.DBF'

Wed Sep 02 11:42:10 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_smon_1932.trc:
ORA-00376: file 7 cannot be read at this time
ORA-01110: data file 7: 'D:\TEST\JERRY_UNDO.DBF'

Wed Sep 02 11:42:12 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_smon_1932.trc:
ORA-00376: file 7 cannot be read at this time
ORA-01110: data file 7: 'D:\TEST\JERRY_UNDO.DBF'

Wed Sep 02 11:42:22 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_smon_1932.trc:
ORA-00376: file 7 cannot be read at this time
ORA-01110: data file 7: 'D:\TEST\JERRY_UNDO.DBF'

Wed Sep 02 11:42:28 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\udump\myoracle_ora_3212.trc:
ORA-00376: file 7 cannot be read at this time
ORA-01110: data file 7: 'D:\TEST\JERRY_UNDO.DBF'
ORA-00376: file 7 cannot be read at this time
ORA-01110: data file 7: 'D:\TEST\JERRY_UNDO.DBF'

Wed Sep 02 11:42:31 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\udump\myoracle_ora_3064.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00376: file 7 cannot be read at this time
ORA-01110: data file 7: 'D:\TEST\JERRY_UNDO.DBF'
ORA-00376: file 7 cannot be read at this time
ORA-01110: data file 7: 'D:\TEST\JERRY_UNDO.DBF'
ORA-00376: file 7 cannot be read at this time
ORA-01110: data file 7: 'D:\TEST\JERRY_UNDO.DBF'

Wed Sep 02 11:42:33 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_smon_1932.trc:
ORA-00376: file 7 cannot be read at this time
ORA-01110: data file 7: 'D:\TEST\JERRY_UNDO.DBF'

Wed Sep 02 11:42:34 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\udump\myoracle_ora_3248.trc:
ORA-00376: 此时无法读取文件 7
ORA-01110: 数据文件 7: 'D:\TEST\JERRY_UNDO.DBF'
ORA-00376: 此时无法读取文件 7
ORA-01110: 数据文件 7: 'D:\TEST\JERRY_UNDO.DBF'
ORA-00376: 此时无法读取文件 7
ORA-01110: 数据文件 7: 'D:\TEST\JERRY_UNDO.DBF'

Wed Sep 02 11:42:35 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\udump\myoracle_ora_3628.trc:
ORA-00376: file 7 cannot be read at this time
ORA-01110: data file 7: 'D:\TEST\JERRY_UNDO.DBF'
ORA-00376: file 7 cannot be read at this time
ORA-01110: data file 7: 'D:\TEST\JERRY_UNDO.DBF'

Wed Sep 02 11:42:41 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_j000_2244.trc:
ORA-00376: 此时无法读取文件 7
ORA-01110: 数据文件 7: 'D:\TEST\JERRY_UNDO.DBF'
ORA-00376: 此时无法读取文件 7
ORA-01110: 数据文件 7: 'D:\TEST\JERRY_UNDO.DBF'

Wed Sep 02 11:42:43 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_smon_1932.trc:
ORA-00376: file 7 cannot be read at this time
ORA-01110: data file 7: 'D:\TEST\JERRY_UNDO.DBF'

Wed Sep 02 11:42:53 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_smon_1932.trc:
ORA-00376: file 7 cannot be read at this time

 

还原表空间无法脱机

 

还原文件可以脱机，脱机后数据库出现了故障，Session超过连接数。