RE: PeopleSoft and Logical Standby
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.
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
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_at_gmail.com]
Sent: Friday, February 13, 2009 3:02 PM
To: Li Li
Cc: info_at_go-faster.co.uk; 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
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.
On Thu, Feb 12, 2009 at 6:44 PM, Li Li <litanli_at_gmail.com> wrote:
Thanks Richard, Steve and David for your reply!
On Wed, Feb 11, 2009 at 5:06 PM, David Kurtz <info_at_go-faster.co.uk> 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
> via the PIA (although it may not be desirable).
> David Kurtz
> Go-Faster Consultancy Ltd.
> tel: +44 (0)7771 760660
> fax: +44 (0)7092 348865
> web: www.go-faster.co.uk
> Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
> DBA Blogs: PeopleSoft: http://blog.psftdba.com, Oracle:
> PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of steve montgomerie
> Sent: Wednesday, February 11, 2009 6:21 PM
> To: litanli_at_gmail.com
> 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
> update with last login everytime a user logs in.
> On Wed, Feb 11, 2009 at 11:40 AM, Li Li <litanli_at_gmail.com> 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