- 最后登录
- 2017-12-17
- 在线时间
- 33 小时
- 威望
- 0
- 金钱
- 270
- 注册时间
- 2016-8-3
- 阅读权限
- 10
- 帖子
- 1
- 精华
- 0
- 积分
- 0
- UID
- 2464
|
1#
发表于 2016-12-1 10:14:18
|
查看: 2320 |
回复: 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报错,请刘大能否指点一下 |
|