Dbse Move
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Dbse Move

  1. #1
    Join Date
    Aug 2000
    Posts
    68

    Dbse Move

    Hi There

    Hope somebody can advise...Any help/advice is appreciatated..

    Our Oracle Dbse is installed on a shared symmetrix drive attached to a sql server O/S.

    So all Oracle Db software & datafiles are all on the J:directory.
    As part of Symm space move, I need to move my Databse software & datafiles off that drive and onto a new Drive.

    Downtime is no problem, so here is the plan..

    1.Take a Full DB Backup to a shared drive
    2.Backup the control files & parameter file
    3.Write script for users, tablespace, roles
    3.Close & Shut down the dbse
    4.Uninstall Oracle Software

    **Let the Server Admin - re-map the new drive to J:\

    5.Install dbse software on new drive
    6.Ensure init.ora files & control files are copied back new drive
    7.Start up Dbse
    8.Run Tablespace,user creation scriptsetc
    9.import full backup dump...

    Now i know that i could be wrong but any pointers plese let me know..

    Also i am worried about the registery of the Server, in Regedit is it possible that there are entries pointing to the old dbse files which could cause the dbse not to open correctly??

    Any advice appreciatated..
    Carpe Diem

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    If the new drive is going to have the same windoz characteristics i.e drive letter, directory layout, etc. why not simply take a cold backup of the whole drive and restore it once the disks have been switched?

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447

    Re: Dbse Move

    Originally posted by Barabas
    Our Oracle Dbse is installed on a shared symmetrix drive attached to a sql server O/S.
    Dont you know that's called Windows?

    And why need to recreate database?!

  4. #4
    Join Date
    Aug 2000
    Posts
    68
    thanks for the replies..


    Of course i know the name of the O/s just rushed a small bit in writing the message....sorry!

    So its going to be a new drive, there will be no software on it?

    Dont i have to re-install the software & re-create the dbse?
    Carpe Diem

  5. #5
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Does this drive contain your OS as well?

    If not...

    Stop all the associated Oracle services
    Take a full backup of J:\
    Replace the drive J:
    Restore the backup to J:\
    Start the services
    Last edited by jovery; 05-02-2003 at 08:27 AM.
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  6. #6
    Join Date
    Aug 2000
    Posts
    68
    Nope, OS is on the C Drive
    Carpe Diem

  7. #7
    Join Date
    Aug 2000
    Posts
    68
    thanks for the help jim...
    Carpe Diem

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