ORACLE 19C DG 由于DG备机宕机，导致DG无法启动

备机:
SQL> startup
ORACLE instance started.

Total System Global Area 2.1475E+10 bytes
Fixed Size                 19524680 bytes
Variable Size            2550136832 bytes
Database Buffers         1.8858E+10 bytes
Redo Buffers               47583232 bytes
Database mounted.
ORA-10458: standby database requires recovery
ORA-01196: file 1 is inconsistent due to a failed media recovery session
ORA-01110: data file 1: '/oradata/xxx/system01.dbf'



SQL> select process,status,thread#,sequence#,block#,blocks from v$managed_standby;

PROCESS   STATUS          THREAD#  SEQUENCE#     BLOCK#     BLOCKS
--------- ------------ ---------- ---------- ---------- ----------
ARCH      CONNECTED             0          0          0          0
DGRD      ALLOCATED             0          0          0          0
DGRD      ALLOCATED             0          0          0          0
ARCH      CONNECTED             0          0          0          0
ARCH      CONNECTED             0          0          0          0
ARCH      CONNECTED             0          0          0          0
MRP0      APPLYING_LOG          1      82606      65660     524288


SQL> /

PROCESS   STATUS          THREAD#  SEQUENCE#     BLOCKS
--------- ------------ ---------- ---------- ----------
ARCH      CLOSING               1      82606        648
DGRD      ALLOCATED             0          0          0
DGRD      ALLOCATED             0          0          0
ARCH      CONNECTED             0          0          0
ARCH      CONNECTED             0          0          0
ARCH      CONNECTED             0          0          0
MRP0      APPLYING_LOG          1      82705     457652
RFS       IDLE                  1          0          0
RFS       RECEIVING             1      83113       2048
RFS       RECEIVING             1      83112       2048
RFS       RECEIVING             1      83111       2048


在主库执行命令:
SQL> alter system set log_archive_dest_state_2='ENABLE';

System altered.


在备库执行命令
SQL> alter database open;

Database altered.

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle