Re: oracle 9i: errors by clone a DB by a script

Frank van Bortel schrieb am 21.04.2008 in 
<2bcf4$480ce95c$524b5c40$22691@[EMAIL PROTECTED]
>:

> 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 ex****ted the database and im****ted 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 ex****t/im****t.
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