Re: Apps 11.5.9 Disater Recovery Site

Ron,

Tanel and John have definitely covered the various inherent risks and challenges with Oracle Apps DR sites and I would strongly advise you to read all the references that Tanel pointed out as an Apps database is definitely the most complex and challenging I have worked with when it comes to DR sites, especially the 'nologging' aspect.

Something that worked very well for us to get around the host names being stored everywhere in the file system and database is to use logical host names that you can change on the DNS and /etc/hosts file on the fly when required. This is also useful when you later implement fail over solutions like MC/Serviceguard or even just manual failover. Logical host names will save you endless debugging adventures, especially when Oracle "introduces" a new profiles setting or file in a patch that stores the host name and your post-refresh script misses this one...8-0

Good Luck!

Faan

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, December 30, 2003 4:34 PM

> Hi!
>
> You can just copy over the Apps filesystem (providing that the directory
> structures are exactly the same) and relink all executables. This is the
> easiest way to do it, you don't have to start hacking with adpatch. Rsync
> should do fine, although I've used regular tar so far.
>
> Note that if you want to start up Apps on your secondary node, then you
have
> either to give it the original hostname (via DNS) or use autoconfig to
> change Apps hostname (the web links etc) before starting up Apps (note
that
> datbaase has to be open and TWO_TASK has to point to it, so autoconfig can
> change proper ICX profiles).
>
> Theres a metalink doc Apps disaster recovery: 216212.1
> Also you should search for "applications nologging" from metalink to see
> some issues with nologging operations in Apps.
>
> Tanel.
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, December 31, 2003 1:34 AM
>
>
> > I've been charged with bringing up a disaster recovery site, so time to
> hit the books again as a lot
> > has changed since the last time I did this. Looking for resource
> recommendations (FM to read, white
> > papers, etc).
> >
> > Sticky part of this is it is an Applications 11.5.9 installation. The
> database end of it should not
> > be too difficult (8.1.7.4, soon to be 9.2.0.4), but the applications
file
> system is modified by the
> > adpatch utility which adpatch requires a database connection to
function.
> I can think of 2 ways to
> > get around this requirement.
> > 1. set the two_task to point to a live test system, and run adpatch
force
> using the c and g drivers.
> > The d driver would not need to be run since the changes will come over
via
> the archive logs.
> > 2. ignore adpatch utility completely and use rsync.
> >
> > Suggestion, comments?
> >
> > Thanks,.
> > Ron Thomas
> > Hypercom, Inc
> > rthomas_at_hypercom.com
> > Each new user of a new system uncovers a new class of bugs. -- Kernighan
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Ron Thomas
> > INET: rthomas_at_hypercom.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Tanel Poder
> INET: tanel.poder.003_at_mail.ee
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Faan DeSwardt
  INET: faan_at_sbcglobal.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).