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

Thread: cloning one instance from 8i to 9i

  1. #1
    Join Date
    Feb 2001
    Posts
    20
    I have two databases, one is running oracle server 9.2.0 and the other one 8.1.7. I need to clone one database from 8.1.7 to 9.0.2. The size of database to be cloned is very large ( around 10 GB) therefore exp/import doesn't seems to be feasible here.

    Can anyone of you. pls. let me know how should I proceed.

    Thanks



  2. #2
    Join Date
    Oct 2001
    Posts
    126
    Two Main steps involve:

    Step 1. Clone the db as the 8.1.7 version
    ------------------------------------------------
    1. alter database backup controlfile to trace; Then modified the database name, datafile directory name, and modify this line

    CREATE CONTROLFILE REUSE set DATABASE "your db_name" RESETLOGS NOARCHIVELOG

    to this control file. Let's say this new ctrl file is ctrl.sql.

    2. shutdown the 8.1.7 db.
    3. Copy ALL datafiles to new location.
    4. modified all files regarding the new database name and directory structure.
    5. startup database nomount
    6. run ctrl.sql
    7. alter database open resetlogs;
    8. Make sure no invalid objects on the database.

    Once it runs successfully, do the second step.
    -----------------------------------------------------
    1. Make sure you have enough space on both system and rollback segment.
    2. upgrade the cloned 8.1.7 database to 9.2.0 by running
    @?/rdbms/admin/u0801070.sql

    If your database use other oracle features, you need to check out the related info for upgrading the db manully.

    Susan



  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Its advisable to use oracle migration utility OR export/import if you are going from one version to another. 10GB database is not big as you think. Of course! it depends upon the maintenance window you get.

    Check out Metalink for doc 159657.1
    Reddy,Sam

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