Hi,
I have a Primary database emadb and Physical Standby Database emadbdg.
This is the error when I am starting the Managed Recovery Process on the standby database.
Managed Standby Recovery not using Real Time Apply
Slave exiting with ORA-19909 exception
Errors in file /opt/app/oracle/diag/rdbms/emadbdg/emadbdg/trace/emadbdg_pr00_24135.trc:
ORA-19909: datafile 1 belongs to an orphan incarnation
ORA-01110: data file 1: '/opt/app/oracle/oradata/emadbdg/system01.dbf'
I performed an incremental backup of the Physical Standby Database using RMAN and now the archive logs are not getting applied.
The Archive Logs are not getting applied on the Physical Standby
SQL> select thread#,max(sequence#) from v$archived_log where applied='YES' group by thread#;
no rows selected
SQL> select thread#,max(sequence#) from v$archived_log group by thread#;
THREAD# MAX(SEQUENCE#)
---------- --------------
1 82