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.
[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
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.
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.
Reply With Quote
Bookmarks