1.问题:
发现ora-16014错误,这是由于在线日志归档不了造成的, db_recovery_file_dest_size参数设置小,还有就是归档空间不够
1.1 show parameter db_file_reocvery
1.2(1).检查flash recovery area的使用情况:
select * from v$flash_recovery_area_usage
(2).计算flash recovery area已经占用的空间:
select sum(percent_space_used)*3/100 from v$flash_recovery_area_usage;
(3).也可以通过删除flash recovery area中不必要的备份来释放flash recovery area空间来解决这个问题:
a. delete obsolete;
b. crosscheck backupset;
delete expired backupset;
可以看到,现在archivelog目录是存在的,下面用RMAN执行BACKUP ARCHIVELOG ALL DELETE ALL INPUT命令:
RMAN> run
2> {
3> allocate channel c1 device type disk format '/data/backup/%U';
4> backup archivelog all delete all input;
5> }
[@more@]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28878971/viewspace-1060569/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28878971/viewspace-1060569/