Andreas Mosmann wrote:
> 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.
Ahw come on: "oracle rman clone" yield two useful examples
in the top-5
>> 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.
>
Same endianess, same # of bits? E.g. not 2003/64 to
XP/32? If so, follow Sybrand's suggestion:
- take a cold (RMAN?) backup, and copy the stuff over.
Re-create the services, and start your engines.
|
