ORA-19815

最新推荐文章于 2024-10-09 08:00:00 发布

doing13826400396

最新推荐文章于 2024-10-09 08:00:00 发布

阅读量130

点赞数

分类专栏： oracle管理文章标签： Flash OS UP

本文链接：https://blog.youkuaiyun.com/doing13826400396/article/details/83803343

版权

oracle管理专栏收录该内容

8 篇文章

订阅专栏

[quote]

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