ORA-16191: Primary log shipping client not logged on standby解决方法

Oracle DataGuard主备数据不同步，出现 ORA-16191: Primary log shipping client not logged on standby错误。

SQL> select dest_name,error from v$archive_dest;

DEST_NAME                           ERROR
----------------------------------- ---------------------------------------------
LOG_ARCHIVE_DEST_1
LOG_ARCHIVE_DEST_2
LOG_ARCHIVE_DEST_3                  ORA-16191: Primary log shipping client not
                                    logged on standby

LOG_ARCHIVE_DEST_4
LOG_ARCHIVE_DEST_5
LOG_ARCHIVE_DEST_6
LOG_ARCHIVE_DEST_7
LOG_ARCHIVE_DEST_8
LOG_ARCHIVE_DEST_9

DEST_NAME                           ERROR
----------------------------------- ---------------------------------------------
LOG_ARCHIVE_DEST_10
LOG_ARCHIVE_DEST_11
LOG_ARCHIVE_DEST_12
LOG_ARCHIVE_DEST_13
LOG_ARCHIVE_DEST_14
LOG_ARCHIVE_DEST_15
LOG_ARCHIVE_DEST_16
LOG_ARCHIVE_DEST_17
LOG_ARCHIVE_DEST_18
LOG_ARCHIVE_DEST_19
LOG_ARCHIVE_DEST_20

DEST_NAME                           ERROR
----------------------------------- ---------------------------------------------
LOG_ARCHIVE_DEST_21
LOG_ARCHIVE_DEST_22
LOG_ARCHIVE_DEST_23
LOG_ARCHIVE_DEST_24
LOG_ARCHIVE_DEST_25
LOG_ARCHIVE_DEST_26
LOG_ARCHIVE_DEST_27
LOG_ARCHIVE_DEST_28
LOG_ARCHIVE_DEST_29
LOG_ARCHIVE_DEST_30
LOG_ARCHIVE_DEST_31

31 rows selected.

ORA-16191一般是由于主备库sys密码不一致导致，重新同步主库密码文件至备库。

scp /database/app/oracle/product/11.2.0/db_1/dbs/orapwemis 172.16.201.192:/database/app/oracle/product/11.2.0/db_1/dbs

拷贝后重启备库，查看归档应用情况：

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

PROCESS      THREAD#  SEQUENCE#     BLOCK#
--------- ---------- ---------- ----------
ARCH               0          0          0
ARCH               0          0          0
ARCH               0          0          0
ARCH               1     352218          1
MRP0               1     352219        379
RFS                0          0          0
RFS                0          0          0
RFS                0          0          0
RFS                1     352219        379

9 rows selected.

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

PROCESS      THREAD#  SEQUENCE#     BLOCK#
--------- ---------- ---------- ----------
ARCH               0          0          0
ARCH               0          0          0
ARCH               0          0          0
ARCH               1     352218          1
MRP0               1     352219        381
RFS                0          0          0
RFS                0          0          0
RFS                0          0          0
RFS                1     352219        381

9 rows selected.

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

PROCESS      THREAD#  SEQUENCE#     BLOCK#
--------- ---------- ---------- ----------
ARCH               0          0          0
ARCH               0          0          0
ARCH               0          0          0
ARCH               1     352218          1
MRP0               1     352219        386
RFS                0          0          0
RFS                0          0          0
RFS                0          0          0
RFS                1     352219        386

9 rows selected.

MRP进程已启动，block#实时更新，数据正常同步