Archivingnotpossible:Noprimarydestinationserrors

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
...


名称栏目:Archivingnotpossible:Noprimarydestinationserrors
当前地址:http://bzwzjz.com/article/pjhidh.html

其他资讯

Copyright © 2007-2020 广东宝晨空调科技有限公司 All Rights Reserved 粤ICP备2022107769号
友情链接: 成都网站制作 手机网站制作 营销型网站建设 企业网站设计 成都网站设计制作公司 成都网站设计 企业网站设计 成都企业网站建设 成都网站建设 响应式网站设计 成都网站设计 成都网站制作 响应式网站设计 响应式网站建设 手机网站制作 成都网站制作 重庆企业网站建设 成都响应式网站建设公司 网站制作 成都网站建设 重庆网站制作 重庆手机网站建设