Database mount ID mismatch(ORA-16009: invalid redo transport destination )
来源:互联网 发布:香港大学网络教育报名 编辑:程序博客网 时间:2024/05/16 07:08
问题描述:
dataguard 环境,由于主库上面的归档日志满了,导致系统处于假死状态,后来重启系统。
但发现归档日志不能传送到备库。
检查alert日志发现类似如下内容;
Sun Feb 17 03:34:52 2013
RFS[53]: Assigned to RFS process 6896
RFS[53]: Database mount ID mismatch [0x27bfa217:0x27c019ed] (666870295:666900973)
RFS[53]: Client instance is standby database instead of primary
RFS[53]: Not using real application clusters
Errors in file /db/app/oracle/diag/rdbms/xiaoyu/xiaoyu/trace/xiaoyu_rfs_6896.trc:
ORA-16009: invalid redo transport destination
Sun Feb 17 03:40:52 2013
RFS[54]: Assigned to RFS process 6942
RFS[54]: Database mount ID mismatch [0x27bfa217:0x27c019ed] (666870295:666900973)
RFS[54]: Client instance is standby database instead of primary
RFS[54]: Not using real application clusters
Errors in file /db/app/oracle/diag/rdbms/xiaoyu/xiaoyu/trace/xiaoyu_rfs_6942.trc:
ORA-16009: invalid redo transport destination
ps:该内容是在网络上复制他人的,但错误信息是一致的。
错误信息显示日志传输路径不对,于是show parameter archive_参数,发现log_archive_dest_stat_2 值为defer,意思是暂停传输日志。
由于该环境不是我搭建,但理论上该参数值不应该会被设置成defer,同时发现log_archive_dest_2参数中,设置有net_timeout=30,意思是主库连接备库,超过30秒将会弃用备库,所以,我怀疑是由于当时主库出现故障,无法连通备库,超过30秒后,数据库将log_archive_dest_stat_2从enable变成了defer。
当然,这都是我的推测。
另外,出现上述错误,不一定是该参数导致的,也可能是其他参数设置错误导致,反正就那几个参数,一个个检查咯。
问题的解决很简单,将该参数改成enable即可:
alter system set log_archive_dest_stat_2=enable scope=both;
------------------------------------------------------------------华丽个毛线的分割线---------------------------------------------------------------------
最近这几天晚上熬夜看小说,白天破事多,脾气火爆,需要调整下心态。
还是要静下心来钻研点技术,比如最近expdp导出遇到XDB sga initialization问题,一直还没有完全解决。
- Database mount ID mismatch(ORA-16009: invalid redo transport destination )
- 记一次生产环境变更遇到ORA-00261和Database mount ID mismatch问题两例
- ORA-16047: DGID mismatch between destination setting and target database
- ORA-16047: DGID mismatch between destination setting and target database
- ORA-16047: DGID mismatch between destination错误
- ORA-19808: recovery destination parameter mismatch
- 查看standby database的redo transport status
- oracle 11g RAC ORA-19808: recovery destination parameter mismatch
- ORA-16047: DGID mismatch between destination setting and standby
- ORA-16047: DGID mismatch between destination setting and standby
- ORA-01618: redo thread 2 is not enabled - cannot mount
- ORA-01618: redo thread 2 is not enabled - cannot mount
- Oracle DG故障诊断案例一则:ORA-16047: DGID mismatch between destination setting and standby
- ORACLE启动报错:ORA-16068:redo log file activation identifier mismatch
- ORA-01102: cannot mount database in EXCLUSIVE mode
- ORA-01102: cannot mount database in EXCLUSIVE mode
- ORA-01102: cannot mount database in exclusive mode
- ORA-01102: cannot mount database in EXCLUSIVE mode - Linux Servers
- 管理你的第二屏(airPlay)
- Python 使用matplotlib画图添加标注、及移动坐标轴位置
- iOS的标识符
- iOS10.3中划线失效
- swift项目在iOS8 通过init(nibName nibNameOrNil: String?, bundle nibBundleOrNil: Bundle
- Database mount ID mismatch(ORA-16009: invalid redo transport destination )
- 将博客搬至CSDN
- opencv(一):图像规整
- java学习经验
- ODBC学习笔记—SQLGetConnectAttr
- Java NIO系列教程(十) Java NIO DatagramChannel
- 小兔的棋盘-dp
- mysql优化
- adult数据集的转换