ITPub博客

首页 > 数据库 > Oracle > 11g 创建data guard遇到ORA-16191

11g 创建data guard遇到ORA-16191

原创 Oracle 作者:wenaini 时间:2009-04-17 11:53:24 0 删除 编辑

老问题了:ORA-16191+Error 1017

[@more@]

Fri Apr 17 11:07:31 2009
LNS1 started with pid=32, OS id=15442
Thread 1 advanced to log sequence 22 (LGWR switch)
Current log# 1 seq# 22 mem# 0: /db1/oradata/gtavatar/redo01.rdo
Current log# 1 seq# 22 mem# 1: /db2/oradata/gtavatar/redo01a.rdo
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
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
------------------------------------------------------------
Errors in file /usr/u01/app/diag/rdbms/gtavatar/gtavatar/trace/gtavatar_lns1_15442.trc:
ORA-16191: Primary log shipping client not logged on standby
LGWR: Error 16191 creating archivelog file 'avtbjpst'
LNS: Failed to archive log 1 thread 1 sequence 22 (16191)

改了primary的sys密码是不行的,不重启数据库的情况下重新用orapwd创建pwd文件也不行。只能把主库的口令文件传到备库然后rename才可以。

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/79686/viewspace-1020754/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-02-10

  • 博文量
    50
  • 访问量
    183552