RE: Apps 11.5.9 Disater Recovery Site

Ron,

I entirely agree with Stephen. Apps is a different beast when it comes to such stuff. Overall, the issues with incomplete recovery (i.e. recovery to a previous point in time), especially in a complex, integrated ERP system such as Oracle Apps 11i are many. You should only restore to a point in time as a very last resort. Depending on modules and interfaces that were active at the time of recovery, you would probably have system generated numbers (PO's ,Invoices, etc) that have been created and _already_ sent to customers and suppliers. As well, many ERP systems send out (and receive) EDI data from other external systems. Coordination of this could be a logistical nightmare when you perform an incomplete recovery. This needs to be understood and documented, otherwise you might end up having to "fix" complex data issues. The key words are "Documentation/Understanding of Processes" and "Change Control"....

Happy New Year all!
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)

Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available!

• The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **

>-----Original Message-----
>From: Karniotis, Stephen [mailto:Stephen_Karniotis_at_compuware.com]
>Sent: Tuesday, December 30, 2003 4:09 PM
>To: Multiple recipients of list ORACLE-L
>Subject: RE: Apps 11.5.9 Disater Recovery Site
>
>
>Ron:
>
> I would definitely not suggest ignoring adpatch. Should you
>actually need
>to use this DR site and something went wrong, Oracle may not
>offer you any
>help. If rsync can offer you 100% replication than I would try it and
>validate it. However, applications is a much different beast
>than just the
>database. File system names, node names, database names, tns names,
>userids, passwords, etc. are embedded within the code and are
>very difficult
>to change. It would be best to take a complete image copy of
>the database
>environment, the apps environment and then use adpatch and
>adadmin to verify
>the environment once completed.
>
>Thank You
>
>Stephen P. Karniotis
>Technical Alliance Manager
>Compuware Corporation
>Direct: (313) 227-4350
>Mobile: (248) 408-2918
>Email: Stephen.Karniotis_at_Compuware.com
>Web: www.compuware.com
>
> -----Original Message-----
>Ron Thomas
>Sent: Tuesday, December 30, 2003 6:35 PM
>To: Multiple recipients of list ORACLE-L
>Subject: Apps 11.5.9 Disater Recovery Site
>
>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).
>
>
>
>The contents of this e-mail are intended for the named
>addressee only. It
>contains information that may be confidential. Unless you are the named
>addressee or an authorized designee, you may not copy or use
>it, or disclose
>it to anyone else. If you received it in error please notify
>us immediately
>and then destroy it.
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Karniotis, Stephen
> INET: Stephen_Karniotis_at_compuware.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: John Kanagaraj
  INET: john.kanagaraj_at_hds.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).