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

SQL> show parameter log_archive_dest;
SQL> archive log list;
SQL> select * from V$FLASH_RECOVERY_AREA_USAGE;
ARCHIVELOG        96.62            0       141
SQL> 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_area
db_recovery_file_dest_size    big integer  2G

cd $ORACLE_BASE/flash_recovery_area/orcl/archivelog

rman target sys/password
RMAN> 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;