-
Hi Friends
1.ours is a 24*7 database presently on Oracle 7.3.4 & Nt 4.o
2.I have to move the database from this env. TO Oracle 8.0 & sunsolaris 2.6. I don't have any idea regarding this.Can any one of you guide me in detail to accomplish this task.
we have 16 tablespaces,2controlfiles,5 log groups each with 2 members.
Thanks and regards
Ravi
ravi
-
Looks like export/import is the way you'd take.
-
You cold take a cold full backup of your Oracle 7.3 DB and then porting it to Oracle 8.0.
Paying attention to configuration, it should work fine
-
[QUOTE][i]Originally posted by oradbadmin [/i]
[B]You cold take a cold full backup of your Oracle 7.3 DB and then porting it to Oracle 8.0.
Paying attention to configuration, it should work fine [/B][/QUOTE]
No, I don't think so. You can't change platforms using a cold backup.
Export/import is your only method.
1. Setup new database with correct datafile sizes, users, groups, etc.
2. export old database with full=y
3. ftp dmp file in binary mode to new box
4. import
-
--------------------------------------------------------------------------------
Originally posted by marist89
No, I don't think so. You can't change platforms using a cold backup.
--------------------------------------------------------------------------------
You're RIGHT.I didn't read paying attention to the topic and I didn't see that there was a platform change.
Of course the export is the only way to migrate the DB in this case.
Sorry for miss uderstanding.
-
Migration
so guys
Will the Export and Import work out fine in migrating the data
FROM: Oracle 7.3.4, OS :MS WINDOWS NT V4
TO : Oracle 8.0, OS:Sun Solaris 2.6
Thanks in Advance
ravi
-
Yes, a 7.x -> 8.x import will work with little difficulty. If you are importing the whole database, you will want to read up on the parameters of import/export.
Parameters you might want to think about using with export:
COMPRESS=Y
CONSISTENT=Y
STATISTICS=NONE
DIRECT=N
(If you are exp/imp the same version of oracle, DIRECT=Y is _USUALLY_ a good thing. I wouldn't take chances with a version upgrade though)
Parameters you might want to think about using with imp:
COMMIT=Y
BUFFER= (depends on your physical memory)
FEEDBACK=1000
-
When u do this with full database export u need not create the users in new database.full database export/import will take care of that.just make sure that tablespaces are named exactly the same as in 7.x db.
-
thanks alot for all your help friends.I will get back to you all soon.
Ravi.c
ravi
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
|