操作系统:阿里云ecs
数据库:Oracle 11.2.0.1 ADG
前提:每天早上6点要进行数据库的rman备份
早上巡检发现今天(04-18)早上6点到7点的Elapsed Time是285
17415 2017-04-18 06:00:02 2017-04-18 07:00:43 2.2273E+13 2.2256E+13 285.677088
而平时的Elapsed Time很少
17391 2017-04-17 06:00:49 2017-04-17 07:00:53 2.2045E+13 2.2045E+13 1.03215108
怎么突然就变化这么大,然后就查看了对应的alert日志:
主库的alert报了ora-16146的错:
LNS: Standby redo logfile selected for thread 1 sequence 13431 for destination LOG_ARCHIVE_DEST_2
Archived Log entry 26856 added for thread 1 sequence 13430 ID 0xb3561577 dest 1:
Tue Apr 18 06:37:58 2017
Errors in file **/home/dbserver/oracle/diag/rdbms/ptopdb/ptopdb/trace/ptopdb_arc2_20166.trc:
ORA-16146: control file enqueue unavailable**
Tue Apr 18 06:45:26 2017
ALTER SYSTEM ARCHIVE LOG
Tue Apr 18 06:45:26 2017
Thread 1 advanced to log sequence 13432 (LGWR switch)
Current log# 1 seq# 13432 mem# 0: /dbdata/ptopdb/ptopdb_u01/ptopdb/redo01.log
Archived Log entry 26858 added for thread 1 sequence 13431 ID 0xb3561577 dest 1:
Tue Apr 18 06:45:27 2017
LNS: Standby redo logfile selected for thread 1 sequence 13432 for destination LOG_ARCHIVE_DEST_2
从库没有明显的异常:
Tue Apr 18 06:03:58 2017
RFS[2]: Selected log 5 for thread 1 sequence 13431 dbid -1286252169 branch 877806585
Tue Apr 18 06:03:58 2017
Media Recovery Waiting for thread 1 sequence 13431 (in transit)
Recovery of Online Redo L