单机Linux平台Oracle 11g DataGuard Physical Standby 搭建实例(7)

单机Linux平台Oracle 11g DataGuard Physical Standby 搭建实例(1)：http://space.itpub.net/81227/viewspace-713012

单机Linux平台Oracle 11g DataGuard Physical Standby 搭建实例(2)：http://space.itpub.net/81227/viewspace-713013

单机Linux平台Oracle 11g DataGuard Physical Standby 搭建实例(3)：http://space.itpub.net/81227/viewspace-713014

单机Linux平台Oracle 11g DataGuard Physical Standby 搭建实例(4)：http://space.itpub.net/81227/viewspace-713017

单机Linux平台Oracle 11g DataGuard Physical Standby 搭建实例(5)：http://space.itpub.net/81227/viewspace-713018

单机Linux平台Oracle 11g DataGuard Physical Standby 搭建实例(6)：http://space.itpub.net/81227/viewspace-713019

 

 

九. 验证：real-time apply and real-time query

在Primary:

SQL> set time on

10:25:42 SQL> set sqlp 'Primary> '

10:26:20 Primary>

在Standby:

SQL> set time on

10:24:53 SQL> set sqlp 'Standby> '

10:26:09 Standby>

下面进行测试：

10:28:40 Primary> create table rt (id number,name varchar2(30));

Table created.

 

10:28:49 Standby> desc rt

 Name              Null?    Type

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

 ID                         NUMBER

 NAME                       VARCHAR2(30)

 

10:29:44 Primary> insert into rt select rownum,object_name from dba_objects;

72300 rows created.

 

10:29:11 Standby> select count(*) from rt;

  COUNT(*)

----------

         0

 

10:29:55 Primary> commit;

Commit complete.

 

10:30:03 Standby> select count(*) from rt;

  COUNT(*)

----------

     72300

 

10:30:07 Primary> delete rt;

72300 rows deleted.

 

10:30:14 Standby> select count(*) from rt;

  COUNT(*)

----------

     72300

 

10:30:38 Primary> commit;

Commit complete.

 

10:30:41 Standby> select count(*) from rt;

  COUNT(*)

----------

         0

 

10:30:59 Primary> drop table rt;

Table dropped.

 

10:31:01 Standby> select count(*) from rt;

select count(*) from rt

                     *

ERROR at line 1:

ORA-00942: table or view does not exist

 

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/81227/viewspace-713022/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/81227/viewspace-713022/