Re: Active Dataguard and Oracle Applications (Ebiz)

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: