Data Guard 11G R2
845641Jun 18 2012 — edited Jun 29 2012Im on linux rhel5 Data Guard 11G R2
My primary database was mn1 first but now it is standby... I did a failover from mn1 to mn2.. Now mn2 is primary... now the problem is mn1 .. mn1 which is now the new standby is not able to apply archives means to say not able to be a proper standby...
MN1>alter database recover managed standby database disconnect from session;
Database altered.
MN1>select sequence#,applied from v$archived_log;
SEQUENCE# APPLIED
---------
4 NO
5 NO
3 NO
8 NO
7 NO
6 NO
9 NO
10 NO
11 NO
12 NO
below are alert log contents
[oracle@localhost ~]$ tailf /u01/app/oracle/diag/rdbms/mn1/mn1/trace/alert_mn1.log
ORA-01110: data file 1: '/u01/app/oracle/oradata/mn1/system01.dbf'
Errors in file /u01/app/oracle/diag/rdbms/mn1/mn1/trace/mn1_mrp0_6567.trc:
ORA-19909: datafile 1 belongs to an orphan incarnation
ORA-01110: data file 1: '/u01/app/oracle/oradata/mn1/system01.dbf'
Completed: alter database recover managed standby database disconnect from session
Mon Jun 18 22:22:00 2012
RFS[3]: Assigned to RFS process 6589
RFS[3]: Identified database type as 'physical standby': Client is ARCH pid 4918
Mon Jun 18 22:22:12 2012
MRP0: Background Media Recovery process shutdown (mn1)