After a long time, I encountered the good old, very familiar FRA error in one of my older database which is not production critical but still quite an important one so I thought to refresh this space with this experience. To job your memory about FRA, the fast recovery area (FRA) is an Oracle-managed directory, file system, or Oracle Automatic Storage Management disk group that provides a centralized storage location for backup and recovery files. Oracle creates archived logs and flashback logs in the fast recovery area.
So this is the error I got in my alert log file:
Tue Mar 07 05:41:20 2023
Errors in file /preprod/opt/oracle11g/diag/rdbms/preprod01/preprod01/trace/preprod01_m000_9634.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 214748364800 bytes is 85.65% used, and has 30825371648 remaining bytes available.
--
And Here database stopped working
Tue Mar 07 05:48:20 2023
Errors in file /preprod/opt/oracle11g/diag/rdbms/preprod01/preprod01/trace/preprod01_arc3_7394.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 214748364800 bytes is 100.00% used, and has 0 remaining bytes available.
--
It then alerted every 5 minutes until sometime.
Tue Mar 07 05:59:20 2023
Errors in file /preprod/opt/oracle11g/diag/rdbms/preprod01/preprod01/trace/preprod01_arc1_7390.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 214748364800 bytes is 100.00% used, and has 0 remaining bytes available.
--
Database was then shutdown immediate
Tue Mar 07 06:10:00 2023
Shutting down instance (immediate)
Tue Mar 07 06:11:00 2023
Instance shutdown cancelled
Tue Mar 07 06:12:00 2023
Shutting down instance (abort)
Database was started here.
Tue Mar 07 06:15:00 2023
Starting ORACLE instance (normal)
Still archiving errors.....
Instance terminated by USER, pid = 5826
Tue Mar 07 06:15:00 2023
Starting ORACLE instance (normal)
Tue Mar 07 06:15:00 2023
Shutting down instance (immediate)
Tue Mar 07 06:16:00 2023
Starting ORACLE instance (normal)
Tue Mar 07 06:17:00 2023
db_recovery_file_dest_size of 358400 MB is 57.53% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Current state:
SQL> /
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
-------------------- ------------------ ------------------------- ---------------
CONTROL FILE 0 0 0
REDO LOG 0 0 0
ARCHIVED LOG 60.62 0 561
BACKUP PIECE 0 0 0
IMAGE COPY 0 0 0
FLASHBACK LOG 2.27 .28 20
FOREIGN ARCHIVED LOG 0 0 0
7 rows selected.
All good here. Happy days.
No comments:
Post a Comment