Re: oracle 9i: errors by clone a DB by a script
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sun, 27 Apr 2008 13:34:56 +0200
Message-ID: <a0ed5$481464e0$524b5c40$18441@cache4.tilbu1.nb.home.nl>
>
>
> Sounds simple, but I did not find up to now. I look for.
>
> Sorry, I didn't want to be boring ;)
> Oracle 9.2.0.7i
> MS Windows (Source: Win2003 Server, Destination: WinXP Prof)
> different machines, same patchlevel, different number of processors
>
> The destination machines are a personal PC and a LapTop.
>
Date: Sun, 27 Apr 2008 13:34:56 +0200
Message-ID: <a0ed5$481464e0$524b5c40$18441@cache4.tilbu1.nb.home.nl>
Andreas Mosmann wrote:
> 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.
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. Received on Sun Apr 27 2008 - 06:34:56 CDT