Oracle-L: Re: Migration Suggestion.

From: Michael Boligan <michael.boligan.b_at_bayer.com>
Date: Tue, 26 Aug 2003 11:29:32 -0800
Message-ID: <F001.005CD4EE.20030826112932@fatcity.com>

This would be alot of extra work and downtime compared to export/import but...

upgrade to AIX 4.3.3 You might want to think about using AIX 64 bit here
(you can still run Oracle on 32 bit if you want).
upgrade to 8.1.7.4
AIX 4.3.3 is binary compatable with 5.1, so you _could do a cp.
If you are using LPAR you may want to go to 5.2 because you can use dynamic reconfig.

HTH,
Mike

                                                                                                                                        
                      <Avnish.Rastogi_at_prov                                                                                              
                      idence.org>                 To:       Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                 
                      Sent by:                    cc:                                                                                   
                      ml-errors_at_fatcity.co        Subject:  Migration Suggestion.                                                       
                      m                                                                                                                 
                                                                                                                                        
                                                                                                                                        
                      08/26/2003 01:39 PM                                                                                               
                      Please respond to                                                                                                 
                      ORACLE-L

I am looking for some expert suggestions for the migration of 300GB database to different hardware. Currently database is 816 OPS on AIX 4.1 nodes. Database is 32bit and performance on this system is really slow. Export for 2GB table takes 2 hours. All the data is on EMC symmetric. We are planning to migrate this database to AIX5.1 Oracle 8174 32Bit. Oracle 816 on AIX5.1 is not supported.
'Cause OS is different we cannot use redirect restore and apply archive logs to bring the database up.
Any suggestion regarding migration.

Thanks

DISCLAIMER:
This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <Avnish.Rastogi_at_providence.org
  INET: Avnish.Rastogi_at_providence.org

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.net
-- 
Author: Michael Boligan
  INET: michael.boligan.b_at_bayer.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 Tue Aug 26 2003 - 14:29:32 CDT