Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Wednesday, June 26, 2019

ORA-19815: WARNING: db_recovery_file_dest_size

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='*';

No comments:

Post a Comment