MRP0: Background Media Recovery terminated with error 742

after starting the DR database using srvctl start database, alter log showing that background Media Recovery is terminated with error 742

what I have found is that it is more like a warning rather than an actual error.

This will happen if you do the following when recovering standby database.

At command "ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;" what we are saying is cancel the standby recovery. so when you will start DR database using srvctl you will get that warning means real time apply is not happening.

SQL> startup nomount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 5344731136 bytes
Fixed Size                  2262656 bytes
Variable Size            4412410240 bytes
Database Buffers          922746880 bytes
Redo Buffers                7311360 bytes
SQL> alter database mount standby database;
Database altered.
SQL> alter database open read only;
Database altered.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;
Database altered.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Database altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
[oracle@testdb01 (db1tesd) bin]$
[oracle@testdb01 (db1tesd) bin]$
[oracle@testdb01 (db1tesd) bin]$ srvctl start database -d db1tesd
[oracle@testdb01 (db1tesd) bin]$ 

To fix this and start real time apply issue the following command and test using srvctl stop and start on DR.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;
Database altered.
SQL>