环境:redhat linux 5
原来环境:rac + dataguard .
由于dataguard 出现了问题 ,所以需要重建dataguard .
但是在重建过程中出现了以下错误:
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-161
这个是一个典型的密码不一致问题,对于单点来讲是一个很容易解决的问题,只需copy密码文件到备机即可 。
但对于rac而言不完全如此 :
解决方法如下 :
在主库的rac1:
sql> alter user sys identified by "syspassword"
rac2:
sql> alter user sys identified by "syspassword"
然后将生成的密码文件 rac1 ,rac2 上的一个copy到standby上 。
需要重启standby :
sql>alter database recover managed standby database cancel;
sql> shutdown immediate
。。。
sql> startup mount;
sql> alter database recover managed standby database disconnect from session using current logfile;
SQL> select pid,process,status,thread#,sequence# from v$managed_standby;
PID PROCESS STATUS THREAD# SEQUENCE#
---------- ------------------ ------------------------ ---------- ----------
12550 ARCH CONNECTED 0 0
12552 ARCH CONNECTED 0 0
12554 ARCH CLOSING 1 79522
12556 ARCH CONNECTED 0 0
12558 ARCH CONNECTED 0 0
12560 ARCH CONNECTED 0 0
12562 ARCH CONNECTED 0 0
12570 MRP0 APPLYING_LOG 1 79474
12578 RFS IDLE 0 0
12580 RFS IDLE 0 0
12582 RFS IDLE 0 0
PID PROCESS STATUS THREAD# SEQUENCE#
---------- ------------------ ------------------------ ---------- ----------
12584 RFS IDLE 0 0
12625 RFS IDLE 0 0
12627 RFS IDLE 1 79523
12629 RFS IDLE 2 79199
主库rac1:
sql> alter system switch logfile;
rac2:
sql> alter system switch logfile;
rac1 ,rac2 分别查看显示以下标识则正常 :
tail -f alert.log
Thu Mar 6 15:28:13 2014
ARC4: Standby redo logfile selected for thread 1 sequence 79522 for destination LOG_ARCHIVE_DEST_2
Thu Mar 6 15:28:14 2014
LNS: Standby redo logfile selected for thread 1 sequence 79523 for destination LOG_ARCHIVE_DEST_2
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/90618/viewspace-1102389/
,如需转载,请注明出处,否则将追究法律责任。