ORA-19815: WARNING: db_recovery_file_dest_size of 36676042752 bytes is 100.00% used

最新推荐文章于 2023-03-25 15:20:54 发布

rgb_rgb

最新推荐文章于 2023-03-25 15:20:54 发布

阅读量3.1k

点赞数

CC 4.0 BY-SA版权

分类专栏： ora

本文链接：https://blog.youkuaiyun.com/rgb_rgb/article/details/8736267

ora 专栏收录该内容

41 篇文章

订阅专栏

本文讨论了Oracle数据库中出现的警告信息，提示db_recovery_file_dest_size大小已达到100%，并提供了多种解决方案来解决空间不足的问题，包括调整参数、备份文件到次级设备、增加磁盘空间等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Fri Mar 29 13:25:48 2013
Errors in file /u01/app/oracle/diag/rdbms/sg01/sgerp5/trace/sgerp5_m000_15862.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 36676042752 bytes is 100.00% used, and has 0 remaining bytes available.
************************************************************************
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.
************************************************************************

show parameter db_recovery_file_dest_size

可以通过修改过db_recovery_file_dest_size，把其值改大些。
SQL> alter system set db_recovery_file_dest_size=50G scope=spfile;
重启数据库

set pagesize 53
set linesize 1024
set feedback on
set verify off
set timing on
set trimout on
set trimspool on

col name format a12
col quota format 99999999999990.99
col used for 99999999999990.99
col reclaimable format 99999999999990.99
col files format 990.99

SELECT substr(name, 1, 30) name, space_limit AS quota,
space_used AS used,
space_reclaimable AS reclaimable,
number_of_files AS files
FROM v$recovery_file_dest;