转 ORA-16191 "Primary log shipping client not logged on standby
###sample 0
原因未知:
解决办法,重建密码文件
primary db :
alter system set log_archive_dest_state_2=defer sid='*' scope=both;
standby db
db:
su - db
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
in primary
mv orapwdb1 orapwdb1.bak
orapwd file=orapwdb1 password=manager entries=100 ignorecase=Y
mv orapwdb2 orapwdb2.bak
orapwd file=orapwdb2 password=manager entries=100 ignorecase=Y
SQL> alter user sys identified by manager;
in standby
mv orapwdb1 orapwdb1.bak
orapwd file=orapwdb1 password=manager entries=100 ignorecase=Y
mv orapwdb2 orapwdb2.bak
orapwd file=orapwdb2 password=manager entries=100 ignorecase=Y
db:
alter database recover managed standby database using current logfile disconnect from session;
primary db :
alter system set log_archive_dest_state_2=ENABLE sid='*' scope=both;
相关文章
- application pool can not write to event log
- flutter 日志输出,Flutter打印日志,flutter log,flutter 真机日志
- English trip V1 - B 21. On a busy day 忙碌的一天 Teacher:Taylor Key: at on in
- UE4 Run On Server与Run on owning client
- Eclipse 出现Some sites could not be found. See the error log for more detail.错误 解决方法
- Android如何让真机显示debug log的调试信息
- 【kafka源码】/log_dir_event_notification的LogDir脱机事件通知
- remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on Redhat and derivates it is ncurses-devel.
- 转 FAL[server, ARC3]: FAL archive failed Error 16401 creating standby archive log file at host
- archive log full ora-00257
- [Oracle 工程师手记] 如何构造数据库的 log on trigger
- 用python做测试实现高性能测试工具(5)—多进程写log
- The incident LOST_EVENTS occured on the master. Message: error writing to the binary log, Error_code
- Apexsql log最佳实践
- sql server事务日志解析工具(开源,类似apexsql log)
- spring-cloud导入eclipse时,@slf4j注解为什么找不到log变量
- Discrete Log Algorithms :Baby-step giant-step