1错误:
ORA-16038: log 2 sequence# 5589 cannot be archived
ORA-19809: limit exceeded for recovery file
ORA-00312: online log 2 thread 1: "F:ORACLEPRODUCT10.1.0ORADATADBEVBAREDO02.LOG"
ORA-00312: online log 2 thread 1: "F:ORACLEPRODUCT10.1.0ORADATADBEVBAREDO02.LOG"
解决方法:
以sysdba连入,
1.startup mount
2.ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=4G SCOPE=BOTH;
3.alter database open.
数据库就打开了。
DB_RECOVERY_FILE_DEST_SIZE建库的时候用的默认设置,闪回恢复区应该是2G,空间被占满了以后就无法再归档了。
阅读(552) | 评论(0) | 转发(0) |