一次rac+dataguard 创建过程遇到密码文件问题

来源：互联网发布：mac下载阿里旺旺编辑：程序博客网时间：2024/06/14 19:42

环境：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

0 0