Oracle 19c Data Guard 的alert log 发现了如下告警：

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.

这里提示USING CURRENT LOGFILE 选项已经过期了。

这里和备库的MRP 进程启动命令有关系：http://www.cndba.cn/cndba/dave/article/131687

SQL> alter database recover managed standby database using current logfile disconnect from session;

我还是还是使用11g的命令启动的，查看了一下官方手册，这里命令确实做了修改。http://www.cndba.cn/cndba/dave/article/131687

https://docs.oracle.com/en/database/oracle/oracle-database/23/sbydb/oracle-data-guard-redo-apply-services.html#GUID-1808DF72-C384-4BC2-A75F-D73C56C22A2Bhttp://www.cndba.cn/cndba/dave/article/131687

This also automatically enables real-time apply provided the standby database is configured with a standby redo log and is in ARCHIVELOG mode.http://www.cndba.cn/cndba/dave/article/131687http://www.cndba.cn/cndba/dave/article/131687http://www.cndba.cn/cndba/dave/article/131687http://www.cndba.cn/cndba/dave/article/131687

在配置了standby redo log的情况下，会自动启动real-time apply，所以直接正常后台启动即可：http://www.cndba.cn/cndba/dave/article/131687

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING ARCHIVED LOGFILE DISCONNECT;

SQL> alter database recover managed standby database cancel;
Database altered.
SQL> alter database recover managed standby database using archived logfile disconnect;
Database altered.

查看日志确认：
2025-07-19T00:22:32.501546+08:00
alter database recover managed standby database using archived logfile disconnect
2025-07-19T00:22:32.502419+08:00
Attempt to start background Managed Standby Recovery process (cndba)
Starting background process MRP0
2025-07-19T00:22:32.527847+08:00
MRP0 started with pid=56, OS id=63198 
2025-07-19T00:22:32.529271+08:00
Background Managed Standby Recovery process started (cndba)
2025-07-19T00:22:37.553715+08:00
 Started logmerger process
2025-07-19T00:22:37.563392+08:00

IM on ADG: Start of Empty Journal 

IM on ADG: End of Empty Journal 
PR00 (PID:63204): Managed Standby Recovery not using Real Time Apply
max_pdb is 4
2025-07-19T00:22:37.663129+08:00
Parallel Media Recovery started with 4 slaves
2025-07-19T00:22:37.699267+08:00
Stopping change tracking
PR00 (PID:63204): Media Recovery Waiting for T-1.S-55 (in transit)
2025-07-19T00:22:38.535879+08:00
Completed: alter database recover managed standby database using archived logfile disconnect

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