ORA-19804: cannot reclaim 52428800 bytes disk space from 15728640000 bytes limit


SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jan 26 18:50:15 2022

Version 19.3.0.0.0


Copyright (c) 1982, 2019, Oracle.  All rights reserved.



Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0


SQL> ALTER DATABASE FLASHBACK OFF



Above command was taking a long time, then I checked the alert log file and there was following error:


"""

ORA-19809: limit exceeded for recovery files

ORA-19804: cannot reclaim 52428800 bytes disk space from 15728640000 bytes limit

2022-01-26T18:32:55.460673+00:00

Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_tt00_24306.trc:

ORA-19809: limit exceeded for recovery files

ORA-19804: cannot reclaim 52428800 bytes disk space from 15728640000 bytes limit

2022-01-26T18:33:55.875760+00:00

Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_tt00_24306.trc:

ORA-19809: limit exceeded for recovery files

ORA-19804: cannot reclaim 52428800 bytes disk space from 15728640000 bytes limit

"""




Solution: Increase the db_recovery_file_dest_size as following, after this it took a couple of seconds to complete above running command "ALTER DATABASE FLASHBACK OFF"



SQL> select SPACE_USED/1024/1024/1024 "SPACE_USED(GB)" ,SPACE_LIMIT/1024/1024/1024 "SPACE_LIMIT(GB)" from v$recovery_file_dest;


SPACE_USED(GB) SPACE_LIMIT(GB)

-------------- ---------------

    14.6235662      14.6484375


SQL> show parameter db_recovery


NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_recovery_file_dest                string      /u03/app/oracle/fast_recovery_

                                                 area

db_recovery_file_dest_size           big integer 15000M

SQL> 

SQL> alter system set db_recovery_file_dest_size=25G;


System altered.


SQL>  select SPACE_USED/1024/1024/1024 "SPACE_USED(GB)" ,SPACE_LIMIT/1024/1024/1024 "SPACE_LIMIT(GB)" from v$recovery_file_dest;


SPACE_USED(GB) SPACE_LIMIT(GB)

-------------- ---------------

    14.7427135              25



Comments

Post a Comment

Popular posts from this blog

ORA-46697: Keystore password required - create pluggable database pdb1clone from pdb1

  select con_id,name,open_mode from v$pdbs;     CON_ID NAME     OPEN_MODE ---------- -------------------------------------------------------------------------------------------------------------------------------- ---------- 2 PDB$SEED     READ ONLY 3 PDB1     READ WRITE SQL> create pluggable database pdb1clone from pdb1; create pluggable database pdb1clone from pdb1 * ERROR at line 1: ORA-46697: Keystore password required. Solution: If  TDE is configured, you have to supply the keystore password  SQL> CREATE PLUGGABLE DATABASE PDB1clone FROM PDB1  KEYSTORE IDENTIFIED BY password;
Read more

OAM 11.1.2.3 - Bad Oracle Access Manager Request Error After Applying OAM Patch 27373151 + Webgate Patch 27393427 BP 11.1.2.3.180717

After Applying OAM Patch 27373151 + Webgate Patch 27393427 BP 11.1.2.3.180717, when accessing the http resource then it was giving Bad Oracle Access Manager Like when accessing "http://hostname.domain:7779/index.html" we get following message in the logfile "diagnostics/logs/OHS/ohs1/oblog.log" 2018/10/26@15:29:46.68427       1890    1950    WEB     ERROR   0x0000151F      /ade/aime_ngamac_748106/ngamac/src/palantir/commonlib/src/apache2_req_info.cpp:294     ecid^005UIDZfNp87U8ups^h8iX0000SX00001w  rid^0   "WebGate Error Report"  Message^Unable to process the request due to unexpected error.  ReqReq^GET /public/index.html HTTP/1.1  ReqProto^HTTP/1.1       ReqHost^bdrvl-pd-oid01  ReqStatLine^    ReqStatus^200   ReqRawUri^/public/index.html    ReqUri^/public/index.html       ReqFilename^...
Read more