Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Miscellaneous > oracle 9i: erro...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 13 Topic 6848 of 7037
Post > Topic >>

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

by Andreas Mosmann <mosmann@[EMAIL PROTECTED] > Apr 21, 2008 at 06:50 PM

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
 




 13 Posts in Topic:
oracle 9i: errors by clone a DB by a script
Andreas Mosmann <mosma  2008-04-21 18:50:09 
Re: oracle 9i: errors by clone a DB by a script
Frank van Bortel <fran  2008-04-21 21:22:03 
Re: oracle 9i: errors by clone a DB by a script
Andreas Mosmann <mosma  2008-04-21 23:00:32 
Re: oracle 9i: errors by clone a DB by a script
Frank van Bortel <fran  2008-04-27 13:34:56 
Re: oracle 9i: errors by clone a DB by a script
sybrandb@[EMAIL PROTECTED  2008-04-25 19:48:15 
Re: oracle 9i: errors by clone a DB by a script
Andreas Mosmann <mosma  2008-04-28 13:09:17 
Re: oracle 9i: errors by clone a DB by a script
sybrandb@[EMAIL PROTECTED  2008-04-28 17:36:48 
Re: oracle 9i: errors by clone a DB by a script
Andreas Mosmann <mosma  2008-04-29 10:38:48 
Re: oracle 9i: errors by clone a DB by a script
joel garry <joel-garry  2008-04-28 13:00:19 
Re: oracle 9i: errors by clone a DB by a script
Andreas Mosmann <mosma  2008-04-29 10:00:44 
Re: oracle 9i: errors by clone a DB by a script
sybrandb@[EMAIL PROTECTED  2008-04-29 10:33:27 
Re: oracle 9i: errors by clone a DB by a script
Andreas Mosmann <mosma  2008-04-29 10:53:50 
Re: oracle 9i: errors by clone a DB by a script
joel garry <joel-garry  2008-04-29 10:29:52 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Thu Jul 24 2:42:25 CDT 2008.