Re: oracle 9i: errors by clone a DB by a script
Date: Sun, 27 Apr 2008 13:34:56 +0200
Andreas Mosmann wrote:
> Frank van Bortel schrieb am 21.04.2008 in
>> 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 220.127.116.11i
>> * 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