Hi,

Doing a full cold backup before and after the migration are important
steps in my opinion...

I also like to use big redo log files on the target database (about 512MB
each to retain 20min of data, depending on the situation) and be sure the
database in not in archivelog mode... Small redo log files can cause
"checkpoint not complete" waits...

Also, don't forget to check the size of the default extent of the
tablespaces... For example, if you import data from a tablespace which
extent size is 64k into a tablespace of 1Mb extent (uniform size
autoallocate) the space required to store your objects may be incredibly
bigger...

Finally, don't forget to adjust your parameter file, because Oracle
defaults rarely are adequate to your database performance...

Welll that's it! I hope that helps! good luck!

Juliano

> Just want o clarify the steps from gurus.
>
> I want to upgrade from 8i to 9i. Also doing a hardware upgrade. The 9i
> will
> be residing in a new system.
> This is how I see it should go.
>
> 1. Do a full export of the 8i database.
>
> 2. Install and create a new 9I database on the new system. It should have
> the same name as the 8i DB.
>
> 3. Create all the tablespaces on the 9i system just like it was on the 8i
> system.
>
> 4. Do an import into the 9i database.
>
> Questions:
>
> 1. Are all these steps correct?
> 2. I have 2 instances of 8i I need to move over to the new 9i system. Is
> there anything special I need to do?
>
> Thanks in advance.
>
> Regards,
> Ancy
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>



Oracle LazyDBA home page