解决Oracle数据库归档日志占满磁盘空间问题

SQL> show parameter log_archive_dest;SQL> archive log list;SQL> select * from V$FLASH_RECOVERY_AREA_USAGE;ARCHIVELOG        96.62            0       141SQL> select sum(percent_space_used)*3/100 from v$flash_recovery_area_usage;

SQL> show parameter recover;db_recovery_file_dest        string      /u01/oracle/flash_recovery_areadb_recovery_file_dest_size    big integer  2G

cd $ORACLE_BASE/flash_recovery_area/orcl/archivelog

rman target sys/passwordRMAN> crosscheck archivelog all;RMAN> delete expired archivelog all;

RMAN> delete archivelog until time “sysdate-1″;

SQL> select * from V$FLASH_RECOVERY_AREA_USAGE;

SQL> alter system set db_recovery_file_dest_size=4G scope=both;