Fixing ORA-19815: WARNING: db_recovery_file_dest_size

To fix the problem, we need to either make the flash recovery area larger, or remove some files from it. If you have the enough disk space available, make the recovery area larger. we also have option for changing parameters (i.e archivelogs's locatin, RMAN backup location) which use db_recovery_file_dest to another location for avoiding this type errors, here first opeion just changing db_recovery_file_dest_size:

ORA-19815: WARNING: string of string bytes is string%% used, and has string remaining bytes available.
Cause: DB_RECOVERY_FILE_DEST is running out of disk space.
Action: One of the following:
1. Add disk space and increase DB_RECOVERY_FILE_DEST_SIZE.
2. Backup files to tertiary device using RMAN.
3. Consider changing RMAN retention policy.
4. Consider changing RMAN archivelog deletion policy.
5. Delete files from recovery area using RMAN.

[root@redhat ~]# su - oracle
[oracle@redhat ~]$ sqlplus /nolog

SQL*Plus: Release 11.1.0.6.0 - Production on Tue Jun 8 17:59:49 2004
Copyright (c) 1982, 2007, Oracle. All rights reserved.

SQL> connect /as sysdba
Connected.
SQL> show parameter db_recovery_file_dest_size

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size big integer 2G

SQL> alter system set db_recovery_file_dest_size=10G scope=both;
System altered.

SQL> show parameter db_recovery_file_dest_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size big integer 10G

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area 1523306496 bytes
Fixed Size 1300072 bytes
Variable Size 754977176 bytes
Database Buffers 754974720 bytes
Redo Buffers 12054528 bytes
Database mounted.
Database opened.

SQL> show parameter db_recovery_file_dest_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size big integer 10G
.