Re: RE: 8.1.5 upgrade paths to 10.2.x

This is just right. First exp/imp with NOROWS option, thus getting the initial database structures. Then exp/imp with the data.   Always, test, test, test.

Ram Srinivasan

On 10/17/07, LS Cheng <exriscer_at_gmail.com> wrote:
>
> One option is using export full with no rows and import full witihout rows
> to generate the database structure so you dont have to worry abour grants,
> after that just run several parallel imports per schema
>
> thanks
>
> --
> LSC
>
>
>
> On 10/17/07, development_at_the-playground.de < development_at_the-playground.de>
> wrote:
> >
> > Thanks all for your valuable suggestions!
> >
> > Since we are on Solaris 7 I can't have an Oracle 10.2 installation and
> > benefit from transportable tablespaces.
> >
> > I think I'll end up doing a user export (exp 8.1.5 -> pipe -> imp 10.2
> > via network) for the schemas containing data. This can easily be
> > parallelised by running a few exports and imports simultaneously. I was
> > surprised to find that in Metalink note 132904.1 it reads that
> > fromuser/touser will work.
> >
> > Additional things to take care of are
> > - sys grants
> > - other user accounts
> > - 32 to 64 conversion (the new empty database on AIX is 64 bit)
> >
> > And as usual, test, test, test.
> >
> > Cheers,
> >
> > Martin
> >
> > Am 16.10.2007 um Uhr haben Sie geschrieben:
> > >
> > > Would not call them "exotic", just a darn lot faster & less error
> > prone.
> > >
> > >
> > >
> > > ______________________________________________________________
> > > Dick Goulet / Capgemini
> > > North America P&C / East Business Unit
> > > Senior Oracle DBA / Hosting
> > > Office: 508.573.1978 / Mobile: 508.742.5795 / www.capgemini.com
> > > Fax: 508.229.2019 / Email: richard.goulet_at_capgemini.com
> > > 45 Bartlett St. / Marlborough, MA 01752
> > >
> > > Together: the Collaborative Business Experience
> > > ______________________________________________________________
> > >
> > > ________________________________
> > >
> > > From: LS Cheng [mailto:exriscer_at_gmail.com]
> > > Sent: Tuesday, October 16, 2007 2:36 PM
> > > To: Goulet, Dick
> > > Cc: zimsbait_at_gmail.com; development_at_the-playground.de;
> > > oracle-l_at_freelists.org
> > > Subject: Re: 8.1.5 upgrade paths to 10.2.x
> > >
> > >
> > >
> > > with a 60gb database I wouldnt mess around with the exotic ways...
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > On 10/16/07, Goulet, Dick < richard.goulet_at_capgemini.com> wrote:
> > >
> > >
> > > Better idea, which I've done recently. Upgrade DB to 8.1.7 then to
> > > 10.2, approximate time 3 hours. Then use Transportable database to
> > move
> > >
> > > datafiles to AIX, convert them with RMAN & restart your db. This
> > entire
> > > process on HP-UX to AIX took 18 hours total for a 700GB database.
> > Would
> > > have been faster if we had paralleled things.
> > >
> > > ______________________________________________________________
> > > Dick Goulet / Capgemini
> > > North America P&C / East Business Unit
> > > Senior Oracle DBA / Hosting
> > > Office: 508.573.1978 / Mobile: 508.742.5795 / www.capgemini.com
> > > Fax: 508.229.2019 / Email: richard.goulet_at_capgemini.com
> > > 45 Bartlett St. / Marlborough, MA 01752
> > >
> > > Together: the Collaborative Business Experience
> > > ______________________________________________________________
> > >
> > >
> > > -----Original Message-----
> > > From: oracle-l-bounce_at_freelists.org
> > > [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of z b
> > > Sent: Monday, October 15, 2007 3:53 PM
> > > To: development_at_the-playground.de
> > > Cc: oracle-l_at_freelists.org
> > > Subject: Re: 8.1.5 upgrade paths to 10.2.x
> > >
> > > To "parallelize" you could use limit the dump files to, say, 500MB
> > > dump files. (filesize parameter)
> > >
> > > Ftp the files and start the import while the export is still running.
> > >
> > > Of course - test a couple of times before actually scheduling. :)
> > >
> > >
> > > On 10/15/07, development_at_the-playground.de
> > > < development_at_the-playground.de <mailto: development_at_the-playground.de
> > >
> > >
> > > wrote:
> > > > Hello group!
> > > >
> > > > I have got a tricky problem at hand - migrate an Oracle 8.1.5 on
> > > Solaris
> > > > 7 database to 10.2.0.x on AIX. The problem here is that I am not
> > > allowed
> > > > much downtime. Having started with Oracle 8i I am not too sure how
> > > that
> > > > can be done. Obviously to get from 8.1.5 I have to go to 8.1.7
> > first,
> > > a
> > > > direct update is supported which is good. I am thinking of a new
> > > Oracle
> > > > home on the same machine, copying the database and migrating it.
> > > >
> > > > From there on I don't see any other way than exp/imp using pipes for
> >
> > > > faster processing. It is a bit of a mystery how I can keep the
> > > downtime
> > > > low, the database is some 60GB in size btw.
> > > >
> > > > Thanks for any input on this,
> > > >
> > > > Martin
> > > >
> > > >
> > > >
> > > >
> > > > --
> > > > http://www.freelists.org/webpage/oracle-l
> > > >
> > > >
> > > >
> > > --
> > > http://www.freelists.org/webpage/oracle-l
> > >
> > >
> > >
> > > This message contains information that may be privileged or
> > confidential
> > > and is the property of the Capgemini Group. It is intended only for
> > the
> > > person to whom it is addressed. If you are not the intended recipient,
> > > you are not authorized to read, print, retain, copy, disseminate,
> > > distribute, or use this message or any part thereof. If you receive
> > this
> > > message in error, please notify the sender immediately and delete all
> > > copies of this message.
> > >
> > > --
> > > http://www.freelists.org/webpage/oracle-l
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > This message contains information that may be privileged or
> > confidential and is
> > > the property of the Capgemini Group. It is intended only for the
> > person to whom
> > > it is addressed. If you are not the intended recipient, you are not
> > authorized
> > > to read, print, retain, copy, disseminate, distribute, or use this
> > message or
> > > any part thereof. If you receive this message in error, please notify
> > the
> > > sender immediately and delete all copies of this message.
> > >
> > >
> >
> >
> >
> >
>

-- 
Sincerely
Ram Srinivasan
Charlottesville, VA.

--
http://www.freelists.org/webpage/oracle-l