Friday, November 18, 2011

ORA-19815: db_recovery_file_dest_size full

Friday, November 18, 2011 Posted by Andre Broers , , , 3 comments
Ever get these errrors because no backup is scheduled?

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

THE FOLLOWING SOLLUTION WILL DELETE ALL ARCHIVELOGS. WHEN ON A PRODUCTION MACHINE (DON'T DO THIS!!!)
rman target system/<password>
RMAN> delete force archivelog all;

Happy Oracleing

3 comments: