一、报错信息
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进行解决。
