Hi all!
After add a datafile in PRIMARY database, the STANDBY MRP stopped. An “ALTER DATABASE RECOVER MANAGED STANDBY DATABASE” does not solved te problem, as you see:
SQL> SELECT SEQUENCE#, Name, APPLIED FROM V$ARCHIVED_LOG where APPLIED 'YES' and SEQUENCE# ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION; Database altered. SQL> SELECT SEQUENCE#, Name, APPLIED FROM V$ARCHIVED_LOG where APPLIED 'YES' and SEQUENCE# < (select max(SEQUENCE#) -1 from V$ARCHIVED_LOG); SEQUENCE# NAME APPLIED ---------- -------------------------------------------------------------------------------- --------- 15075 /db/u1004/oracle/admin/MYDB/arch/arch_1_823102978_15075.arc NO
More“After adding Datafile in Primary the MRP Stopped in Physical Standby (Dataguard)”