测试流程
测试流程包含以下步骤:
1、准备应用客户端做为测试终端,配置连向容灾数据库的连接字串;
2、恢复容灾端归档日志;
3、在datagurad数据库上创建还原点;
4、激活Dataguard数据库;
5、应用客户端连接到dataguard数据库上进行应用测试;
6、关闭Dataguard,将其还原到还原点;
7、检查确认从RAC数据库到Dataguard的归档日志传递是否恢复正常;
测试过程
恢复归档日志
Datagurad为实时恢复模式,检查datagurad恢复到最新
SQL>select to_char(checkpoint_time, 'yyyy-mm-dd hh24:mi:ss') from v$datafile;
SQL>select name,applied from v$archived_log where applied='NO';
关闭dataguard自动应用, 在容灾库上执行:
SQL>alter database recover managed standby database cancel;
关闭生产库归档传输通道,在生产库上执行:
SQL>alter system set log_archive_dest_state_2=defer;
创建还原点
选择一个较大的文件系统目录,这里以/backup/restore为范例
SQL> alter system set db_recovery_file_dest_size=20480M;
SQL> alter system set db_recovery_file_dest='/backup/restore';
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database flashback on;
SQL> create restore point standby_test guarantee flashback database;
激活Dataguard
SQL>alter database activate standby database;
SQL>alter database open;
手动切换几次日志文件
SQL>alter system switch logfile;
应用测试
应用客户端连接到dataguard数据库上进行应用测试。
注:测试期间产生的所有测试数据都将被回滚,不作保留。
恢复Dataguard
将数据库恢复到还原点:
SQL> shutdown immediate
SQL> startup mount
SQL> flashback database to restore point standby_test;
将数据库恢复为dataguard:
SQL> shutdown immediate
SQL> startup nomount
SQL> alter database mount;
SQL> ALTER DATABASE CONVERT TO PHYSICAL STANDBY;
将数据库设置为ADG模式:
SQL> shutdown immediate
SQL> startup nomount;
SQL> alter database mount standby database;
SQL> alter database open read only;
SQL> alter database recover managed standby database disconnect from session;
恢复归档传递
在生产端上执行:
SQL>alter system set log_archive_dest_state_2=enable;
检查归档日志是能够传递过来,并且是否完备;
删除还原点
在确认Dataguard完全恢复以后删除还原点
SQL> shutdown immediate;
SQL> startup nomount;
SQL> alter database mount standby database;
SQL> drop restore point standby_test;
SQL> alter database flashback off;
SQL> alter database open read only;
SQL> alter database recover managed standby database disconnect from session;
总结
经过此次测试,验证了Dataguard用于生产系统的可用性。
转载来源:https://blog.csdn.net/weixin_41702082/article/details/82772750