DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2004

    Migration from Oracle 8i to 10g help

    I'm new to 10G and trying to read through the migration documentation but I just wanted to pinch your brains also....

    We are planning to migrate to Oracle 10g from 8.1.7 (on a new server). I want to know, Can we keep the disk layout similar to Oracle 8i (Please see below) i.e does it use the same file structure?. What other things do we need to consider for installing 10g?.

    Disk Layout for Oracle 8i is :-

    Disk01 /disk01/app/oracle/product/8.1.7
    Disk01 /disk01/oradata/MYDB - oracle files (adump,cdump,udump etc.
    Disk02 /disk02/oradata/MYDB - control files,tools,system
    Disk03 /disk03/oradata/MYDB - Temp01.dbf ... Temp04.dbf
    Disk04 /disk04/oradata/MYDB - RBS01.dbf .. RBS_BATCH02.dbf
    Disk05 /Disk05/oradata/MYDB - MYDB_IDX01.dbf .. MYDB_IDX05.dbf
    Disk06 /Disk06/oradata/MYDB - MYDB_IDX06.dbf ... MYDB_IDX10.dbf
    Disk07 /Disk07/oradata/MYDB - MYDB_TAB01.dbf .. MYDB_TAB05.dbf
    Disk08 /Disk08/oradata/MYDB - MYDB_TAB06.dbf .. MYDB_TAB10.dbf
    Disk09 /Disk09/oradata/MYDB - redo11.log .. redo41.log
    Disk10 /Disk10/oradata/MYDB - redo12.log .. redo42.log
    Disk10 /dump

    All help and advice will be appriciated.

    Thanks in advance

  2. #2
    Join Date
    Feb 2003
    Leeds, UK
    Appendix D of the 10g Install Guide describes the preferred layout for Oracle files:


  3. #3
    Join Date
    Apr 2005

    These are disks or just labeled that way?

    Are these individula disks or mount points for filesystems? Are you using RAID?

    Read through the Oracle upgrade guide for the starting point for the migration. Sometimes it is easier to just export, rebuild and import rather than trying to forcefit an old set of datafiles.

    What size is this database?

    Mike Ault
    Michael R. Ault
    Senior Consultant
    Burleson Consulting

  4. #4
    Join Date
    Dec 2000
    Ljubljana, Slovenia

    Re: Migration from Oracle 8i to 10g help

    Originally posted by avion1
    I want to know, Can we keep the disk layout similar to Oracle 8i (Please see below) i.e does it use the same file structure?.
    Yes, you can use exactly the same disk layout as you do now - Oracle *doesn't require* any particular physical datafile layout. It is totaly up to you.

    Is your current disk layout good or even optimal? Well, noone can ansver this question with the supplied information.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.