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

Frank van Bortel schrieb am 21.04.2008 in <2bcf4$480ce95c$524b5c40$22691_at_cache3.tilbu1.nb.home.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