oracle最大性能模式,standby最大性能模式改为最大可用模式

主库和备库都了添加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 编辑]