数据库归档志满问题解决方案.doc

用户登录时提示 ORA-00257：archiver error. Connect internal only ,util freed 用户登陆的时候提示：ORA-00257: archiver error. Connect internal only, until freed ? 1. 用sys用户登录? sqlplus sys/pass@tt as sysdba2. 看看archiv log所在位置SQL show parameter log_archive_dest;NAME???????????????????????????????????? TYPE??????? VALUE------------------------------------ ----------- ------------------------------log_archive_dest?????????????????? stringlog_archive_dest_1?????????????? stringlog_archive_dest_10???????????? string3. 一般VALUE为空时，可以用archive log list;检查一下归档目录和log sequenceSQL archive log list;Database log mode???????????????? Archive ModeAutomatic archival?????????????????? EnabledArchive destination????????????????? USE_DB_RECOVERY_FILE_DESTOldest online log sequence???? 360Next log sequence to archive? 360Current log sequence????????????? 3624. 检查flash recovery area的使用情况,可以看见archivelog已经很大了，达到96.62SQL select * from V$FLASH_RECOVERY_AREA_USAGE;FILE_TYPE??? PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES------------ ------------------ ------------------------- ---------------CONTROLFILE?????.13??????? 0???????????1ONLINELOG??????2.93??????? 0?????????? 3ARCHIVELOG?????96.62??????? 0???????????141BACKUPPIECE?????0?????????0???????????0IMAGECOPY??????0?????????0???????????0FLASHBACKLOG???? 0?????????0???????????05. 计算flash recovery area已经占用的空间SQL select sum(percent_space_used)*3/100 from v$flash_recovery_area_usage;SUM(PERCENT_SPACE_USED)*3/100-----------------------------???????2.9904???????????????????? ?6. 找到recovery目录, show parameter recoverSQL show parameter recover;NAME??????????????????TYPE??????? VALUE------------------------------------ ----------- ------------------------------db_recovery_file_dest?????????string? /u01/app/oracle/flash_recovery_areadb_recovery_file_dest_size??????big integer?? 5Grecovery_parallelism???????? integer???????? 0??????????????????????7 上述结果告诉我们，归档位置用的是默认值，放在flash_recovery_area下(db_recovery_fil