oracle归档日志满了的处理方法Oracle认证考试

文章作者 100test 发表时间 2009:11:28 16:04:35
来源 100Test.Com百考试题网

"gklt">

　　db_recovery_file_dest_size

　　参考文档 : http://www.eygle.com/archives/2005/03/oracle10gecieif.html

　　1.错误提示:

　　ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 87.41% used, and has 270457856 remaining bytes available.

　　Tue Apr 15 11:35:02 2008

　　************************************************************************

　　You have following choices to free up space from flash recovery area:

　　1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,

　　then consider changing RMAN ARCHIVELOG DELETION POLICY.

　　2. Back up files to tertiary device such as tape using RMAN

　　BACKUP RECOVERY AREA command.

　　3. Add disk space and increase db_recovery_file_dest_size parameter to

　　reflect the new space.

　　4. Delete unnecessary files using RMAN DELETE command. If an operating

　　system command was used to 0delete files, then use RMAN CROSSCHECK and

　　DELETE EXPIRED commands.

　　************************************************************************

　　db_recovery_file_dest_size是指目录 : F:\oracle\product\10.2.0\flash_recovery_area\ ,一般用来存放归档日志(archivelog)和rman的备份集(backupset)

　　默认值一般为2G,但在实际生产库上这个值显然是不够的,我们根据的自己数据库的模式和备份策略来设置这参数的大小,但不管怎样

　　他还是有时候会满的.这就需要我们来解决了.

　　解决方法:

　　1.就是增大db_recovery_file_dest_size 的参数值

　　A.

　　SQL>. show parameter db_recovery_file_dest_size

　　NAME TYPE VALUE

　　------------------------------------ ----------- ------------------------------

　　db_recovery_file_dest_size big integer 2G

　　B.

　　SQL>. alter system set db_recovery_file_dest_size=3G.

　　系统已更改。