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

本文讨论了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;
评论 4
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值