ORA-00257:archive log error.connect internal only,until freed.

SQL > 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 0 0 0

ARCHIVED LOG 95.08 0 16

FILE_TYPE PERCENT_SPACE_USED-PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES- -BACKUP PIECE 0 0 0

IMAGE COPY 0 0 0

FLASHBACK LOG 0 0 0

FILE_TYPE PERCENT_SPACE_USED-PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES- -FOREIGN ARCHIVED LOG 0 0 0

7 rows selected. SQL > show parameter db_recovery_file_dest

NAME TYPE-VALUE-db_recovery_file_dest string / picclife/app/oracle/fast_ Recovery_area db_recovery_file_dest_size big integer 4182m SQL > select sum (percent_space_used) * 3Universe 100 from v$flash_recovery_area_usage

SUM (PERCENT_SPACE_USED) * 3Compact 100-2.8524

9. Check for some useless archivelog RMAN > crosscheck archivelog all; 10. Delete expired archive RMAN > delete expired archivelog all

RMAN > DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7'; check SQL > select * from V$FLASH_RECOVERY_AREA_USAGE again

FILE_TYPE PERCENT_SPACE_USED-PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES- -CONTROL FILE 0 0 0

REDO LOG 0 0 0

ARCHIVED LOG 25.82 0 5

FILE_TYPE PERCENT_SPACE_USED-PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES- -BACKUP PIECE 0 0 0

IMAGE COPY 0 0 0

FLASHBACK LOG 0 0 0

FILE_TYPE PERCENT_SPACE_USED-PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES- -FOREIGN ARCHIVED LOG 0 0 0

7 rows selected.