ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 归档目录满或不够用.致数据库down!!

归档目录满或不够用.致数据库down!!

原创 Linux操作系统 作者:wisdomone1 时间:2009-01-07 12:19:25 0 删除 编辑

由于近期项目中数据库出问题比较多:

现摘录如下:

Archiving not possible: No primary destinations errors

上一篇 / 下一篇  2008-10-29 12:25:41 / 个人分类:oracle

If space ran out in an archive destination, after you fix the problem, you may still recieve the following error in your alert_log:

ARC1: Archiving not possible: No primary destinations

A quick way to solve this is to modify your archive destination with thereopenparameter. This parameter specifies the minimum number of seconds before redo transport services should try to reopen a failed destination.


SQL> show parameter log_archive_dest_1


NAME TYPE VALUE
------------------------------------ ------- ------------------------------
log_archive_dest_1 string location=/db/orcl/archive


SQL> alter system set log_archive_dest_1='location=/db/orcl/archive reopen=5' scope=both;

System altered.

Following that modification you should start seeing successful archive messages in your alert_log.

ARC1: Beginning to archive log# 1 seq# 115127
...
ARC0: Completed archiving log# 1 seq# 115127
...


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

请登录后发表评论 登录
全部评论
提供针对oracle初学者及进阶的数据库培训,欢迎大家咨询: 微信: wisdomone 微信公众号: lovedb 工作经历: 中国普天 北京科蓝 北京云和恩墨 北京神州新桥

注册时间:2008-04-04

  • 博文量
    2189
  • 访问量
    11980442