导航：首页 > 数据库 >

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

发表于：2025-02-03 作者：千家信息网编辑

千家信息网最后更新 2025年02月03日，SQL> select * from V$FLASH_RECOVERY_AREA_USAGE;FILE_TYPE PERCENT_SPACE_USED ------------------------

千家信息网最后更新 2025年02月03日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_reco very_area db_recovery_file_dest_size big integer 4182M SQL> select sum(percent_space_used)*3/100 from v$flash_recovery_area_usage;
SUM(PERCENT_SPACE_USED)*3/100 ----------------------------- 2.8524
9. 检查一些无用的archivelog RMAN> crosscheck archivelog all; 10. 删除过期的归档 RMAN> delete expired archivelog all;
RMAN> DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7'; 再次查看 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 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.

很赞哦！