空间管理您的位置: ITPUB个人空间 » victor1010的个人空间 » 日志

DG测试2

上一篇 / 下一篇 2008-05-04 10:15:53 / 个人分类：DG

（3）如果在管理恢复模式下到只读模式
SQL> recover managed standby database cancel;
完成介质恢复。
SQL> alter database open read only;

SQL> select count(*) from tstuser.f_t1;

COUNT(*)
----------
         0
SQL> select process,client_process,sequence#,status from v$managed_standby;

PROCESS        CLIENT_PROCESS    SEQUENCE# STATUS
-------------- ---------------- ---------- ------------------------
ARCH           ARCH                      0 CONNECTED
ARCH           ARCH                      0 CONNECTED
RFS            ARCH                     27 RECEIVING
RFS            ARCH                     28 RECEIVING
（4）从只读方式到管理恢复方式
SQL> recover managed standby database disconnect from session;
完成介质恢复。
SQL> select process,client_process,sequence#,status from v$managed_standby;

PROCESS        CLIENT_PROCESS    SEQUENCE# STATUS
-------------- ---------------- ---------- ------------------------
ARCH           ARCH                      0 CONNECTED
ARCH           ARCH                      0 CONNECTED
MRP0           N/A                      29 WAIT_FOR_LOG
RFS            ARCH                     27 RECEIVING
RFS            ARCH                     28 RECEIVING

SQL> SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE# ;

SEQUENCE# FIRST_TIME NEXT_TIME APPLIE
---------- ---------- ---------- ------
        20 29-4? -08 29-4? -08 YES
        21 29-4? -08 29-4? -08 YES
        22 29-4? -08 29-4? -08 YES
        23 29-4? -08 29-4? -08 YES
        24 29-4? -08 30-4? -08 NO
        24 29-4? -08 30-4? -08 YES
        25 30-4? -08 30-4? -08 YES
        26 30-4? -08 30-4? -08 YES
        27 30-4? -08 30-4? -08 YES
        28 30-4? -08 30-4? -08 YES

已选择10行。

SQL> alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';

会话已更改。

SQL> SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE# ;

SEQUENCE# FIRST_TIME          NEXT_TIME           APPLIE
---------- ------------------- ------------------- ------
        20 2008-04-29 13:34:38 2008-04-29 16:23:25 YES
        21 2008-04-29 16:23:25 2008-04-29 16:23:26 YES
        22 2008-04-29 16:23:26 2008-04-29 16:23:44 YES
        23 2008-04-29 16:23:44 2008-04-29 17:09:18 YES
        24 2008-04-29 17:09:18 2008-04-30 08:44:22 NO
        24 2008-04-29 17:09:18 2008-04-30 08:44:22 YES
        25 2008-04-30 08:44:22 2008-04-30 08:48:37 YES
        26 2008-04-30 08:48:37 2008-04-30 10:45:11 YES
        27 2008-04-30 10:45:11 2008-04-30 11:03:52 YES
        28 2008-04-30 11:03:52 2008-04-30 11:17:50 YES

已选择10行。

SQL> spool off;