Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HP MC / Service Guard / Oracle 8i
Hi
> Can you give an example for that "package-thing"? Do you mean that I
> after I connected to an oracle-instance I always have to call the
> package within each statement? Can't believe that!
I think Jim doesn't know what he's exactly talking about.
The issue is, that with RAC, the sessions in surviving node will continue normally, but when you have non-RAC conf., you just have to start up the instance on backup node - therefore all the package states are reset, since all sessions have to be created again.
The package states are in UGA, that is in the instance, it has nothing to do with write access to disk.
So, this standby server gives you a chance of starting up your DB in a minute after crash, instead of several hours of waiting for fixing the primary server. In addition, it can help you with some maintenance work as recovery testing, upgrade (testing) and stuff, if you got mirrored disk storage or BCVs.
Tanel. Received on Thu Feb 27 2003 - 12:17:12 CST