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 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: 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).