ORA-16191 错误导致无法连接DATA GUARD环境

2010-6-8

在一个通过DUPLICATE命令搭建的10G DATAGUARD环境, 发现日志无法通过redo transfort 服务来传递。查看主库日志看到有报错：

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

按照提示，检查了主备库的remote_login_passwordfile 参数都是EXCLUSIVE；

还有一个检查项目就是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-