DG测试2
（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;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8102208/viewspace-258766/ ，如需转载，请注明出处，否则将追究法律责任。
