RE: Is it possible to copy one db to another if the SID is differ

hi

you have to do a
alter database backup controlfile to trace on the source database

change all occurrences PROD in TEST in the created backup controlfile the create controlfile reuse has to be create controlfile SET database "test"

oracle note 61590.1 on metalink

g.g. kor
rdw the netherlands

> -----Oorspronkelijk bericht-----
> Van: CHAN Chor Ling Catherine (CSC) [SMTP:clchan_at_nie.edu.sg]
> Verzonden: woensdag 9 oktober 2002 9:13
> Aan: Multiple recipients of list ORACLE-L
> Onderwerp: Is it possible to copy one db to another if the SID is
> different
>
> Hi,
>
> Qn : Is it possible to copy one database to another if the source database
> name is different from the target database name ?
>
> I need to clone Oracle Applications 11I from one machine (source
> instance:PROD) to another (target instance:TEST). I followed the
> instructions on Metalink doc 135792.1 "Cloning Oracle Applications Release
> 11I". Everything works fine until I re-create the controlfile in the
> target
> instance.
>
> In svrmgrl =>
> STARTUP NOMOUNT
> CREATE CONTROLFILE REUSE DATABASE "TEST" RESETLOGS ARCHIVELOG
> MAXLOGFILES 16
> MAXLOGMEMBERS 2
> MAXDATAFILES 500
> MAXINSTANCES 1
> MAXLOGHISTORY 453
> LOGFILE
> GROUP 1 (
> '/dg3/oracle/testredo/log01a.dbf',
> '/dg4/oracle/testredo/log01b.dbf'
> ) SIZE 10M
> ....
> DATAFILE
> '/dg7/oracle/testdata/system01.dbf',
> '/dg7/oracle/testdata/system02.dbf',
> ...
> '/dg8/oracle/testdata/ctxd01.dbf',
> .................
> CHARACTER SET US7ASCII
> CREATE CONTROLFILE REUSE DATABASE "TEST" RESETLOGS ARCHIVELOG
> *
> ORA-01503: CREATE CONTROLFILE failed
> ORA-01161: database name PROD in file header does not match given name of
> TEST
>
> Any advice ? Thanks. (Please reply to clchan_at_nie.edu.sg)
>
> Regds,
> New Bee
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: CHAN Chor Ling Catherine (CSC)
> INET: clchan_at_nie.edu.sg
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: GKor_at_rdw.nl

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).