ORA-16191 错误导致无法连接DATA GUARD环境
2010-6-8
在一个通过DUPLICATE命令搭建的10G DATAGUARD环境, 发现日志无法通过redo transfort 服务来传递。查看主库日志看到有报错:
按照提示,检查了主备库的remote_login_passwordfile 参数都是EXCLUSIVE;
Tue Jun 8 01:09:45 2010
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
|
还有一个检查项目就是SYS的密码是否一致;
回想起在一个密码是change_on_install,而另外一个是manager。
先把备库的停掉,
alter database managed standby database cancel;
shutdown immediate ;
重新创建密码文件,确保和主库的密码是一致的。
重新启动备库,再进行验证日志是否可以传递。
在备库日志中发现已经连接上的信息:
Tue Jun 8 01:17:46 2010
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[1]: Assigned to RFS process 1384702
RFS[1]: Identified database type as 'physical standby'
Tue Jun 8 01:17:46 2010
RFS LogMiner: Client disabled from further notification
Tue Jun 8 01:17:46 2010
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[2]: Assigned to RFS process 503838
RFS[2]: Identified database type as 'physical standby'
Tue Jun 8 01:17:46 2010
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[3]: Assigned to RFS process 1294560
RFS[3]: Identified database type as 'physical standby'
|
在主库上进行插入数据,进行日志切换,检查日志是否应用到了备库;
把备库打开到只读模式,检查新的数据是否存在。
一切都正常。
问题解决。
PS: 在9I时,日志传送的信息是写到主库的alert日志中的,但到了10G后,这个信息改写到了备库的alert日志上。
-THE END-
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/40239/viewspace-664736/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/40239/viewspace-664736/