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;