migration

[cravi]

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

[sysdba]

Looks like export/import is the way you'd take.

[oradbadmin]

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

[marist89]

[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

[oradbadmin]

--------------------------------------------------------------------------------
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.

[cravi]

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

[marist89]

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

[BRAUK]

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.

[cravi]

thanks alot for all your help friends.I will get back to you all soon.

Ravi.c