a db thinker's home

前一天通过duplicate active database 创建好standby之后,,今天简单的测试了一下active standby的apply 效率..

1. 准备工作, 将standby以active standby模式启动.

–Oracle文档要求standby logfile的数量至少比online logfile多一组. 所以我们在此创建4组standby logfile.
alter database add standby logfile group 4 (‘+data’) size 50m;
alter database add standby logfile group 5 (‘+data’) size 50m;
alter database add standby logfile group 6 (‘+data’) size 50m;
alter database add standby logfile group 7 (‘+data’) size 50m;

–将重启standby,并以active standby模式打开.
shutdown immediate;
startup mount;
alter database open read [...]