Posts tagged: ORA-19815

Feb 18 2011

ORA-19815: WARNING: db_recovery_file_dest_size of bytes is 100.00% used, and has 0 remaining bytes available

ORA-19815: WARNING: db_recovery_file_dest_size of bytes is 100.00% used, and has 0 remaining bytes available
Why the above error messages
1. Flash Recovery Area Full
2. How to Free space when FRA is Full
3. May be your disk will have free space but still you get the above error messages due to manually deleting archive logs in FRA.
Solution:
SQL> select * from v$flash_recovery_area_usage;
SQL> select * from v$recovery_file_dest;
Step 1. Delete unwanted archive log files from disk ( rm/del)
Step 2. Connect to RMAN (rman target / nocatalog)
Step 3. rman> crosscheck archivelog all;
The above command will marks the control file that the archives have been deleted.
Step 4. rman> delete expired archivelog all;
The above command will deletes the log entries identified above.

ORA-19815: WARNING: db_recovery_file_dest_size of bytes is 100.00% used, and has 0 remaining bytes availableWhy the above error messages1. Flash Recovery Area Full2. How to Free space when FRA is Full3. May be your disk will have free space but still you get the above error messages due to manually deleting archive logs in FRA.
Solution:
SQL> select * from v$flash_recovery_area_usage;
SQL> select * from v$recovery_file_dest;
Step 1. Delete unwanted archive log files from disk ( rm/del)

Step 2. Connect to RMAN (rman target / nocatalog)

Step 3. rman> crosscheck archivelog all;

The above command will marks the control file that the archives have been deleted.

Step 4. rman> delete expired archivelog all;

The above command will deletes the log entries identified above.

Alibi3col theme by Themocracy