單機Linux平臺Oracle 11g DataGuard Physical Standby 搭建例項(7)

九. 驗證：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