暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

ORA-19816报错处理

原创 redgame 2023-08-28
390

一、报错信息
Attempt to switch log for thread 1 failed. reason: 3
Errors in file smon_3776.trc:
ORA-19816: WARNING: Files may exist in db_recovery_file_dest that are not known to database.
*************************************************************
WARNING: Files created after time 08/02/2023 06:09:16 may exist in
db_recovery_file_dest that is not known to the database.
Use the RMAN command CATALOG RECOVERY AREA to re-catalog
any such files. If files cannot be cataloged, then manually
delete them using OS command. This is most likely the
result of a crash during file creation.
二、oracle官网查询
ORA-19816: WARNING: Files May Exist In Db_recovery_file_dest That Are Not Known To Database (Doc ID 2829842.1) To BottomTo Bottom
三、解决方案
1. Fix the hung I/O to NFS issue.
2. Manually delete these files using an OS command.
3. Re-execute the RMAN 'catalog recovery area' command.
我使用catalog recovery area进行解决。

「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论