10g 11g配置Logical Standby

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

ALTER SYSTEM SET log_archive_dest_2 = ‘SERVICE=PRODDG VALID_FOR=(ONLINE_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=PRODDG‘  SCOPE=SPFILE;

EXECUTE DBMS_LOGSTDBY.BUILD;

ALTER DATABASE RECOVER TO LOGICAL STANDBY PRODDG;

SHUTDOWN IMMEDIATE
   STARTUP  mount
   ALTER DATABASE OPEN RESETLOGS;

ALTER DATABASE START LOGICAL STANDBY APPLY;

SQL> alter system switch logfile;

System altered.

SQL> create user hxy identified by hxy;

User created.

SQL> grant dba to hxy;

Grant succeeded.

SQL> alter system switch logfile;

System altered.

SQL> conn hxy/hxy
Connected.
SQL> select * from tab;

no rows selected

SQL> create table t1 as select * from dba_users;

Table created.

SQL> alter system switch logfile;

System altered.

SQL> select count(*) from t1;

  COUNT(*)
----------
        23

Sun Apr 27 23:25:11 2014
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 123, /dsg/oracle11/PRODDG/arch/log1_123_839354331.arc
LOGMINER: End   mining logfile for session 1 thread 1 sequence 123, /dsg/oracle11/PRODDG/arch/log1_123_839354331.arc
Sun Apr 27 23:25:12 2014
RFS[2]: Opened log for thread 1 sequence 124 dbid 251192667 branch 839354331
Sun Apr 27 23:26:19 2014
RFS LogMiner: Registered logfile [/dsg/oracle11/PRODDG/arch/log1_124_839354331.arc] to LogMiner session id [1]
Sun Apr 27 23:26:19 2014
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 124, /dsg/oracle11/PRODDG/arch/log1_124_839354331.arc
LOGMINER: End   mining logfile for session 1 thread 1 sequence 124, /dsg/oracle11/PRODDG/arch/log1_124_839354331.arc
RFS[2]: Opened log for thread 1 sequence 125 dbid 251192667 branch 839354331

SQL> conn hxy/hxy
Connected.
SQL> select * from tab;
TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
T1                             TABLE
SQL> select count(*) from t1;
  COUNT(*)
----------
        23