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;