eygle.com - 留言簿 - 回复留言

eygle.com - 留言簿 - 回复留言 - Powered by eYgLe.Com

返回留言簿

回复留言

留言ID:

留言原文:

To:
　　请问，我的数据库进行
set transaction use rollback segment rbs01;
insert into t(bh) values('1');
insert into t(bh) values('2');
然后突然断电，导致回滚数据文件损坏,
SQL> startup
ORACLE instance started.

Total System Global Area 57395228 bytes
Fixed Size75804 bytes
Variable Size17346560 bytes
Database Buffers 39895040 bytes
Redo Buffers77824 bytes
Database mounted.
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: 'D:\ORACLE\ORADATA\LJG\RBS01.DBF'

From: jianw3400
2005.07.05 17:14