1.错误:
初学data guard,搭了个简单的物理备库测试环境。。备库开启redo接收之后,主库中插入数据,switch logfile好多次之后,发现备库依然收不到来自主库redo日志。。
2.trace
查看主库trace文件:
Fri Apr 25 01:11:58 2014
Using STANDBY_ARCHIVE_DEST parameter default value as /u01/archive
RFS[1]: Assigned to RFS process 5602
RFS[1]: Database mount ID mismatch [0x1cae8268:0x1cae2b38] (481198696:481176376)
RFS[1]: Client instance is standby database instead of primary
RFS[1]: Not using real application clusters
Errors in file /u01/diag/rdbms/dg01/dg01/trace/dg01_rfs_5602.trc:
ORA-16009: invalid redo transport destination
备库trace文件:
Fri Apr 25 01:11:46 2014
Errors in file /u01/diag/rdbms/dg02/dg01/trace/dg01_arc1_3619.trc:
ORA-16009: invalid redo transport destination
PING[ARC1]: Heartbeat failed to connect to standby 'dg01'. Error is 16009.
主库上执行:
SQL> select dest_name,error,status,process from v$archive_dest where rownum<3;
DEST_NAME ERROR STATUS PROCESS
------------------------- ------------------- --------- ----------
LOG_ARCHIVE_DEST_1 VALID ARCH
LOG_ARCHIVE_DEST_2 INACTIVE ARCH
error列好像并没有什么错误
再看一下备库: