Re: Active Dataguard and Oracle Applications (Ebiz)
- From: Naqi Mirza <naqimirza@xxxxxxxxx>
- To: ksmadduri@xxxxxxxxx, oracle Freelists <Oracle-L@xxxxxxxxxxxxx>
- Date: Wed, 1 Sep 2010 10:04:45 -0700 (PDT)
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:
