Re: Active Dataguard and Oracle Applications (Ebiz)
- From: Kumar Madduri <ksmadduri@xxxxxxxxx>
- To: Naqi Mirza <naqimirza@xxxxxxxxx>
- Date: Wed, 1 Sep 2010 10:56:58 -0700
Thank you all for your responses.
After I sent the mail, I realized that active data guard does not work for
ebiz at all (even not bothering about licensing). Even a simple concurrent
manager start requires to submit a concurrent request which inserts a record
in fnd_concurrnet_requests and also the login processes itself has to insert
a record in to icx_sessions.
Thank you again
Kumar
On Wed, Sep 1, 2010 at 10:14 AM, Naqi Mirza <naqimirza@xxxxxxxxx> wrote:
> I forgot to mention should you go the flasback route you may want to
> validate from oracle support whether they support this.
>
>
> *From:* Naqi Mirza <naqimirza@xxxxxxxxx>
> *To:* ksmadduri@xxxxxxxxx; oracle Freelists <Oracle-L@xxxxxxxxxxxxx>
> *Sent:* Wed, 1 September, 2010 22:04:45
> *Subject:* Re: Active Dataguard and Oracle Applications (Ebiz)
>
> It will depend on how you plan to use active data guard with ebs. If you
> have read only reports that connect to the applications schema this should
> work - however if you are looking to configure an applications tier with
> this database and connect via the applications it will not - logging via an
> application user requires write access. Additionally the act of running a
> concurrent request inserts records into various fnd_ based tables.
> On a side note, if you do not need up to date data why not look into a
> snapshot standby instead.Or if you're on 10gR2, configure flashback for your
> standby open it read write - once you're done flash back and restart
> mrp...of course snapshot standby in 11g makes this easier for you to do.
>
>
> *From:* Kumar Madduri <ksmadduri@xxxxxxxxx>
> *To:* oracle Freelists <Oracle-L@xxxxxxxxxxxxx>
> *Sent:* Wed, 1 September, 2010 17:23:45
> *Subject:* Active Dataguard and Oracle Applications (Ebiz)
>
> Hello
> Has anyone enabled Active Dataguard in Oracle Applications ?
> I have gone through the white paper and presentation at
>
> http://www.oracle.com/technetwork/database/features/performance/s291920-meekssmith-130511.pdf
> and
>
> http://www.oracle.com/technetwork/database/features/availability/maa-wp-11gr1-activedataguard-1-128199.pdf
>
> Both of them dont talk about Ebusiness. May be it really does not matter
> and hence no mention of that. I just want to see if anyone out there has
> implemented this and any known issues.
>
> *Also, another related question was regarding licensing. The presentation
> mentions*
>
> *•Active Data Guard license is required when using either: *
>
> *•Real-time Query *
>
> *•RMAN block-change tracking on a standby database*
>
> I am not planning to set this active dataguard setup with either real time
> query or RMAN block change tracking. So I dont require a separate license
> for it. Is this correct?
>
> I dont want to use Real-time query because if I can set it up sucessfully,
> I wan to use it to divert our reporting users and they need a day's old of
> data (dont have to be real time).
>
> I dont need RMAN block-change tracking because I am not going to offload my
> backups to Standby (as of now).
>
>
>
> Thank you
>
> Kumar
>
>
>
>
>
Other related posts:
