ITPub博客

首页 > Linux操作系统 > Linux操作系统 > [转载]ORA-00257: archiver error. Connect internal only, until freed

[转载]ORA-00257: archiver error. Connect internal only, until freed

原创 Linux操作系统 作者:it_wangych 时间:2010-07-21 15:50:57 0 删除 编辑

ORA-00257: archiver error. Connect internal only, until freed.

看alert.log 文件,出现如下:

Sun May 4 11:53:29 2008
ARCH: Archival stopped, error occurred. Will continue retrying
Sun May 4 11:53:29 2008
ORACLE Instance torcl - Archival Error
Sun May 4 11:53:29 2008
ORA-16038: log 1 sequence# 2455 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/torcl/redo01.log'
Sun May 4 11:53:29 2008
Errors in file /u01/app/oracle/admin/torcl/bdump/torcl_arc1_9325.trc:
ORA-16038: log 1 sequence# 2455 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/torcl/redo01.log'
Sun May 4 11:53:30 2008
Errors in file /u01/app/oracle/admin/torcl/bdump/torcl_arc1_9325.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 94.44% used, and has 119342592 remaining bytes available.
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
Archiver process freed from errors. No longe

很明显是db_recovery_file_dest 的空间满了。

执行rman> delete archivelog until time 'sysdate-1' ;

删除不需要的archive log文件。一切OK。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22021749/viewspace-668613/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2009-07-06

  • 博文量
    43
  • 访问量
    80534