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

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

  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?


  2. #2
    Join Date
    Nov 2000
    You don't have to 'alter databae datafile ... rename...'
    Jeff Hunter
    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?


  4. #4
    Join Date
    Sep 2001
    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.


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