Re: Active Dataguard and Oracle Applications (Ebiz)

  • From: Naqi Mirza <naqimirza@xxxxxxxxx>
  • To: naqimirza@xxxxxxxxx, ksmadduri@xxxxxxxxx, oracle Freelists <Oracle-L@xxxxxxxxxxxxx>
  • Date: Wed, 1 Sep 2010 10:14:19 -0700 (PDT)

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 
>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 
>standby instead.Or if you're on 10gR2, configure flashback for your standby 
>it read write - once you're done flash back and restart mrp...of course 
>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)
>>Has anyone enabled Active Dataguard in Oracle Applications ? 
>>I have gone through the white paper and presentation at
>>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 
>>this and any known issues.
>>Also, another related question was regarding licensing. The presentation 
>>•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 
>>or RMAN block change tracking. So I dont require a separate license for it. 
>>this correct?
>>I dont want to use Real-time query because if I can set it up sucessfully, I 
>>to use it to divert our reporting users and they need a day's old of data 
>>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


Other related posts: