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@xxxxxxxxxxxxxxxxxxxxxxxx>:

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.
.