主从同步测试
测试前,先确认数据库实例、守护、监控器已经启动
主库:新增测试数据
disql SYSDBA:35231
create table test(id int);
insert into test values(11);
commit;
从库:可以正常查询数据
disql SYSDBA:35231
SQL> select * from test;
LINEID id
---------- -----------
1 1
used time: 0.303(ms). Execute id is 101.
从库默认没有不支持写
SQL> insert into test values(22);
insert into test values(22);
[-710]:Try to modify user database at standby mode.
used time: 0.610(ms). Execute id is 0.