Headerinfo of Tablespace Datafile, Copy TBSP-Datafile

From: Markus Mistelbacher <edv_at_noevers.telecom.at>
Date: Fri, 11 Feb 2000 09:55:38 +0100
Message-ID: <38A3CE8A.68625392@noevers.telecom.at>

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 - 02:55:38 CST