NAME DATABASE_ROLE

--------------------------- ----------------------

ORA10G PHYSICAL STANDBY

SQL> alter database recover managed standby database disconnect from session;

Database altered.

主库上新建表，切换在线日志组测试：

SQL> create table hr.dg01 as select * from dba_source;

Table created.

SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> /

System altered.

备库：

SQL> select sequence#,first_time,next_time,applied from v$archived_log;

SEQUENCE# FIRST_TIME NEXT_TIME APPLIED

---------- ------------------- ------------------- ---------

91 2011-08-04-14:38:52 2011-08-04-14:41:21 YES

92 2011-08-04-14:41:21 2011-08-04-15:13:44 YES

93 2011-08-04-15:13:44 2011-08-04-15:15:07 YES

94 2011-08-04-15:15:07 2011-08-04-15:42:58 YES

95 2011-08-04-15:42:58 2011-08-04-16:55:53 YES

96 2011-08-04-16:55:53 2011-08-04-16:56:11 YES

97 2011-08-04-16:56:11 2011-08-04-16:56:18 YES

98 2011-08-04-16:56:18 2011-08-04-16:56:33 YES

8 rows selected.

将备库置为只读状态，验证数据：

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> alter database open read only;

Database altered.

SQL> select count(*) from hr.dg01;

COUNT(*)

----------

323203

重新将备库置为应用redo log状态

SQL> alter database recover managed standby database disconnect from session;

Database altered.

本文出自 “月牙天冲” 博客