Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Headerinfo of Tablespace Datafile, Copy TBSP-Datafile, Part 2

Headerinfo of Tablespace Datafile, Copy TBSP-Datafile, Part 2

From: Markus Mistelbacher <edv_at_noevers.telecom.at>
Date: Fri, 11 Feb 2000 10:05:00 +0100
Message-ID: <38A3D0BC.D47F02EA@noevers.telecom.at>


Sorry, i didn't tell you my HW & SW :

Siemens RM600,
Reliant Unix 5.43 C3004
Oracle Server 7.3.4.5.0

Markus Mistelbacher wrote:

> Scenario :
>
> One Server with two Instances and two databases (PRD --> real, TST -->
> for Tests) :
>
> A simply way to copy a database (to get a binary copy for tests) to
> another instance is to copy all datafiles
> to another instance, remove all Control and Log-Files and start the
> database with the commands :
>
> STARTUP NOMOUNT;
> CREATE CONTROLFILE SET DATABASE "TST" RESETLOGS NOARCHIVELOG
> .
> .
> ALTER DATABASE OPEN RESETLOGS;
>
> This works fine if the Source-DB PRD is down at this moment.
>
> But there is one unsolved problem :
> If the databases are installed on the same server you have to shutdown
> the 'Source' Database PRD ,
> otherwise you get the error :
>
> *
> ORA-01503: CREATE CONTROLFILE failed
> ORA-01565: error in identifying file
> ’/oracle/TST/oradata1/produkti01.dbf’
> ORA-09782: sfifi: another instance has the same database mounted.
> ALTER DATABASE OPEN RESETLOGS
> *
>
> Is it possible to modify the header of the copied datafile to avoid this
> error,
> and ist there a description from oracle of the header anywhere ?
>
> thank you !
Received on Fri Feb 11 2000 - 03:05:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US