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

Thread: Clone Using Cold Backup

  1. #1
    Join Date
    Oct 2000
    Posts
    21

    Red face

    Hi Guys
    I have following scenario. I have one instance name CRP on Server1 and I created control trace file using for CRP. And total cold backup (including control and redo logfiles).
    Now I created another instance TST on the same machine.
    I edited the control trace file (which I cretaed for CRP) , to coreesponds the TST instance, Then I moved the all the datafiles backup in cold back from CRP, to the TST instance.

    Then I started TST instance with no mount.
    Then I tried to create control file by runing above trace file , but I get following error, I even tried to shuting down CRp before I create and starting the TST instance.
    Error Message
    Buffers 180224 bytes
    SVRMGR> @ccq.sql
    CREATE CONTROLFILE REUSE SET DATABASE "TST" RESETLOGS NOARCHIVELOG
    *
    ORA-01503: CREATE CONTROLFILE failed
    ORA-01161: database name TST in file header does not match given name
    of CRP
    ORA-01110: data file 82: '/d02/oradata/TST/user_idx.dbf'
    ORA-01507: database not mounted
    ALTER DATABASE OPEN

    Any Help
    Thanks
    Sanjay

    sanjay

  2. #2
    Join Date
    Apr 2001
    Posts
    8
    Hi Sanjay,

    Please remove the "REUSE" from the "create controlfile"
    statement !

    Regards,
    Robert.

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