| Can't start primary DB with ora-16649 [message #200239] |
Sun, 29 October 2006 20:07  |
lme58
Messages: 4
Registered: April 2006
Location: USA
|
Junior Member |
|
|
I have two node running Oracle 10g and data guard. After both primay and standby database down, I can't start primary database and get error of
ora -16649: database will open after Data Guard broker has evaluated Fast-Start Failover status
When checking fast-start failover status, it shows unsynchronized.
How do I fix the problem to start and open primary? I can start standby in read-only mode. Thanks.
JC
|
|
|
|
| Re: Can't start primary DB with ora-16649 [message #200380 is a reply to message #200239] |
Mon, 30 October 2006 10:21  |
ualual
Messages: 22
Registered: May 2005
|
Junior Member |
|
|
jc
version ? 10.2.0.2
with what patch? 5604010 which came out today
or
patch 5502226 ?
--
simple question, is the OBSERVER running?
dgmgrl> start observer
--
I had a really long weekend fighting Data Guard, Data Guard Broker.
Bottom line, make sure all the FLASHBACK parameters are set on both primary and secondary.
I had them set correctly,but I did not set "SCOPE=BOTH" on a number of my "alter database flashback..." therefore, when i did a reboot on the database, lost a number of parameters setting.
--
Another shot:
on the broker side,
dgmgrl> disable fast_STart failover;
what is the output: disable?
dgmgrl> enable fast_STart failover;
what is the output?
p-
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
