RE: Degrade a database??

From: Amr Hambazaza <AHambazaza_at_memc.com>
Date: Fri, 27 Sep 2002 08:56:16 -0800
Message-ID: <F001.004DB3E6.20020927085616@fatcity.com>

Raj,

if it is a smallish database (or it is running on a fast server). You might be able to create a separate 8.0.6 instance and leave it running with all the accounts tablespaces etc. Then if the need arises you do an export from the new version and import into the old version with the full option. If that will take too long, you can perform the Downgrade procedure as specified in chapter 13 of the Oracle 8.1.7 Migration book (id A86632-01). This describes going through a downgrade by basically removing the incompatible parameters and running the cat*.sql scripts again for the older version, check out the document though as this is a lengthy procedure and needs a bit of planning ahead, for cold backups and what not.

Good luck,
Amr

                                                                                                                                       
                      Rajesh.Rao_at_jpmch                                                                                                 
                      ase.com                  To:      Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                    
                      Sent by:                 cc:                                                                                     
                      root_at_fatcity.com         Subject: RE: Degrade a database??                                                       
                                                                                                                                       
                                                                                                                                       
                      09/27/02 11:18                                                                                                   
                      AM                                                                                                               
                      Please respond                                                                                                   
                      to ORACLE-L

Raj,

The customer needs a fallback strategy with "no data loss" upto 3 weeks after the cutover.

Thanks
Raj

One attachment (0k)

                    "Jamadagni,

                    Rajendra"                  To:     Multiple recipients
of list ORACLE-L <ORACLE-L_at_fatcity.com>
                    <Rajendra.Jamadagni        cc:

                    @espn.com>                 Subject:     RE: Degrade a
database??
                    Sent by:

                    root_at_fatcity.com



                    September 27, 2002

                    10:18 AM

                    Please respond to

                    ORACLE-L

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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: Rajesh.Rao_at_jpmchase.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.com
-- 
Author: Amr Hambazaza
  INET: AHambazaza_at_memc.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).

Received on Fri Sep 27 2002 - 11:56:16 CDT