错误信息:
ORA-16038: log 2 sequence# 1191 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1: '/oradata/orcl/redo02.log'
问题诊断:闪回区的空间被全部占用
解决方法:
--关闭数据库
shutdown immediate;
--启动数据库到mount状态
startup mount;
--打开数据库,确认是否报上述错误信息
alter database open;
--打开未成功,并报上述错误信息,则
select group#,sequence#,archived,status from v$log;
GROUP# SEQUENCE# ARCHIVED STATUS
---------- ---------- --------- ------------------------------------------------
1 1193 NO INACTIVE
3 1194 NO CURRENT
2 1191 NO INACTIVE
--清空闪回区空间,根据查询视图v$log可知,当前活动日志为3号日志组,则此时需要清空2号日志组的
alter database clear unarchived logfile group 2;
--或修改闪回区的大小
alter system set db_recovery_file_dest_size=30g;
--再次打开数据库
alter database open;
ORA-16038: log 2 sequence# 1191 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1: '/oradata/orcl/redo02.log'
问题诊断:闪回区的空间被全部占用
解决方法:
--关闭数据库
shutdown immediate;
--启动数据库到mount状态
startup mount;
--打开数据库,确认是否报上述错误信息
alter database open;
--打开未成功,并报上述错误信息,则
select group#,sequence#,archived,status from v$log;
GROUP# SEQUENCE# ARCHIVED STATUS
---------- ---------- --------- ------------------------------------------------
1 1193 NO INACTIVE
3 1194 NO CURRENT
2 1191 NO INACTIVE
--清空闪回区空间,根据查询视图v$log可知,当前活动日志为3号日志组,则此时需要清空2号日志组的
alter database clear unarchived logfile group 2;
--或修改闪回区的大小
alter system set db_recovery_file_dest_size=30g;
--再次打开数据库
alter database open;