博客

archive log 日志已满

ORA-00257: archiver error. Connect internal only, until freed 错误的处理方法

1. 用sys用户登录


sqlplus

sys/pass@tt

as sysdba

2. 看看archiv log所在位置


SQL> show parameter log_archive_dest;

NAME                                     TYPE        VALUE

———————————— ———– ——————————

log_archive_dest                   string

log_archive_dest_1               string

log_archive_dest_10             string

3. 一般VALUE为空时，可以用archive log list;检查一下归档目录和log sequence


SQL> archive log list;

Database log mode                 Archive Mode

Automatic archival                   Enabled

Archive destination                  USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     360

Next log sequence to archive  360

Current log