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

From: Andreas Mosmann <mosmann_at_expires-30-04-2008.news-group.org>
Date: Mon, 21 Apr 2008 18:50:09 +0200
Message-ID: <1208796609.08@user.newsoffice.de>

Hi,

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