Frank van Bortel schrieb am 21.04.2008 in
<2bcf4$480ce95c$524b5c40$22691@cache3.tilbu1.nb.ho me.nl>:

> Andreas Mosmann wrote:

>>
>> .. Database opened with MOUNT ...
>> ORA-01113: Für Datei '1' ist Datentrõger-Recovery notwendig
>> ORA-01110: Datendatei 1: 'D:\ORACLE\ORADATA\XXXXX\SYSTEM01.DBF'
>> -> recover database
>> -> shutdown
>> -> startup
>> .. Database opened with MOUNT ...
>> ORA-01092: ORACLE-Instance beendet. Verbindungsabbruch erzwungen.
>>
>> what can I look for?
>>

> 1) A new administrator - look up db cloning with RMAN:
> 7 lines of code...
Sounds simple, but I did not find up to now. I look for.
> 2) trace and log files - alter log to start with.

> And you could provide a little more info:
Sorry, I didn't want to be boring
> * What version of Oracle
Oracle 9.2.0.7i
> * What platform (other than the obvious Microsoft)
MS Windows (Source: Win2003 Server, Destination: WinXP Prof)
> * same, or other machine (if other - patch levels the same?!?)
different machines, same patchlevel, different number of processors

The destination machines are a personal PC and a LapTop.

In former times I exported the database and imported it into a new one.
But in this case I found no way to keep the BLOB- data. All the rows
containing a BLOB are killed after this export/import.
And I hoped to get along without the manual stuff as recompile a.s.o.

> FvB
Thank you very much
Andreas Mosmann

--
wenn email, dann AndreasMosmann <bei> web <punkt> de