Hi We have to go to 8.1.6.3 'cause we're using a case tool be CA (Computer Associates) and that's the Oracle version they support.
In our cluster environment, we're not using OPS but a single instance which fails over a second node. Our first ideas (which are not acceptable) were import/export or using a tool like pdqout to extract all data as ascii and the use sqlloader (direct path) to load the data into a new 8163 database. But the migration utility seems very interesting especially with regards to the downtime. Could you please provide me with some more info about the "ODMA". I appreciate a lot. Thanks once again for your valuable feedback regards mark ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, March 07, 2002 9:28 AM > > Why 8.1.6.3 ? Go to 8.1.7.2 or 8.1.7.3. 8.1.6 has been desupported. > > What is the OS version ? Solaris 2.5.1 ? > > 32-bit 8.1.7 is certified on 2.6 and above. > 64-bit 8.1.7 is on Solaris 8 (2.8) of course. > > That you have a Cluster -- is it OPS or single-instance database which > fails > over to the second node ? > > If you use the MIGrate utility, you should have very low downtime. > 1. Install 8.1.7 + Patchset 2 or 3 : 1.5 hours max. Install into a > seperate ORACLE_HOME. > 2. MIG database 1 hour ?? (depends on the size of the SYSTEM Tablespace, > not the full database) -- I suggest you use the command-line MIG utility, > I've been > more comfortable with it than ODMA. > 3. Configure init.ora, copy convSID.ora, ALTER DATABASE CONVERT and > catalog and catproc > in 81.7 : 1.5 hours max. > 4. Recompile Invalid Objects : Depends on how many you have. > > Don't waste time installing the JVM into the database -- you are not > currently using it. > > You'd have to practice the migrate a couple of times on another server. > > > Hemant K Chitale > Principal DBA > Chartered Semiconductor Manufacturing Ltd > > > "Mark Cilia" <[EMAIL PROTECTED]> 07/03/2002 02:13 PM > Sent by: [EMAIL PROTECTED] > > Please respond to ORACLE-L > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) > Subject: Oracle Migration 7.3.4.5 to 8.1.6.3 > > > > > > > > > Hi All > > We are in the process of migrating our database from 7.3.4.5 to 8.1.6.3. > We are using a Sun Cluster (2 E4000 each with 4x480Mhx processors and 4gb > Ram) for our system which is almost 24x7. This whole operation must be > performed (ideally) within a maximum of 24 hour period (during say a > national holdiday). Our database is approx 100Gb large. > > Any suggestions on how to do this operation? Any past experience? > > TIA > mark > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > 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: Mark Cilia INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
