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>
.. Database opened with MOUNT ...
ORA-01092: ORACLE-Instance beendet. Verbindungsabbruch erzwungen.
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> deReceived on Mon Apr 21 2008 - 11:50:09 CDT