Oracle数据库 加入小组

60个成员 56个话题 创建时间:2021-01-15

【故障处理】ora-19815导致归档日志满的相关报错记录

发表于2021-08-16 1992次查看

当告警日志中出现ora-19815的报错时,说明快速恢复区已经被占满,同时归档日志也由于默认使用快速恢复区而不发生产新的归档日志。

此时,数据库的表现为,执行任何操作都会hang住。

Thu Jun 03 21:44:55 2021
************************************************************************
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
   then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
   BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
   reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
   system command was used to delete files, then use RMAN CROSSCHECK and
   DELETE EXPIRED commands.
************************************************************************
ARC0: Error 19809 Creating archive log file to 'D:\APP\ORACLE\FAST_RECOVERY_AREA\ORCL\ARCHIVELOG\2021_06_03\O1_MF_1_360_%U_.ARC'
Thu Jun 03 21:44:55 2021
Errors in file D:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_arc1_9444.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 8589934592 bytes is 100.00% used, and has 0 remaining bytes available.
Thu Jun 03 21:44:55 2021
************************************************************************
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
   then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
   BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
   reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
   system command was used to delete files, then use RMAN CROSSCHECK and
   DELETE EXPIRED commands.
************************************************************************
ARC1: Error 19809 Creating archive log file to 'D:\APP\ORACLE\FAST_RECOVERY_AREA\ORCL\ARCHIVELOG\2021_06_03\O1_MF_1_361_%U_.ARC'
Thu Jun 03 21:44:55 2021
Errors in file D:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_arc0_2188.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 8589934592 bytes is 100.00% used, and has 0 remaining bytes available.
Thu Jun 03 21:44:55 2021
Errors in file D:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_arc3_11112.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 8589934592 bytes is 100.00% used, and has 0 remaining bytes available.
Thu Jun 03 21:44:55 2021
************************************************************************
Thu Jun 03 21:44:55 2021
************************************************************************
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
   then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
   BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
   reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
   system command was used to delete files, then use RMAN CROSSCHECK and
   DELETE EXPIRED commands.
************************************************************************
ARC3: Error 19809 Creating archive log file to 'D:\APP\ORACLE\FAST_RECOVERY_AREA\ORCL\ARCHIVELOG\2021_06_03\O1_MF_1_360_%U_.ARC'
Thu Jun 03 21:44:56 2021
Errors in file D:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_arc1_9444.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 8589934592 bytes is 100.00% used, and has 0 remaining bytes available.
Thu Jun 03 21:44:56 2021
************************************************************************
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
   then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
   BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
   reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
   system command was used to delete files, then use RMAN CROSSCHECK and
   DELETE EXPIRED commands.
************************************************************************
ARC1: Error 19809 Creating archive log file to 'D:\APP\ORACLE\FAST_RECOVERY_AREA\ORCL\ARCHIVELOG\2021_06_03\O1_MF_1_360_%U_.ARC'
Thu Jun 03 21:44:56 2021
Errors in file D:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_arc3_11112.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 8589934592 bytes is 100.00% used, and has 0 remaining bytes available.
Thu Jun 03 21:44:56 2021
************************************************************************
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
   then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
   BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
   reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
   system command was used to delete files, then use RMAN CROSSCHECK and
   DELETE EXPIRED commands.
************************************************************************
ARC3: Error 19809 Creating archive log file to 'D:\APP\ORACLE\FAST_RECOVERY_AREA\ORCL\ARCHIVELOG\2021_06_03\O1_MF_1_360_%U_.ARC'
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
   then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
   BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
   reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
   system command was used to delete files, then use RMAN CROSSCHECK and
   DELETE EXPIRED commands.
************************************************************************
Thu Jun 03 21:44:56 2021
ARC0: Error 19809 Creating archive log file to 'D:\APP\ORACLE\FAST_RECOVERY_AREA\ORCL\ARCHIVELOG\2021_06_03\O1_MF_1_361_%U_.ARC'
Thu Jun 03 21:44:57 2021
Errors in file D:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_arc1_9444.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 8589934592 bytes is 100.00% used, and has 0 remaining bytes available.
Thu Jun 03 21:44:57 2021
   reflect the new space.

此故障比较简单,目的更多是为了记录一下报错情况。

发表回复
你还没有登录,请先 登录或 注册!