oracle 9i: errors by clone a DB by a script

From: Andreas Mosmann <>
Date: Mon, 21 Apr 2008 18:50:09 +0200
Message-ID: <>


I have to clone a DB to built a Test DB. To avoid manual work our admin wrote a script, that in general
- fills some files with file structure

  • fills some files with parameters
  • shuts down the database
  • copies and packs all datafiles
  • startd the database

and back:
- fills the filestructure from files

  • rebuilds password and controlfiles
  • builds a service
  • starts the database

there are still some manual steps, f.e. to fill tnsnames.ora/listener.ora
but in general it works fine.

My problem is, that it doesnt work in my case, and I do not know, why. My explicit question is

what are possible reasons for

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

Andreas Mosmann

wenn email, dann AndreasMosmann <bei> web <punkt> de
Received on Mon Apr 21 2008 - 11:50:09 CDT

Original text of this message