ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Archiving not possible: No primary destinations errors

Archiving not possible: No primary destinations errors

Linux操作系统 作者:season0891 时间:2017-09-11 17:01:13 0 删除 编辑
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 the reopen parameter. 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/90618/viewspace-2144804/,如需转载,请注明出处,否则将追究法律责任。

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

注册时间:2008-06-10

  • 博文量
    791
  • 访问量
    1939115