19C备库alertlog中出现 “Warning: ALTER DATABASE RECOVER MANAGED STANDBY DATAB...

jiawang

报错信息：
2022-08-02T11:20:46.575443+08:00
Warning: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE has been deprecated.
Warning: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE has been deprecated.
alter database recover managed standby database using current logfile disconnect from session
2022-08-02T11:20:46.580718+08:00
Attempt to start background Managed Standby Recovery process (orcl)
Starting background process MRP0
2022-08-02T11:20:46.599793+08:00
MRP0 started with pid=48, OS id=5040
2022-08-02T11:20:46.601481+08:00
Background Managed Standby Recovery process started (orcl)
2022-08-02T11:20:49.062917+08:00
rfs (PID:4557): Archived Log entry 12 added for B-1047224844.T-1.S-137 ID 0x5de10d8a LAD:2

查看了一下12c的官方文档，官方文档是这样说明的，
8.2.1 Using Real-Time Apply to Apply Redo Data Immediately

If the real-time apply feature is enabled, then apply services can apply redo data as it is received, without waiting for the current standby redo log file to be archived. This results in faster switchover and failover times because the standby redo log files have already been applied to the standby database by the time the failover or switchover begins. It also enables real-time reporting on an Oracle Active Data Guard standby by keeping it more closely synchronized with the primary database.

Use the ALTER DATABASE statement to enable the real-time apply feature, as follows:

    For physical standby databases, issue the ALTER DATABASE RECOVER MANAGED STANDBY DATABASE statement. (As of Oracle Database 12c Release 1 (12.1), the USING CURRENT LOGFILE clause is deprecated and no longer necessary to start real-time apply.)

    For logical standby databases, issue the ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE statement.

Real-time apply requires a standby database that is configured with a standby redo log and that is in ARCHIVELOG mode.

注意里面的这一行

Real-time apply requires a standby database that is configured with a standby redo log and that is in ARCHIVELOG mode.
在12c 下，主要通过以下的语句启用real-time apply
SQL>  ALTER DATABASE RECOVER MANAGED STANDBY DATABASE;
SQL>  ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;
SQL>  ALTER DATABASE RECOVER MANAGED STANDBY USING ARCHIVED LOGFILE DISCONNECT;