db_recovery_file_dest_size空间满的问题

db_recovery_file_dest_size空间满的问题

2011-11-25 13:35

db_recovery_file_dest_size空间满的问题  

2010-12-30 09:49:12|  分类：rman及归档|  标签：|字号大中小 

查询应用空间:

select * from v$recovery_file_dest;

select * from v$flash_recovery_area_usage;

方法一:

>rman target /

RMAN> crosscheck archivelog all;

RMAN> delete expired archivelog all;

RMAN> delete noprompt obsolete;

法二:

备份:RMAN> backup recovery area;

法三:

把归档职位 寄放到比拟 大的磁盘

法四:

增进db_recovery_file_dest_size巨细

alter system set db_recovery_file_dest_size=4G scope=both;

法五：指定retention计策。

RMAN>configure retention policy to recovery window of 7 days;

RMAN>configure retention policy to redundancy 3;