ORA-10458 ORA-01196 ORA-01110

2019独角兽企业重金招聘Python工程师标准>>>

公司erp系统，通过Oracle Dataguard实现主从同步，已经运行一年多，近期巡检发现主从数据库的数据不一致了，从库无法启动，报ORA-10458 ORA-01196 ORA-01110

处理思路：查看状态发现数据库在mount状态，尝试启库

SQL> select status from v$instance;

STATUS
------------
MOUNTED

SQL> alter database open;

alter database open
*
ERROR at line 1:
ORA-10458: standby database requires recovery
ORA-01196: file 1 is inconsistent due to a failed media recovery session
ORA-01110: data file 1: '/u01/app/oracle/oradata/ncdb/system01.dbf'

检查数据库发现从库监听未启动，启动从库监听

[oracle@ncdb_standby ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.