如何解决Oracle数据库归档日志占满磁盘空间.docVIP

如何解决Oracle数据库归档日志占满磁盘空间 如何解决Oracle数据库归档日志占满磁盘空间 　　1、数据库不能启动 　　SQL startup 　　ORACLE 例程已经启动。 　　Total System Global Area 289406976 bytes 　　Fixed Size 1248576 bytes 　　Variable Size bytes 　　Database Buffers 197132288 bytes 　　Redo Buffers 7139328 bytes 　　数据库装载完毕。 　　ORA-16038: 日志 2 序列号 44 无法归档 　　ORA-19809: 超出了恢复文件数的限制 　　ORA-00312: 联机日志 2 线程 1: 　　D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG 　　2、查看$ORACLE_HOME\admin\SID\bdump\alert_SID.log日志 　　Thu Feb 19 09:45:33 2009 　　Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_arc1_660.trc: 　　ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 99.95% used, and has 1129472 remaining bytes available. 　　Thu Feb 19 09:45:33 2009 　　Errors in file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_4708.trc: 　　ORA-19815: 警告: db_recovery_file_dest_size 字节 (共 2147483648 字节) 已使用 99.95%, 尚有 1129472 字节可用。 　　Thu Feb 19 09:45:33 2009 　　************************************************************************ 　　You have following choices to free up space from flash recovery area: 　　1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard, 　　Thu Feb 19 09:45:33 2009 　　************************************************************************ 　　then consider changing RMAN ARCHIVELOG DELETION POLICY. 　　2. Back up files to tertiary device such as tape using RMAN 　　You have following choices to free up space from flash recovery area: 　　BACKUP RECOVERY AREA command. 　　3. Add disk space and increase db_recovery_file_dest_size parameter to 　　1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard, 　　reflect the new space. 　　then consider changing RMAN ARCHIVELOG DELETION POLICY. 　　4. Delete unnecessary files using RMAN DELETE command. If an operating 　　system command was used to delete files, then use RMAN CROSSCHECK and 　　2. Back up files to tertiary device such as tape using RMAN 　　DELETE EXPIRED commands. 　　********************