How to convert a Logical Standby DB to a Primary
Hi,
I have an issue with our Data Guarded cluster (two nodes, one Primary and one Logical Standby Oracle 10i DBs running on HP-UX 11.23)
The issue is that for some reasons the Primary and the Standby are out of sync in terms of archive log sequences.
For instance the primary shows:
Date: Feb-27-2009 14:02:33
ID DESTINATION STATUS ARCHIVED_THREAD# ARCHIVED_SEQ#
--- -------------------------------- --------- ---------------- -------------
1 /db05/oradata/NSMS/archive/ VALID 1 864
2 stdby VALID 1 10
3 /db05/oradata/NSMS/archive/DR/ VALID 1 11
11 /db05/oradata/NSMS/archive/DR/ VALID 1 864
*
Report on Redo Log Gaps between Primary and Standby.
Date : Feb-27-2009 14:02:33
LAST_SEQ_RECD LAST_SEQ_SENT
------------- -------------
863 864
But the STANDBY shows in the alert log:
LOGMINER: Begin mining logfile: /db05/oradata/NSMS/archive/DR/arch673877647_1_304.log
Fri Feb 27 12:51:36 2009
LOGMINER: End mining logfile: /db05/oradata/NSMS/archive/DR/arch673877647_1_304.log
Fri Feb 27 12:51:36 2009
LOGMINER: Begin mining logfile: /db05/oradata/NSMS/archive/DR/arch673877647_1_305.log
Fri Feb 27 12:51:39 2009
LOGMINER: End mining logfile: /db05/oradata/NSMS/archive/DR/arch673877647_1_305.log
since the DBA_LOGSTDBY_LOG contains on the STANDBY:
$ is_db_apply_current.sh
1 300 595040838 595042886 YES
1 301 595042886 595042919 YES
1 302 595042919 595096418 CURRENT
1 303 595096418 595127201 CURRENT
1 304 595127201 595159342 CURRENT
1 305 595159342 595207457 CURRENT
At this point I don't know how to cleanup the situation on the Standby.
I tried to resync completely form primary copying all datafiles and archives but still cannot reset the archive sequence on the STANDBY, so that it keeps looking for the wrong archives.
Thanks in advance !
Mike