一、报错信息
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进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。
Oracle RAC ASM 磁盘组满了,无法扩容怎么在线处理?
Lucifer三思而后行
914次阅读
2025-03-17 11:33:53
RAC 19C 删除+新增节点
gh
561次阅读
2025-03-14 15:44:18
Oracle DataGuard高可用性解决方案详解
孙莹
390次阅读
2025-03-26 23:27:33
SQL解析失败跟踪案例分享(Oracle19c)
Rune_DB
369次阅读
2025-03-19 20:30:59
Oracle数据库调整内存应该注意的几个问题
听见风的声音
349次阅读
2025-03-18 09:43:11
墨天轮个人数说知识点合集
JiekeXu
332次阅读
2025-04-01 15:56:03
XTTS跨版本迁移升级方案(11g to 19c RAC for Linux)
zwtian
321次阅读
2025-04-08 09:12:48
Oracle SQL 执行计划分析与优化指南
Digital Observer
287次阅读
2025-04-01 11:08:44
切换Oracle归档路径后,不能正常删除原归档路径上的归档文件
dbaking
276次阅读
2025-03-19 14:41:51
风口浪尖!诚通证券扩容采购Oracle 793万...
Roger的数据库专栏
273次阅读
2025-03-24 09:42:53