RE:

On Unix, you can back up the installation directory. If you need to go back to the old version, put the old directory back. You can use tape, tar, cpio, cp, etc. to do this.

Example 1
cd /path/here/product
tar cvf /path/elsewhere/old817.tar 8.1.7 (assuming 8.1.7 is the directory to back up)
If you want, you can compress the resulting tar file.

Example 2
cd /path/here/product/8.1.7
find . -print | cpio -pvmud /path/elsewhere/8.1.7

If you find that you need to go back to the old version, just restore your backup.

> -----Original Message-----
> From: Scott Stefick [mailto:sstefick_at_harper.cc.il.us]
> Sent: Tuesday, December 03, 2002 1:21 PM
> To: Multiple recipients of list ORACLE-L
> Subject:
>
>
> Gurus,
>
> I was just given a project to maintain a Computerized Maintenance
> Management System. When I asked the companies support staff
> how to roll
> back patches in the backend Oracle Database (Ver. 8174), they
> said that
> there was no way to do this. I'm guessing I could use
> logminer just incase
> a patch doesn't work. Would this be a good solution, or are
> there other
> (better) ways of safeguarding myself when it comes to
> patching? Obviously,
> I will be applying the patches to a test instance first, but
> I don't want
> to have to go back to restore from a backup if the patch
> causes unexpected
> issues.
>
> TIA!
>
>
> ******************************************
> Scott Stefick
> UNIX Systems Administrator
> Oracle Certified Professional DBA
> Wm. Rainey Harper College
> 847.925.6130
> ******************************************
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Scott Stefick
> INET: sstefick_at_harper.cc.il.us
>
> 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.com
-- 
Author: Stephen Lee
  INET: slee_at_dollar.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).