os:rhel 5
db:11201
primary:SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CLOSING 44
ARCH CLOSING 42
ARCH CLOSING 38
ARCH CLOSING 43
LNS WRITING 45
SQL> select max(sequence#) from v$archived_log where applied='YES';
MAX(SEQUENCE#)
--------------
212
standby:
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CLOSING 42
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CLOSING 44
RFS IDLE 0
RFS IDLE 0
RFS IDLE 45
RFS IDLE 0
MRP0 WAIT_FOR_LOG 211
9 rows selected.
SQL> alter database recover managed standby database cancel;
Database altered.
SQL> alter database recover managed standby database disconnect from session using current logfile;
Database altered.
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CLOSING 42
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CLOSING 44
RFS IDLE 0
RFS IDLE 0
RFS IDLE 45
RFS IDLE 0
MRP0 WAIT_FOR_LOG 211
9 rows selected.
SQL>
SQL>
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CLOSING 42
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CLOSING 44
RFS IDLE 0
RFS IDLE 0
RFS IDLE 45
RFS IDLE 0
MRP0 WAIT_FOR_LOG 211
9 rows selected.
SQL> select max(sequence#) from v$archived_log where applied='YES';
MAX(SEQUENCE#)
--------------
不知道还需要那些信息?我会尽快贴上来 这个问题我有点搞不清头绪,希望大家多多拍砖!