multiple database multiple versions ....new
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: multiple database multiple versions ....new

  1. #1
    Join Date
    Nov 2000
    Posts
    15
    this is actually what i need to do.

    i currently have a database running on 8.1.6 software. this morning i installed 8.1.7 software into a different directory. i now need to make a copy of the 8.1.6 database but make it run the 8.1.7 software. i plan to shutdown 8.1.6 database. copy all datafiles/logfiles/... to new location. i then plan to recreate the control files with the new database name. i have done this several times successfully but never attempted to uprade at the same time. all i have to do is chance the $ORACLE_HOME and $ORACLE_SID variables prior to doing this?? ...that seems to easy.

    this is all being done on hp-ux11 (probably unnecessary info)

    thanks again
    chris

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    The way I would do it is:
    1. clone the 8.1.6 database (you have the steps)
    2. startup the cloned database with 8.1.6 and shutdown normal
    3. set your environment variables for 8.1.7
    4. migrate the cloned database to 8.1.7 using the migration assistant (odma on solaris).
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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