RE: PeopleSoft and Logical Standby
- From: "David Kurtz" <info@xxxxxxxxxxxxxxx>
- To: "'steve montgomerie'" <stmontgo@xxxxxxxxx>, "'Li Li'" <litanli@xxxxxxxxx>
- Date: Fri, 13 Feb 2009 15:32:50 -0000
TAF is a RAC thing, it only works for queries, not transaction, and it won't
work with PeopleSoft because it has to be built into the client.
regards
_________________________
David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
mailto:david.kurtz@xxxxxxxxxxxxxxx
web: www.go-faster.co.uk
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
<http://www.psftdba.com/>
DBA Blogs: PeopleSoft: http://blog.psftdba.com <http://blog.psftdba.com/> ,
Oracle: http://blog.go-faster.co.uk <http://blog.go-faster.co.uk/>
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba
_____
From: steve montgomerie [mailto:stmontgo@xxxxxxxxx]
Sent: Friday, February 13, 2009 3:02 PM
To: Li Li
Cc: info@xxxxxxxxxxxxxxx; oracle-l
Subject: Re: PeopleSoft and Logical Standby
Importance: High
Been thinking about this.
We run PS with two physical standby's. One local and one remote. I've cycled
through them
before and everything works nicely. At a low level you simply update the
tnsnames. You can get fancy and employ Transparent Application Failover
(TAF) which is on my list of to-do's.
Just curious, what would you use the logical standby for? In a perfect world
I'd like to point
our PS Query Users at the logical standby which of course is not possible.
We are implementing Oracle Business Intelligence with HR Analtyics which
requires periodic loads from production. For this I am considering
converting the physical standby into a logical standby and then doing the
data loads against the standby as opposed to production.
Steve
On Thu, Feb 12, 2009 at 6:44 PM, Li Li <litanli@xxxxxxxxx> wrote:
Thanks Richard, Steve and David for your reply!
On Wed, Feb 11, 2009 at 5:06 PM, David Kurtz <info@xxxxxxxxxxxxxxx> wrote:
> If you are using logical standby there is nothing to prevent you updating
> tables on the target. So I don't see why you couldn't log into that
standby
> via the PIA (although it may not be desirable).
>
> regards
> _________________________
> David Kurtz
> Go-Faster Consultancy Ltd.
> tel: +44 (0)7771 760660
> fax: +44 (0)7092 348865
> mailto:david.kurtz@xxxxxxxxxxxxxxx
> web: www.go-faster.co.uk
> Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
> DBA Blogs: PeopleSoft: http://blog.psftdba.com, Oracle:
> http://blog.go-faster.co.uk
> PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba
>
>
>
> ________________________________
> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of steve montgomerie
> Sent: Wednesday, February 11, 2009 6:21 PM
> To: litanli@xxxxxxxxx
> Cc: oracle-l
> Subject: Re: PeopleSoft and Logical Standby
> Importance: High
>
> I'm not sure that you would even be able to login as I believe psoprdefn
is
> update with last login everytime a user logs in.
>
> On Wed, Feb 11, 2009 at 11:40 AM, Li Li <litanli@xxxxxxxxx> wrote:
>>
>> Hi, List,
>>
>> Has anybody implemented Logical Standby for PeopleSoft database? From
>> oracle documentation, logical standby doesn't support certain data
>> types (collections, user-defined types, etc) and DDLs, I am wondering
>> if this would prevent from implementing logical standby for peoplesoft
>> databases.
>>
>> Thanks,
>> -Li
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>
>
Other related posts:
