Re: ORA-16040 error when working in Dataguard Environment

>> This really is version dependent. We can see that on your version and
>> configuration RFS is fairly compliant, it sees a locked file and tries
>> again. On your production side, you can see Oracle has started up two
>> archive processes. It's a good thing that the ARC0 process sees the
>> ARC0 process has already archived 6690. Wait a minute - that's the
>> same process!

>> ORA-16040 is supposed to mean you have duplicate definitions on the
>> primary, leading to duplicate RFS processes on the standby. I don't
>> see that in your definitions, but I'm wondering if perhaps an extra one
>> was floating about from a previous shutdown?

Nope. Always check for ora_ processes before I experiment with another startup.

>> Have you done any switchovers?

Just about too - but noticing this made me stop.

>> Anyways, since it fixed itself, you are ok. You may want
>> to ask support anyways, there might be something else they know about.

Thanks. I dug on metalink and really didn't find anything.

>> Please remember to state versions and platforms and all relevant
>> configuration information.

Sorry - I forgot!
HP-UX 11i
Oracle 9.2.0.4

Thanks for the feedback.
Vince Received on Wed Oct 18 2006 - 10:18:00 CDT