Oracle - 11GR2 - RAC - to - RAC - DATAGUARD - 配置方案(5)

种操作是destructive操作，一旦执行，备库需要重建。运行此操作需慎重。

sql> alter database recover managed standby database finish force; sql> alter database activate standby database [skip standby logfile]; sql> shutdown immediate; sql> startup mount; sql> alter database open resetlogs;

1.6.5 数据同步测试

主库： create tablespace test datafile '+data' size 128m autoextend off; create user test identified by test default tablespace test; grant connect,resource to test; conn test/test create table t1 as select * from user_objects; select count(*) from test.t1; conn / as sysdba alter system checkpoint; alter system archive log current; 备库： select count(*) from test.t1; 主库： drop user test cascade; drop tablespace test including contents and datafiles; alter system checkpoint; alter system archive log current; 备库： select count(*) from test.t1; select name from v$tablespace where name='TEST';

1.7 参考

Technical_Architecture_of_11g_R2_RAC_primary_to_RAC_standby_DataGuard配置指南(中

文)

Data Guard Concepts and Administration

Step By Step of Configuring Oracle 11gR2 (11.2.0.1) RAC to RAC Dataguard