Error:ORA-19815: WARNING: db_recovery_file_dest_size of 429496729600 bytes is 100.00% used, and has 0 remaining bytes available.
Solution:
col name format a32
col size_mb format 999,999,999
col used_mb format 999,999,999
col pct_used format 999
select
name,
ceil( space_limit / 1024 / 1024) size_mb,
ceil( space_used / 1024 / 1024) used_mb,
decode( nvl( space_used, 0),0, 0,
ceil ( ( space_used / space_limit) * 100) ) pct_used
from
v$recovery_file_dest
order by
name desc;
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE =600G SCOPE=BOTH;
====
Set linesize 300
col name for a32
col size_m for 999,999,999
col used_m for 999,999,999
col pct_used for 999
SELECT name
, ceil( space_limit / 1024 / 1024) SIZE_M
, ceil( space_used / 1024 / 1024) USED_M
, decode( nvl( space_used, 0),
0, 0
, ceil ( ( space_used / space_limit) * 100) ) PCT_USED,
(space_limit + ((space_limit*20)/100))/1024/1024 as "Next space to ADD(MB)"
FROM v$recovery_file_dest
ORDER BY name;
alter system set db_recovery_file_dest_size=737280M scope=both sid='*';
Solution:
col name format a32
col size_mb format 999,999,999
col used_mb format 999,999,999
col pct_used format 999
select
name,
ceil( space_limit / 1024 / 1024) size_mb,
ceil( space_used / 1024 / 1024) used_mb,
decode( nvl( space_used, 0),0, 0,
ceil ( ( space_used / space_limit) * 100) ) pct_used
from
v$recovery_file_dest
order by
name desc;
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE =600G SCOPE=BOTH;
====
Set linesize 300
col name for a32
col size_m for 999,999,999
col used_m for 999,999,999
col pct_used for 999
SELECT name
, ceil( space_limit / 1024 / 1024) SIZE_M
, ceil( space_used / 1024 / 1024) USED_M
, decode( nvl( space_used, 0),
0, 0
, ceil ( ( space_used / space_limit) * 100) ) PCT_USED,
(space_limit + ((space_limit*20)/100))/1024/1024 as "Next space to ADD(MB)"
FROM v$recovery_file_dest
ORDER BY name;
alter system set db_recovery_file_dest_size=737280M scope=both sid='*';
No comments:
Post a Comment