migration
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: migration

  1. #1
    Join Date
    Nov 2000
    Posts
    157
    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

  2. #2
    Join Date
    Jun 2000
    Posts
    295
    Looks like export/import is the way you'd take.

  3. #3
    Join Date
    Nov 2000
    Posts
    71
    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

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    [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

  5. #5
    Join Date
    Nov 2000
    Posts
    71
    --------------------------------------------------------------------------------
    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.


  6. #6
    Join Date
    Nov 2000
    Posts
    157

    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

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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

  8. #8
    Join Date
    Jun 2000
    Location
    Memphis,TN
    Posts
    30
    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.

  9. #9
    Join Date
    Nov 2000
    Posts
    157
    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
  •  


Click Here to Expand Forum to Full Width