感谢各位的关注,已经搞定了。是密码文件的问题。
1、最初我是在主库上创建密码文件:
orapwd file='$ORACLE_HOME/dbs/orapwdbserver1' password=admin entries=10;
2、然后又在备库哈桑创建秘密文件:
orapwd file='$ORACLE_HOME/dbs/orapwdbserver2' password=admin entries=10;
这样做导致主库无法同步日志到备库。
刚才我复制主库的密码文件到备库,改名后成功,操作如下:
1、删除备库的密码文件(为了安全,我是mv)
mv orapwdbserver2 orapwdbserver2.bak
2、把主库的密码文件传到备库:
scp $ORACLE_HOME/dbs/orapwdbserver1 oracle@192.168.213.143:$ORACLE_HOME/dbs/orapwdbserver2
注意密码文件名字的改变!!!
3、重新启动主库:
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area304807936 bytes
Fixed Size2212856 bytes
Variable Size150998024 bytes
Database Buffers 146800640 bytes
Redo Buffers4796416 bytes
Database mounted.
Database opened.
4、检查发现rfs进程已经启动:
SQL>select process,status,client_process,sequence#,block# from v$managed_standby;
PROCESS STATUS CLIENT_PSEQUENCE# BLOCK#
--------- ------------ -------- ---------- ----------
ARCH CONNECTED ARCH 0 0
ARCH CLOSING ARCH 205 1
ARCH CONNECTED ARCH 0 0
ARCH CLOSING ARCH 204 1
MRP0 WAIT_FOR_LOG N/A206 0
RFS IDLE UNKNOWN 0 0
RFS IDLE UNKNOWN 0 0
RFS IDLE UNKNOWN 0 0
RFS IDLE UNKNOWN 0 0
RFS IDLE UNKNOWN 0 0
RFS IDLE UNKNOWN 0 0
PROCESS STATUS CLIENT_PSEQUENCE# BLOCK#
--------- ------------ -------- ---------- ----------
RFS IDLE UNKNOWN 0 0
RFS IDLE UNKNOWN 0 0
RFS IDLE UNKNOWN 0 0
14 rows selected.
再去查看日志和数据,已经开始同步。到此,已经解决问题。
各位有什么意见的,讨论讨论。