ORA-19815: WARNING: %s of %s bytes is %s%% used, and has %s remaining bytes available.

I got ” ORA-19815: WARNING: %s of %s bytes is %s%% used, and has %s remaining bytes available. ”  error in Oracle database.

 ORA-19815: WARNING: %s of %s bytes is %s%% used, and has %s remaining bytes available.

Details of error are as follows.

ORA-19815: WARNING: %s of %s bytes is %s%% used, and has %s 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

WARNING: %s of %s bytes is %s%% used, and has %s remaining bytes available

This ORA-19815 is related with the DB_RECOVERY_FILE_DEST is running out of disk space.

To solve this error, perform the following steps.

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

Delete expired and the older archivelog and backups as follows.

RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;
RMAN> crosscheck backup;
RMAN> delete expired backup;
RMAN> delete noprompt archivelog until time 'sysdate -1'; 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )