failover测试文档.docx

Oracle10g rac dataguard failover故障切换测试把dataguard设置为最大可用，dataguard可以同步日志，无问题，开始测试,如果主库有日志未发送到备库，请参考附录,.第一步，主库服务器不用操作，然后在备库执行： alter database recover managed standby database cancel;create restore point dgfail guarantee flashback database;alter database recover managed standby database finish force;alter database commit to switchover to primary;shutdown immediate;startup;结果如下：SQL alter database recover managed standby database cancel;Database altered.SQL create restore point dgfail guarantee flashback database;Restore point created.SQL alter database recover managed standby database finish force;Database altered.SQL alter database commit to switchover to primary;Database altered.SQL shutdown immediate;ORA-01507: database not mountedORACLE instance shut down.SQL startup;ORACLE instance started.Total System Global Area 989855744 bytesFixed Size 2088760 bytesVariable Size 444596424 bytesDatabase Buffers 536870912 bytesRedo Buffers 6299648 bytesDatabase mounted.Database opened.第二步，开始在备库创建表空间和用户：SQL create tablespace testls datafile /opt/app/oracle/oradata/standby/testls.dbf size 50M;Tablespace created.SQL create user ls identified by ls default tablespace testls;User created.SQL grant dba to ls;Grant succeeded.SQL connect ls/lsConnected.SQL create table ls (test int);Table created.SQL insert into ls values(1);1 row created.SQL insert into ls values(2);1 row created.SQL select * from ls; TEST---------- 1 2备库可以进行ddl和dml操作。第三步，开启主库服务器，并且闪回到点” dgfail”，检测dataguard是否正常工作：主库能够正常启动，数据库服务正常，如下：[oracle@rac1 ~]$ crs_stat -tName Type Target State Host------------------------------------------------------------ora.oradb.db application ONLINE ONLINE rac2ora....b1.inst application ONLINE ONLINE rac1ora....b2.inst application ONLINE ONLINE rac2ora....adbs.cs application ONLINE ONLINE rac2ora....db1.srv application ONLINE ONLINE rac1ora....db2.srv application