ORA-279 signalled during: alter database recover logfile
2019-03-01 11:47 潇湘隐者 阅读(4030) 评论(0) 编辑 收藏 举报
在RMAN的RECOVER还原过程中,RMAN界面正常,但是检查、刷新告警日志,发现告警日志里面有ORA-279,如下所示:
alter database recover logfile '/u06/archivelog/2019_02_19/o1_mf_1_16228_g6oznpbv_.arc'
Thu Feb 21 08:49:48 CST 2019
Media Recovery Log /u06/archivelog/2019_02_19/o1_mf_1_16228_g6oznpbv_.arc
Thu Feb 21 08:50:58 CST 2019
ORA-279 signalled during: alter database recover logfile '/u06/archivelog/2019_02_19/o1_mf_1_16228_g6oznpbv_.arc'...
Thu Feb 21 08:50:59 CST 2019
alter database recover logfile '/u06/archivelog/2019_02_19/o1_mf_1_16229_g6ozp2pv_.arc'
Thu Feb 21 08:50:59 CST 2019
Media Recovery Log /u06/archivelog/2019_02_19/o1_mf_1_16229_g6ozp2pv_.arc
Thu Feb 21 08:51:12 CST 2019
ORA-279 signalled during: alter database recover logfile '/u06/archivelog/2019_02_19/o1_mf_1_16229_g6ozp2pv_.arc'...
Thu Feb 21 08:51:12 CST 2019
alter database recover logfile '/u06/archivelog/2019_02_19/o1_mf_1_16230_g6ozrswb_.arc'
Thu Feb 21 08:51:12 CST 2019
Media Recovery Log /u06/archivelog/2019_02_19/o1_mf_1_16230_g6ozrswb_.arc
Thu Feb 21 08:51:39 CST 2019
ORA-279 signalled during: alter database recover logfile '/u06/archivelog/2019_02_19/o1_mf_1_16230_g6ozrswb_.arc'...
Thu Feb 21 08:51:39 CST 2019
alter database recover logfile '/u06/archivelog/2019_02_19/o1_mf_1_16231_g6ozsj8q_.arc'
Thu Feb 21 08:51:39 CST 2019
Media Recovery Log /u06/archivelog/2019_02_19/o1_mf_1_16231_g6ozsj8q_.arc
Thu Feb 21 08:51:54 CST 2019
ORA-279 signalled during: alter database recover logfile '/u06/archivelog/2019_02_19/o1_mf_1_16231_g6ozsj8q_.arc'...
Thu Feb 21 08:51:54 CST 2019
alter database recover logfile '/u06/archivelog/2019_02_19/o1_mf_1_16232_g6ozt53s_.arc'
Thu Feb 21 08:51:54 CST 2019
Media Recovery Log /u06/archivelog/2019_02_19/o1_mf_1_16232_g6ozt53s_.arc
Thu Feb 21 08:52:13 CST 2019
ORA-279 signalled during: alter database recover logfile '/u06/archivelog/2019_02_19/o1_mf_1_16232_g6ozt53s_.arc'...
Thu Feb 21 08:52:13 CST 2019
alter database recover logfile '/u06/archivelog/2019_02_19/o1_mf_1_16233_g6p6ojcz_.arc'
Thu Feb 21 08:52:13 CST 2019
Media Recovery Log /u06/archivelog/2019_02_19/o1_mf_1_16233_g6p6ojcz_.arc
Thu Feb 21 08:52:46 CST 2019
ORA-279 signalled during: alter database recover logfile '/u06/archivelog/2019_02_19/o1_mf_1_16233_g6p6ojcz_.arc'...
Thu Feb 21 08:52:46 CST 2019
alter database recover cancel
Thu Feb 21 08:52:46 CST 2019
Media Recovery Canceled
Completed: alter database recover cancel
其实这个场景下,告警日志中ORA-279更像是“输出消息”, 而不是“错误信息”,它是在提示需要请求的归档日志才能继续恢复。以前在使用RMAN进行RECOVER时没有留意过这个细节信息。顺便记录一下。以免初次遇到这个提示信息的时候,还以为出现了什么异常或错误。
[root@DB-Server 2019_02_16]$ oerr ora 279
00279, 00000, "change %s generated at %s needed for thread %s"
// *Cause: The requested log is required to proceed with recovery.
// *Action: Please supply the requested log with "ALTER DATABASE RECOVER
// LOGFILE <file_name>" or cancel recovery with "ALTER DATABASE
// RECOVER CANCEL".
Yes, you can ignore the ORA-279s. Treat them as "messages" rather then "errors".
You need to ensure that all archivelogs are being applied by the recovery process.
参考资料:

【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 没有源码,如何修改代码逻辑?
· 一个奇形怪状的面试题:Bean中的CHM要不要加volatile?
· [.NET]调用本地 Deepseek 模型
· 一个费力不讨好的项目,让我损失了近一半的绩效!
· .NET Core 托管堆内存泄露/CPU异常的常见思路
· 微软正式发布.NET 10 Preview 1:开启下一代开发框架新篇章
· 没有源码,如何修改代码逻辑?
· PowerShell开发游戏 · 打蜜蜂
· 在鹅厂做java开发是什么体验
· WPF到Web的无缝过渡:英雄联盟客户端的OpenSilver迁移实战
2018-03-01 Windows平台监听服务无法启动报报TNS-12560 TNS-00530案例
2018-03-01 ORACLE透明网关访问SQL Server配置总结
2016-03-01 Symantec Backup Exec备份作业服务器盘符变更