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博客

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

Archiving not possible: No primary destinations errors

最新文章