Oracle报错处理(ORA19816 )

2023年 8月 15日 24.9k 0

目录

  • 一、报错信息
  • 二、oracle官网查询
  • 三、解决方案

一、报错信息

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进行解决。

相关文章

Oracle如何使用授予和撤销权限的语法和示例
Awesome Project: 探索 MatrixOrigin 云原生分布式数据库
下载丨66页PDF,云和恩墨技术通讯(2024年7月刊)
社区版oceanbase安装
Oracle 导出CSV工具-sqluldr2
ETL数据集成丨快速将MySQL数据迁移至Doris数据库

发布评论