Home » Server Options » Data Guard » DG new branch issue (Oracle 10.2.0.4, sun os 5.1)
DG new branch issue [message #533171] Mon, 28 November 2011 10:24 Go to next message
snowball
Messages: 229
Registered: April 2006
Location: China
Senior Member

Hi, guys
We have a Dataguard( primary + physical standby ).
But these days, we found new brach log on alert:

There are two resetlog id in log:
Sat Nov 26 18:18:06 2011
Media Recovery Log /arc/1_13317_689941847.arc
Sat Nov 26 18:19:26 2011
Media Recovery Waiting for thread 1 sequence 13318 (in transit)
Sat Nov 26 20:30:44 2011
RFS[3]: Archived Log: '/arc/1_81_764419099.arc'
RFS[3]: Physical Standby in the future of Branch(resetlogs_id) 764419099
RFS[3]: Standby database SCN: 0:730877852  Primary branch SCN: 0:130703575
RFS[3]: New Archival REDO Branch(resetlogs_id): 764419099  Prior: 689941847
RFS[3]: Archival Activation ID: 0xe5c8751 Current: 0x9ebbe93
RFS[3]: Effect of primary database OPEN RESETLOGS
RFS[3]: Managed Standby Recovery process is active
Primary database is in MAXIMUM PERFORMANCE mode
Sat Nov 26 22:07:08 2011
RFS[5]: Archived Log: '/arc/1_13318_689941847.arc'
RFS[5]: Physical Standby in the future of Branch(resetlogs_id) 689941847
RFS[5]: Standby database SCN: 0:730877852  Primary branch SCN: 0:543066
RFS[5]: New Archival REDO Branch(resetlogs_id): 689941847  Prior: 764419099
RFS[5]: Archival Activation ID: 0x9ebbe93 Current: 0x9ebbe93
RFS[5]: Effect of primary database OPEN RESETLOGS
RFS[5]: Managed Standby Recovery process is active
Primary database is in MAXIMUM PERFORMANCE mode
Sat Nov 26 22:07:13 2011
Media Recovery Log /arc/1_13318_689941847.arc
Sat Nov 26 22:08:17 2011
Media Recovery Waiting for thread 1 sequence 13319 (in transit)



While query incarnation of each db we found:

primary:
RMAN> list incarnation;

using target database control file instead of recovery catalog

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       ACCDB    166427283        PARENT  1          04-APR-08
2       2       ACCDB    166427283        CURRENT 543066     19-JUN-09


standby:
RMAN> list incarnation;

using target database control file instead of recovery catalog

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       ACCDB    166427283        PARENT  1          04-APR-08
2       2       ACCDB    166427283        CURRENT 543066     19-JUN-09
3       3       ACCDB    166427283        ORPHAN  130703575  13-OCT-11




Has anyone met this kind of problem?
Please give me some hints.

Thanks very much.
Re: DG new branch issue [message #534583 is a reply to message #533171] Wed, 07 December 2011 09:15 Go to previous messageGo to next message
snowball
Messages: 229
Registered: April 2006
Location: China
Senior Member

It turn out to be a bug start from 10.2.0.3.
Re: DG new branch issue [message #534592 is a reply to message #534583] Wed, 07 December 2011 10:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback.
Have you the bug number?

Regards
Michel
Re: DG new branch issue [message #534618 is a reply to message #534592] Wed, 07 December 2011 17:32 Go to previous messageGo to next message
snowball
Messages: 229
Registered: April 2006
Location: China
Senior Member

yes. bug 9201442.
Re: DG new branch issue [message #534624 is a reply to message #534618] Wed, 07 December 2011 23:09 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks
Michel
Previous Topic: How does Grid instantiate physical standby
Next Topic: Dataguard steps
Goto Forum:
  


Current Time: Thu Mar 28 16:48:46 CDT 2024