doing a cold copy (but different datafile dir)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: doing a cold copy (but different datafile dir)

Hybrid View

  1. #1
    We cold copied all datafiles from out old server to our new one. However, the datafiles sit in a different directory structure

    We are going to run the "create controlfile" to re-identify to locations of the datafiles (from /oradata to /u01/POSPROD/dbf).

    Can we then (after the control files are made and copied to the locations specified in the init.ora) simply startup the DB,
    or must we statup mount, and do a "rename database datafile ... from the old to new locations?

    I thought all we had to do was update the control file.. correct?

    thanks

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    You don't have to 'alter databae datafile ... rename...'
    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."

  3. #3
    ok, so recreating the control files is enough then?

    thanks

  4. #4
    Join Date
    Sep 2001
    Posts
    62
    Yeh re-creating the control file is correct,

    In the create control file statement make sure you have 'SET DATABASE' instead of reuse database.

    Also you have to open with resetlogs.

    regards
    shaz


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