ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 2011.1.13报错。.ORA-00257: archiver error. Connect internal only, until freed.

2011.1.13报错。.ORA-00257: archiver error. Connect internal only, until freed.

原创 Linux操作系统 作者:victorymoshui 时间:2011-05-05 00:12:39 0 删除 编辑
ORA-00257: archiver error. Connect internal only, until freed.
数据库版本10.2.04
连接数据库报
ORA-00257: archiver error. Connect internal only, until freed.错误
 
查看crontab自动备份,发现数据库已经有很多天没有备份了。没有备份说明归档日志一直没有删除,查询dba_data_files数据字典无法成功。
查看actlog:
jldcdb01:/oracle/admin/dcmds01/bdump$ tail -5000 alert_dcmds01.log|pg
************************************************************************
Wed Jan 12 21:04:12 2011
Errors in file /oracle/admin/dcmds01/udump/dcmds01_ora_324346.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 429496729600 bytes is 95.61% used, and has 18860736512 remaining bytes available.
Wed Jan 12 21:04:12 2011
************************************************************************
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.
 
随着时间分秒过去最后归档将快速恢复区涨满。
Thu Jan 13 03:29:24 2011
ORACLE Instance dcmds01 - Archival Error
Thu Jan 13 03:29:24 2011
ORA-16014: log 2 sequence# 37547 not archived, no available destinations
ORA-00312: online log 2 thread 1: '+ORADG/dcmds01/redo02.log'
Thu Jan 13 03:29:24 2011
Errors in file /oracle/admin/dcmds01/bdump/dcmds01_arc0_434230.trc:
ORA-16014: log 2 sequence# 37547 not archived, no available destinations
ORA-00312: online log 2 thread 1: '+ORADG/dcmds01/redo02.log'
Thu Jan 13 03:34:24 2011
ARCH: Archival stopped, error occurred. Will continue retrying
Thu Jan 13 03:34:24 2011
ORACLE Instance dcmds01 - Archival Error
 
 
解决办法:

很明显是db_recovery_file_dest 的空间满了。

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

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

之后手动跑一遍rman备份。一切正常。

收获经验,快速闪回区一定要定期检查。

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

请登录后发表评论 登录
全部评论

注册时间:2009-08-26

  • 博文量
    173
  • 访问量
    303351