Printable View
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
1- Install Oracle in new hardware -follow Oracle documentation.Quote:
Originally Posted by mailme_pjr
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
Quote:
Originally Posted by PAVB
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.
Not exactly - this is phrased like exp/imp doesn't work. Let me clarify.Quote:
Originally Posted by kgb
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.
i have oracle 8i and i am going to oracle 11gr1, how i go about this your instructions?Quote:
Originally Posted by PAVB
#1 - completed
#2 - how do i pre-create the 8i database on the 11gr1 server?
#3 - completed
#4 - completed
#5 - ! stuck on #2?
create the database with same name, create all table spaces required.Quote:
#2 - how do i pre-create the 8i database on the 11gr1 server?
Thanks,
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?
Too many reasons.Quote:
Originally Posted by fbifido
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.Quote:
Originally Posted by PAVB
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)?
LOL - Do you think Oracle writes and supports a different set of commands depending on O/S? Oracle commands are exactly the same no matter the underlying Operating System.Quote:
Originally Posted by fbifido
The few DOS commands are easily translatable into Linux commads, the one that may be harder is "set", replace with "export"
you are really dumbQuote:
Originally Posted by fbifido