I received the below errors while trying to recovery one of my standby databases that i am supporting:
SQL> RECOVER AUTOMATIC STANDBY DATABASE;
ORA-00283: recovery session canceled due to errors
ORA-00333: redo log read error block 104448 count 2048
SQL> recover managed standby database disconnect from session;
Media recovery complete.
SQL> shutdown immediate;
SQL> startup mount;
SQL> ALTER DATABASE MOUNT STANDBY DATABASE;
ORA-01153: an incompatible media recovery is active
*** solution:
SQL>STARTUP NOMOUNT
SQL>ALTER DATABASE MOUNT STANDBY DATABASE;
SQL> SELECT open_mode,database_role FROM v$database;
OPEN_MODE DATABASE_ROLE
——————– —————-
MOUNTED PHYSICAL STANDBY
SQL> RECOVER AUTOMATIC STANDBY DATABASE;