我上午做测试,大批量的插入数据,测试双核CPU的运行情况,由于时间过长,我监控了10几分钟,之后我就手动停止了,造成:
Sun Oct 11 23:20:19 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_arc1_1372.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 47716352 bytes disk space from 4294967296 limit
ARC1: Error 19809 Creating archive log file to 'D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2009_10_11\O1_MF_1_93_U_.ARC'
ARC1: Failed to archive thread 1 sequence 93 (19809)
ARCH: Archival stopped, error occurred. Will continue retrying
Sun Oct 11 23:20:19 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_arc1_1372.trc:
ORA-16038: log 2 sequence# 93 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG'
所以数据库才打不开
SQL> alter database open;
alter database open
*
第 1 行出现错误:
ORA-16014: 日志 2 的序列号 93 未归档, 没有可用的目的地
ORA-00312: 联机日志 2 线程 1:
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG'
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13571112/viewspace-616273/,如需转载,请注明出处,否则将追究法律责任。