高级复制中如何应对主体站点故障
高级复制中如何应对主体站点故障
作者:eygle
出处:http://blog.eygle.com
日期:February 18, 2005
« 在高级复制中如何切换主体定义站点 | Blog首页 | 自己动手,丰衣足食 »
在同步复制中 一旦任意主体站点出现故障，数据库将会出现问题。
SQL> select * from scott.dept; DEPTNO DNAME LOC ------ -------------- ------------- 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON 33 ORACLE beijing 35 Oracle Beijing 6 rows selected SQL> |
|---|
此时DML操作不能进行
SQL> insert into scott.dept values (36,'Oracle','Beijing'); insert into scott.dept values (36,'Oracle','Beijing') ORA-02068: following severe error from TESTORA9 ORA-03113: end-of-file on communication channel ORA-02068: following severe error from TESTORA9 ORA-03113: end-of-file on communication channel SQL> select gname,dblink,masterdef from dba_repsites; GNAME DBLINK MASTERDEF ------------------------------ ---------------------------------- REP_TT CONNER.HURRAY.COM.CN Y REP_TT TESTORA9.HURRAY.COM.CN N |
|---|