Re: PeopleSoft and Logical Standby

From: steve montgomerie <stmontgo_at_gmail.com>
Date: Tue, 17 Feb 2009 10:43:36 -0500
Message-ID: <5d4504220902170743s52411035r509321cf04f30fab_at_mail.gmail.com>

In terms of Li Li's original question I'm not so sure that a logical standby would be a great idea for PS to help with rolling upgrades.

For a physical standby though you may be able to avert down time associated with server patches, storage maintenance etc.

Now back to TAF. I finally got a test case going

I'm working off of this note

Subject:     Failover Connections for Data Guard Error with ORA-1033
      Doc ID:     461874.1     Type:     PROBLEM
      Modified Date:     04-APR-2008     Status:     PUBLISHED

My config is PS HR89 Demo database on Oracle 10.2.0.4 on OEL 4.6.

I have a primary on one server and a physical standby on another. All set up and managed
with dataguard through Grid control.

Here's what I did

Logged on to PS and navigated some screens

Initiated a switchover operation and waited for that to complete - took less than a minute

Revisited my PS web session and continued to navigate screens. I did not have to log in again. I continued
on from before the switchover operation.

Now for the unlucky person who is doing something transactional at the time of the switchover their transaction would be a do over. I still have more to test but I believe in this case the user would receive and error and a subsequent retry would be successful.

I still have to test process scheduler. For process scheduler I would be more inclined to simply shut it down
before the switchover, and thene depending upon the maintenance activity start it up aft the switchover or the switchback.

For example, Server Admin wants to apply server patch which he estimates would be 30 minutes. In this case shut down process scheduler, switchover, let admin apply patch, switch back and then restart process scheuler. Here at least on line access is not so encumbered. For a longer outage lasting say for example several hours then maybe start process scheduler on the standby.

Hope this is of interest, I am open to ideas for testing failover connections if anyone wants to propose some use cases.

Steve

On Fri, Feb 13, 2009 at 10:32 AM, David Kurtz <info_at_go-faster.co.uk> wrote:

> 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_at_go-faster.co.uk <david.kurtz_at_go-faster.co.uk>
> 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:* 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 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_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
>> 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_at_go-faster.co.uk
>> > 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_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
>> is
>> > 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
>> >> databases.
>> >>
>> >> Thanks,
>> >> -Li
>> >> --
>> >> http://www.freelists.org/webpage/oracle-l
>> >>
>> >>
>> >
>> >
>>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 17 2009 - 09:43:36 CST