Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Headerinfo of Tablespace Datafile, Copy TBSP-Datafile, Part 2
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