Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

1

好友

1

主题
1#
发表于 2016-12-1 10:14:18 | 查看: 2321| 回复: 0
环境是Oracle  11.2.0.1 单机dataguard 主备,最近几天一直频繁报
DM00 started with pid=130, OS id=8427, job SYSTEM.SYS_EXPORT_SCHEMA_01
Sun Nov 27 02:58:11 2016
DW00 started with pid=133, OS id=8433, wid=1, job SYSTEM.SYS_EXPORT_SCHEMA_01
Sun Nov 27 03:09:05 2016
Errors in file /home/dbserver/oracle/diag/rdbms/ptopdb/ptopdb/trace/ptopdb_arc2_20166.trc:
ORA-16146: control file enqueue unavailable

DM00 started with pid=130, OS id=4286, job SYSTEM.SYS_EXPORT_SCHEMA_01
Mon Nov 28 02:58:20 2016
DW00 started with pid=131, OS id=4293, wid=1, job SYSTEM.SYS_EXPORT_SCHEMA_01
Mon Nov 28 03:07:20 2016
Errors in file /home/dbserver/oracle/diag/rdbms/ptopdb/ptopdb/trace/ptopdb_arc2_20166.trc:
ORA-16146: control file enqueue unavailable

DM00 started with pid=105, OS id=13600, job SYSTEM.SYS_EXPORT_SCHEMA_01
Tue Nov 29 02:54:35 2016
DW00 started with pid=131, OS id=13607, wid=1, job SYSTEM.SYS_EXPORT_SCHEMA_01
Tue Nov 29 03:05:05 2016
Errors in file /home/dbserver/oracle/diag/rdbms/ptopdb/ptopdb/trace/ptopdb_arc2_20166.trc:
ORA-16146: control file enqueue unavailable

DM00 started with pid=140, OS id=5871, job SYSTEM.SYS_EXPORT_SCHEMA_01
Wed Nov 30 23:59:18 2016
DW00 started with pid=147, OS id=5877, wid=1, job SYSTEM.SYS_EXPORT_SCHEMA_01
Thu Dec 01 00:07:57 2016
Errors in file /home/dbserver/oracle/diag/rdbms/ptopdb/ptopdb/trace/ptopdb_arc2_20166.trc:
ORA-16146: control file enqueue unavailable


查看对应trace文件都是
Redo shipping client performing standby login
OCISessionBegin failed. Error -1
.. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
'
OCISessionBegin failed. Error -1
.. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
'
*** 2016-11-17 20:24:50.334 4539 krsu.c
Logged on to standby successfully
Client logon and security negotiation successful!

*** 2016-11-17 20:25:50.157
Redo shipping client performing standby login
*** 2016-11-17 20:25:50.205 4539 krsu.c
Logged on to standby successfully
Client logon and security negotiation successful!
ORA-16146: control file enqueue unavailable
ORA-16146: control file enqueue unavailable
ORA-16146: control file enqueue unavailable
ORA-16146: control file enqueue unavailable

google查阅相关资料说是持有CF enqueue超时导致,但是,其报错描述是ORA-16146: standby destination control file enqueue unavailable,并非上述的主库报错内容,并且发现每次都是执行job SYSTEM.SYS_EXPORT_SCHEMA_01导出job报错,请刘大能否指点一下
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-20 21:51 , Processed in 0.048491 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569