View Single Post

   
  #1 (permalink)  
Old 04-24-2008, 06:09 PM
Andreas Mosmann
 
Posts: n/a
Default oracle 9i: errors by clone a DB by a script

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
Reply With Quote