View Single Post

   
  #5 (permalink)  
Old 04-29-2008, 08:28 PM
Frank van Bortel
 
Posts: n/a
Default Re: oracle 9i: errors by clone a DB by a script

Andreas Mosmann wrote:
> Frank van Bortel schrieb am 21.04.2008 in
> <2bcf4$480ce95c$524b5c40$22691@cache3.tilbu1.nb.ho me.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.
Reply With Quote