- 论坛徽章:
- 0
|
找到问题的原因了
9i中若dg的remove archive stuck卡住可能即便在Max Performance最大性能模式下也会导致Primary database 主库的local archive 本地归档无法正常进行, 进而导致Primary db hang挂起。
For 9iR2 (9.2.0.5 and above):
_log_archive_callout=’LOCAL_FIRST=TRUE’
–OR–
alter system set “_LOG_ARCHIVE_CALLOUT”=’LOCAL_FIRST=TRUE’ scope=both;
In Oracle 10g, this parameter is replaced by ‘log_archive_local_first’, which defaults to TRUE.
In Oracle 11g, ‘log_archive_local_first’ has been deprecated.
这个隐藏参数可以控制ARCH归档进程优先完成本地归档local archive工作,这样就避免了本地重做日志长期无法归档造成数据库无响应。
|
|