ORA-19815: WARNING db_recovery_file_dest_size of xxx is yyy% used...
RMAN and/or the archiver is running out or IS out of space on the db_recovery_file_dest. If you remove files from that location with OS commands, remember to crosscheck and delete expired files from within RMAN. If that still doesn't resolve the problem, you may need to increase the db_recovery_file_dest_size.
If you started the database with an spfile, then
alter system set db_recovery_file_dest_size=zzzG scope=both;
should fix you right up, assuming of course, you HAVE zzz GB available.
Links:
http://www.eygle.com/archives/2005/12/oracle_diagnost_howto_deal_ora-19815.html
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment