种操作是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