Re: Apps 11.5.9 Disater Recovery Site
Hi Tanel- I've been doing 11.5 cloning for several years and think I've found most (but I'm sure not all) of the database and filesystem changes required. adpatch is what concerns me the most since it requires a database connection to function. It can't connect to the DR database since it will be in a recovery mode. I'm thinking that setting the two_task to a service that points back to the production system would work. You bring up an interesting question though. c, d, and g drivers are very specific in the functions they perform. Now that Oracle is moving to the u driver, I'll need to look into this. I was looking at rsync as an alternative to the above. rsync would also be used to transfer the concurrent reports (/.../common/out) to the DR system (don't know if management want this yet or not). Time for coffee not sure if I'm making sence yet. Thanks, Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] ail.ee To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Re: Apps 11.5.9 Disater Recovery Site .com 12/30/2003 05:44 PM Please respond to ORACLE-L One issue popped into my mind with patching disaster recovery: When you're patching your primary system, have applied all c g and d drivers (or an u driver) and a disaster occurs, then your secondary site might remain in inconsistent state e.g. database objects have the new version, but corresponding $APPL_TOP ones are old, because they're not rsynced yet. Or the opposite - when rsync has been done, but you have to do a point in time recovery to the point before d-patch application in secondary site. And of course, don't forget to simulate and test the disaster, several times, if possible. Without warning, if possible ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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 [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan -- Please see
Re: Apps 11.5.9 Disater Recovery Site
Hi! I've been doing 11.5 cloning for several years and think I've found most (but I'm sure not all) of the database and filesystem changes required. Yep, in older 11.5's you had to manually modify conf files and profile options, but starting from 11.5.7 you have autoconfig with installation, so you don't have to searchmodify any config files manually anymore, just modify the context xml file with editcontext and run adadcfg utility to apply the changes to corresponding places (don't remember the utility name exactly). You can and should use autoconfig in older versions than 11.5.7 as wel, but you have to install it using a patch. adpatch is what concerns me the most since it requires a database connection to function. It can't connect to the DR database since it will be in a recovery mode. I'm thinking that setting the two_task to a service that points back to the production system would work. You bring up an interesting question though. c, d, and g drivers are very specific in the functions they perform. Now that Oracle is moving to the u driver, I'll need to look into this. Why do you want to patch anything at disaster recovery site at all? When you apply any d-patches in primary, their changes will be transferred to secondary via redologs. When you apply any cg-patches in primary, you just use rsync to synchronize all changes to secondary site file system as well. There is no need for running adpatch in secondary site at all. Happy new year! Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Apps 11.5.9 Disater Recovery Site
Hi again- Why do you want to patch anything at disaster recovery site at all? When you apply any d-patches in primary, their changes will be transferred to secondary via redologs. When you apply any cg-patches in primary, you just use rsync to synchronize all changes to secondary site file system as well. There is no need for running adpatch in secondary site at all. This is what I was thinking as well. Just wondering if anyone had done this. Have a good New Years Ron Thomas Hypercom, Inc [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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
Re: Apps 11.5.9 Disater Recovery Site
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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Apps 11.5.9 Disater Recovery Site
One issue popped into my mind with patching disaster recovery: When you're patching your primary system, have applied all c g and d drivers (or an u driver) and a disaster occurs, then your secondary site might remain in inconsistent state e.g. database objects have the new version, but corresponding $APPL_TOP ones are old, because they're not rsynced yet. Or the opposite - when rsync has been done, but you have to do a point in time recovery to the point before d-patch application in secondary site. And of course, don't forget to simulate and test the disaster, several times, if possible. Without warning, if possible ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).