Also can you confirm this file exists on the Standby side.
Connected to: Oracle Database 11g Enterprise Edition Release 18.104.22.168.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; Database altered. SQL> alter database open read only ; Database altered. SQL>
1. Make sure that the standby is in sync with primary. 2. Cancel the MRP on standby and shut it down. 3. Standby: Just give startup 4. Later start the MRP on it
Could you confirm this by running this SQL from your primary :
and the logs are in synchronised between my primary and standby