[Oracle] ORA-00257: archiver error Connect internal only until freed

1、查看闪回区使用情况

select * from V$FLASH_RECOVERY_AREA_USAGE;

FILE_TYPE            PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
-------------------- ------------------ ------------------------- ---------------
CONTROL FILE                          0                         0               0
REDO LOG                          10.11                         0               2
ARCHIVED LOG                          0                         0               2
BACKUP PIECE                          0                         0               0
IMAGE COPY                            0                         0               0
FLASHBACK LOG                         0                         0               0
FOREIGN ARCHIVED LOG                  0                         0               0

2、计算闪回区使用空间

03:56:25 SYS@ cbi> show parameter recovery;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /u01/app/oracle/fast_recovery_
                                                 area/cbi/
db_recovery_file_dest_size           big integer 10374182400
recovery_parallelism                 integer     0

N为db_recovery_file_dest_size的大小

select sum(percent_space_used)*N/100 from v$flash_recovery_area_usage;

04:00:43 SYS@ cbi> select sum(percent_space_used)*10/100 from v$flash_recovery_area_usage;

SUM(PERCENT_SPACE_USED)*10/100
------------------------------
                         1.011

3、ORA-00257的错误是因为归档太多导致闪回区满了造成的，下面通过rman删除归档

crosscheck archivelog all;
delete archivelog until time 'sysdate'; --删除所有日志
delete force noprompt archivelog all completed before 'sysdate-3'; --删除3天前的归档
delete expired archivelog all;--删除过期日志