DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Oracle database import / export

  1. #1
    Join Date
    Aug 2010
    Posts
    1

    Oracle database import / export

    Hello,

    I am a developer and I don't know ABC's of administration. We have Oracle 8 database on NT. This is very old database, We use this for reference purpose only. Due to some hardware problems, Now we are planned to move database to different server (Windows 2003).

    Can you please guide me, How to do this task ??

    Thanks,
    Sri

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by mailme_pjr View Post
    I am a developer and I don't know ABC's of administration. We have Oracle 8 database on NT. This is very old database, We use this for reference purpose only. Due to some hardware problems, Now we are planned to move database to different server (Windows 2003).

    Can you please guide me, How to do this task ??
    1- Install Oracle in new hardware -follow Oracle documentation.
    2- Pre create databas in new hardware -follow Oracle documentation.
    3- Export database from old hardware
    4- FTP dump file to new hardware
    5- Import dump file into new hardware.

    Needless to say it will be much more easier if you get the help of a DBA
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Mar 2001
    Posts
    41
    Quote Originally Posted by PAVB View Post
    1- Install Oracle in new hardware -follow Oracle documentation.
    2- Pre create databas in new hardware -follow Oracle documentation.
    3- Export database from old hardware
    4- FTP dump file to new hardware
    5- Import dump file into new hardware.

    Needless to say it will be much more easier if you get the help of a DBA

    Hi,

    I think this option will also work since both hardware are in Windows OS
    1. Create oracle service on the new hardware (same instance name with the old hardware)
    2. Do a full backup of the old db. (controlfile,datafile, initfile)
    3. Restore the backup to the new hardware (must be on the same file structure)

    Create also the password file on the new machine if needed.

  4. #4
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    If you also want to change your Oracle version, there might be issues with compatibility, e.g. 11.2 does not support exp/imp and there are many issues during import process.
    Best wishes!
    Dmitri

  5. #5
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by kgb View Post
    ... 11.2 does not support exp/imp
    Not exactly - this is phrased like exp/imp doesn't work. Let me clarify.
    exp/imp is there and you can use it.
    Some people are saying exp/imp will become deprecated after 11gR2 which means that in such a case Oracle will stop supporting it, which is means Oracle wouldn't write a patch if a new bug is found.
    Hope this helps.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  6. #6
    Join Date
    May 2011
    Posts
    25
    Quote Originally Posted by PAVB View Post
    1- Install Oracle in new hardware -follow Oracle documentation.
    2- Pre create databas in new hardware -follow Oracle documentation.
    3- Export database from old hardware
    4- FTP dump file to new hardware
    5- Import dump file into new hardware.

    Needless to say it will be much more easier if you get the help of a DBA
    i have oracle 8i and i am going to oracle 11gr1, how i go about this your instructions?
    #1 - completed
    #2 - how do i pre-create the 8i database on the 11gr1 server?
    #3 - completed
    #4 - completed
    #5 - ! stuck on #2?

  7. #7
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    #2 - how do i pre-create the 8i database on the 11gr1 server?
    create the database with same name, create all table spaces required.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  8. #8
    Join Date
    May 2011
    Posts
    25
    i copy all the 8i datafile, controlfile, logs and put in one directory /u02/oradata/DCTEST/ on my 11gr1 server. but in this file i don't see the *.ctl file mention atall.

    this is my reconfigure sqlfile : DCTEST_cr_control.sql

    STARTUP NOMOUNT
    CREATE CONTROLFILE SET DATABASE "DCTEST" RESETLOGS ARCHIVELOG
    MAXLOGFILES 32
    MAXLOGMEMBERS 2
    MAXDATAFILES 254
    MAXINSTANCES 8
    MAXLOGHISTORY 907
    LOGFILE
    GROUP 1 '/u02/oradata/DCTEST/redo01.log' SIZE 4M,
    GROUP 2 '/u02/oradata/DCTEST/redo02.log' SIZE 4M,
    GROUP 3 '/u02/oradata/DCTEST/redo03.log' SIZE 4M
    DATAFILE
    '/u02/oradata/DCTEST/system01.dbf',
    '/u02/oradata/DCTEST/tools01.dbf',
    '/u02/oradata/DCTEST/rbs01.dbf',
    '/u02/oradata/DCTEST/temp01.dbf',
    '/u02/oradata/DCTEST/eqndxs01.dbf',
    '/u02/oradata/DCTEST/drsys01.dbf',
    '/u02/oradata/DCTEST/eqdata01.dbf',
    '/u02/oradata/DCTEST/CATTBS_1.dbf'
    CHARACTER SET US7ASCII
    ;

    Why does this sql file not work in 11g?

  9. #9
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by fbifido View Post
    i copy all the 8i datafile, controlfile, logs and put in one directory /u02/oradata/DCTEST/ on my 11gr1 server.
    ...
    Why does this sql file not work in 11g?
    Too many reasons.

    Manual creation of a database is not rocket science but has to be done properly, please check this step-by-step guide http://www.orafaq.com/node/2015

    Create all the tablespaces you need to import data - please point them to cooked file systems; I'm assuming you do not want to tackle ASM at this time.

    Hope this helps.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  10. #10
    Join Date
    May 2011
    Posts
    25
    Quote Originally Posted by PAVB View Post
    Too many reasons.

    Manual creation of a database is not rocket science but has to be done properly, please check this step-by-step guide http://www.orafaq.com/node/2015

    Create all the tablespaces you need to import data - please point them to cooked file systems; I'm assuming you do not want to tackle ASM at this time.

    Hope this helps.
    That was not a good example, that's windows, and that look allot simpler that when don in linux.

    I don't get why oracle make this thing so badly. a full export has everything in it so why don't the import software just re-create the the database and all the data?

    or even better make a program that can look at the backup and produce all the needed files to create the database,users and rights and just put it in a directory so you can edit it and then do a manual or automate database creation?

    or can they make a backup converter program that reads the dump file and get what version exp was use and then convert it to the version that it is been imported to and fix the file location of all the files so it match how the current oracle database is created (not sure how to say that part)?
    Last edited by fbifido; 05-06-2011 at 12:31 PM.

Tags for this Thread

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