Re: Degrade a database??
If I wanted to degrade a database, I'd take it out to a cheap pub, get it drunk, and let it make a fool of itself on the dancefloor before taking it home for some wild bedroom scenes... Next morning, rest assured, the database will roll over in your bed and exclaim: I'll feel so degraded :-) --- [EMAIL PROTECTED] wrote: Hello All, We are in the process of upgrading a database from 8.0.6 to 8.1.7. The upgrade is not a problem. We have been asked to come out with a fast rollback strategy in case we have to fall back, say after a week, to the 8.0.6 database with no data loss. Any fresh ideas? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: Degrade a database??
Title: RE: Degrade a database?? I have no fresh ideas but how about keeping a file system backup of your oracle installation and 3 copies (in different locations of course) of a complete cold backup before the upgrade? Or copy the existing database on a similar but separate machine, ready to be brought up, all you need is TNS change. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Re: Degrade a database??
Reminds of a user who wanted to ungrade to Win98. They didn't know how right they were. Rajesh.Rao @jpmchase.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: rootcc: Subject: Re: Degrade a database?? 09/27/2002 12:23 PM Please respond to ORACLE-L Of course, I meant downgrade. Could you hire me to work for you? ;-) Connor McDonald To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] hamcdc@yahoocc: .co.uk Subject: Re: Degrade a database?? Sent by: root@fatcity. com September 27, 2002 05:28 AM Please respond to ORACLE-L If I wanted to degrade a database, I'd take it out to a cheap pub, get it drunk, and let it make a fool of itself on the dancefloor before taking it home for some wild bedroom scenes... Next morning, rest assured, the database will roll over in your bed and exclaim: I'll feel so degraded :-) --- [EMAIL PROTECTED] wrote: Hello All, We are in the process of upgrading a database from 8.0.6 to 8.1.7. The upgrade is not a problem. We have been asked to come out with a fast rollback strategy in case we have to fall back, say after a week, to the 8.0.6 database with no data loss. Any fresh ideas? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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.com -- Author: Thomas Day 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).
Degrade a database??
Hello All, We are in the process of upgrading a database from 8.0.6 to 8.1.7. The upgrade is not a problem. We have been asked to come out with a fast rollback strategy in case we have to fall back, say after a week, to the 8.0.6 database with no data loss. Any fresh ideas? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Degrade a database??
1. Do not use any 8.1.7 specific features after the upgrade. 2. Take a cold backup while at 8.1.7 3. Run the downgrade script from $O_H/rdbms/admin directory (d0800060.sql). 4. Backup 5. Rollback your changes to all other scripts/files ($O_H, listener file etc..etc..) Best approach: Create a test 8.0.6 database, upgrade it to 8.1.7, make and record a few changes to it. Downgrade it and make sure all the changes are still there. And you understand what you are doing. To CYA even more: Call Oracle Support/Log an iTAR and have them send you the exact steps for such a downgrade :) Good luck. - Kirti -Original Message- Sent: Thursday, September 26, 2002 1:48 PM To: Multiple recipients of list ORACLE-L Hello All, We are in the process of upgrading a database from 8.0.6 to 8.1.7. The upgrade is not a problem. We have been asked to come out with a fast rollback strategy in case we have to fall back, say after a week, to the 8.0.6 database with no data loss. Any fresh ideas? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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.com -- Author: Deshpande, Kirti 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: Degrade a database??
Title: RE: Degrade a database?? I can't think of any better way to back out of anything other than a restore from disk or tape. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 2:48 PM To: Multiple recipients of list ORACLE-L Subject: Degrade a database?? Hello All, We are in the process of upgrading a database from 8.0.6 to 8.1.7. The upgrade is not a problem. We have been asked to come out with a fast rollback strategy in case we have to fall back, say after a week, to the 8.0.6 database with no data loss. Any fresh ideas? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Degrade a database??
and set COMPATIBLE = 8.0.6 to keep out new features. Henry -Original Message- Kirti Sent: Thursday, September 26, 2002 3:18 PM To: Multiple recipients of list ORACLE-L 1. Do not use any 8.1.7 specific features after the upgrade. 2. Take a cold backup while at 8.1.7 3. Run the downgrade script from $O_H/rdbms/admin directory (d0800060.sql). 4. Backup 5. Rollback your changes to all other scripts/files ($O_H, listener file etc..etc..) Best approach: Create a test 8.0.6 database, upgrade it to 8.1.7, make and record a few changes to it. Downgrade it and make sure all the changes are still there. And you understand what you are doing. To CYA even more: Call Oracle Support/Log an iTAR and have them send you the exact steps for such a downgrade :) Good luck. - Kirti -Original Message- Sent: Thursday, September 26, 2002 1:48 PM To: Multiple recipients of list ORACLE-L Hello All, We are in the process of upgrading a database from 8.0.6 to 8.1.7. The upgrade is not a problem. We have been asked to come out with a fast rollback strategy in case we have to fall back, say after a week, to the 8.0.6 database with no data loss. Any fresh ideas? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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.com -- Author: Deshpande, Kirti 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.com -- Author: Henry Poras 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).