现象:

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-16014: log 3 sequence# 4 not archived, no available destinations
ORA-00312: online log 3 thread 1: '/oracle/oradata/orcl/redo03.log'

告警日志中:
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive thread 1 sequence 4 (4)

这是归档日志空间问题解决后的遗留问题,解决:
SQL> show parameter arch

NAME                                 TYPE        VALUE
———————————— ———– ——————————
archive_lag_target                   integer     0
log_archive_config                   string
log_archive_dest                     string
log_archive_dest_1                   string      LOCATION=/archlog
log_archive_dest_10                  string

SQL> alter system set log_archive_dest_1='/archlog reopen=5' scope=both;
alter system set log_archive_dest_1='/archlog reopen=5' scope=both
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE

shutdown immediate
cp spfileorcl.ora initorcl.ora
vi initorcl.ora
删除加密行,修改*.log_archive_dest_1='LOCATION=/archlog reopen=5'
使用修改过的参数文件启动:
startup pfile=initorcl.ora
create spfile from pfile;
SQL> shutdown immediate
SQL> startup

附:
reopen
REOPEN[=seconds]
Specifies the minimum number of seconds before the archiver processes (ARCn) or the log writer process (LGWR) should try again to access a previously failed destination. The default is 300 seconds
 




Related posts

coded by nessus
分享:  DeliciousGReader鲜果豆瓣CSDN网摘
Trackback

only 1 comment untill now

  1. austria@holders.timidly” rel=”nofollow”>.…

    áëàãîäàðåí!!…

Add your comment now

无觅相关文章插件