ORA-19815

引用

ORA-19815: 警告: db_recovery_file_dest_size 字节 (共 2147483648 字节) 已使用 99.58%, 尚有 9054208 字节可用。

Tue Dec 28 16:48:29 2010
*************************************************************
You have the following choices to free up space from
flash recovery area:
1. Consider changing your RMAN retention policy.
   If you are using dataguard, then consider changing your
   RMAN archivelog deletion policy.
2. Backup files to tertiary device such as tape using the
   RMAN command BACKUP RECOVERY AREA.
3. Add disk space and increase the db_recovery_file_dest_size
   parameter to reflect the new space.
4. Delete unncessary files using the RMAN DELETE command.
   If an OS command was used to delete files, then use
   RMAN CROSSCHECK and DELETE EXPIRED commands.
*************************************************************

这里使用Crosscheck删除失效归档;
1.rman target sys/liweiwei@liweiwei as sysdba
2.crosscheck archivelog all;
3.delete expired archivelog all;//命令删除所有过期归档日志:
4.report obsolete;//报告过期备份
5.delete obsolete;//命令删除过期备份
这样数据库就会正常启动了。