oracle归档日志满

rman target / nocatalog
RMAN>list archivelog all;
RMAN>crosscheck archivelog all;
delete archivelog until time ‘sysdate -30’; --删除一个月之前的日志
delete expired archivelog all;–删除过期日志

查询闪回区的大小
select * from v$flash_recovery_area_usage;

SQL> select file_type,PERCENT_SPACE_USED,NUMBER_OF_FILES from v$flash_recovery_area_usage;

FILE_TYPE            PERCENT_SPACE_USED NUMBER_OF_FILES
-------------------- ------------------ ---------------
CONTROL FILE                        .05               1
REDO LOG                             .2               4
ARCHIVED LOG                      65.22            2549
BACKUP PIECE                          0               0
IMAGE COPY                            0               0
FLASHBACK LOG                         0               0
FOREIGN ARCHIVED LOG                  0               0

7 rows selected.