-
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
-
Originally Posted by mailme_pjr
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.
-
Originally Posted by PAVB
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.
-
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
-
Originally Posted by kgb
... 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.
-
Originally Posted by PAVB
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?
-
#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.
-
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?
-
Originally Posted by fbifido
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.
-
Originally Posted by PAVB
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|