Re: Copy database?

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 24 Mar 2004 06:33:34 +0100
Message-ID: <aa726091gh3s9tdkql4cuakmjvatet8bii@4ax.com>

On Mon, 22 Mar 2004 16:01:56 -0000, "Karl R" <kroyle_at_hotmail.com> wrote:

>Sybrand,
>
>Dave spotted what I was looking for, so no problem now. However, FYI, what
>I was doing was attempting to create controlfiles for the existing data
>using a new SID in the CREATE CONTROLFILE command. By forgetting the SET
>keyword, I was getting the following message, the 3rd line of which
>suggested (to me) that it was attempting to read the SID from a datafile...
>
>ORA-01503: CREATE CONTROLFILE failed
>ORA-01161: database name STRCT in file header does not match given name of
>MIGR
>ORA-01110: data file 1: 'C:\oracle\oradata\T\SYSTEM01.DBF'
>
>Thanks
>
>Karl R

Yeah, ok. However, to be precise your error is complaining about the *database name*, NOT about the *SID*
While generally SID=Database, the database_name is in the controlfile, the SID is not.

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Mar 23 2004 - 23:33:34 CST