ORA-16813: log apply service not running on apply instance string recorded by the broker ORACLE 报错 故障修复 远程处理

文档解释

ORA-16813: log apply service not running on apply instance string recorded by the broker

Cause: Log apply services were not running on the instance the Data Guard broker expected them to be running upon.

Action: Reenable the standby database to clear the error.

ORA-16813错误指示日志应用服务在应用实例上没有运行。根据官方文档,这是由于内部错误导致的,具体的原因是无法确定。

一般处理方法及步骤

1.从SQL * Plus上查询apply_service进程的状态:

SQL > SELECT status FROM V $ LOGSTDBY_PROCESS where process = ‘apply_service’;

2.如果状态显示为“ABORTED”,则启动日志应用服务:

SQL > alter database start standby log apply instance string;

3. 再次查询apply_service进程的状态,若报错出现“ABORTED”,则可尝试重新停止和启动日志应用服务,直到报错消失为止。

SQL > alter database stop/start standby log apply instance string;


数据运维技术 » ORA-16813: log apply service not running on apply instance string recorded by the broker ORACLE 报错 故障修复 远程处理