主库和备库都了添加6个standby redo log
重新启动主库,改变data guard保护模式
alter system set log_archive_dest_2='service=t226 reopen=300 lgwr' scope=both;
--t226是standby的tnsname
alter database set standby database to maximize availability;
alter database open;
丛库在应用日志状态
然后在主库修改数据,并提交。
从库readonly,查看,并没有跟着主库变化
帮忙看看把,谢谢了先
主库的alert
Thu May 20 11:21:13 2010
SMON: enabling tx recovery
Thu May 20 11:21:13 2010
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Thu May 20 11:26:21 2010
Network asynch I/O wait error 3114 log 3 service 't226'
Thu May 20 11:26:21 2010
Errors in file d:\oracle\admin\test\bdump\test_lgwr_1792.trc:
ORA-03114: not connected to ORACLE
Thu May 20 11:31:30 2010
LGWR: Completed archiving log 3 thread 1 sequence 15
LGWR: Error 1010 disconnecting from destination LOG_ARCHIVE_DEST_3 standby host 't226'
LGWR: RFS network connection re-established at host 't226'
LGWR: RFS destination opened for reconnect at host 't226'
Creating archive destination LOG_ARCHIVE_DEST_3: 't226'
LGWR: Standby redo logfile selected to archive thread 1 sequence 16
LGWR: Beginning to archive log 1 thread 1 sequence 16
Thread 1 advanced to log sequence 16
Current log# 1 seq# 16 mem# 0: M:\ORADATA\TEST\REDO01.LOG
Thu May 20 11:31:49 2010
ARC0: Evaluating archive log 3 thread 1 sequence 15
ARC0: LGWR is actively archiving destination LOG_ARCHIVE_DEST_3
ARC0: Beginning to archive log 3 thread 1 sequence 15
Creating archive destination LOG_ARCHIVE_DEST_3: 't226'
Creating archive destination LOG_ARCHIVE_DEST_2: 'M:\ARCHIVETEST\1_15.DBF'
ARC0: Completed archiving log 3 thread 1 sequence 15
Thu May 20 11:34:02 2010
Network asynch I/O wait error 3114 log 1 service 't226'
Thu May 20 11:34:02 2010
Errors in file d:\oracle\admin\test\bdump\test_lgwr_1792.trc:
ORA-03114: not connected to ORACLE
[本帖最后由 altdel 于 2010-5-20 12:08 编辑]