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

Andreas Mosmann wrote:

1) A new administrator - look up db cloning with RMAN:
7 lines of code...
2) trace and log files - alter log to start with.

And you could provide a little more info:
* What version of Oracle
* What platform (other than the obvious Microsoft)
* same, or other machine (if other - patch levels the same?!?)

FvB

Andreas Mosmann wrote:

1) A new administrator - look up db cloning with RMAN:
7 lines of code...
2) trace and log files - alter log to start with.

And you could provide a little more info:
* What version of Oracle
* What platform (other than the obvious Microsoft)
* same, or other machine (if other - patch levels the same?!?)

FvB

Andreas Mosmann wrote:

1) A new administrator - look up db cloning with RMAN:
7 lines of code...
2) trace and log files - alter log to start with.

And you could provide a little more info:
* What version of Oracle
* What platform (other than the obvious Microsoft)
* same, or other machine (if other - patch levels the same?!?)

FvB

Andreas Mosmann wrote:

1) A new administrator - look up db cloning with RMAN:
7 lines of code...
2) trace and log files - alter log to start with.

And you could provide a little more info:
* What version of Oracle
* What platform (other than the obvious Microsoft)
* same, or other machine (if other - patch levels the same?!?)

FvB

Frank van Bortel schrieb am 21.04.2008 in
<2bcf4$480ce95c$524b5c40$22691 (AT) cache3 (DOT) tilbu1.nb.home.nl>:


The destination machines are a personal PC and a LapTop.

In former times I exported the database and imported it into a new one.
But in this case I found no way to keep the BLOB- data. All the rows
containing a BLOB are killed after this export/import.
And I hoped to get along without the manual stuff as recompile a.s.o.

Andreas Mosmann

--
wenn email, dann AndreasMosmann <bei> web <punkt> de

Frank van Bortel schrieb am 21.04.2008 in
<2bcf4$480ce95c$524b5c40$22691 (AT) cache3 (DOT) tilbu1.nb.home.nl>:


The destination machines are a personal PC and a LapTop.

In former times I exported the database and imported it into a new one.
But in this case I found no way to keep the BLOB- data. All the rows
containing a BLOB are killed after this export/import.
And I hoped to get along without the manual stuff as recompile a.s.o.

Andreas Mosmann

--
wenn email, dann AndreasMosmann <bei> web <punkt> de

Frank van Bortel schrieb am 21.04.2008 in
<2bcf4$480ce95c$524b5c40$22691 (AT) cache3 (DOT) tilbu1.nb.home.nl>:


The destination machines are a personal PC and a LapTop.

In former times I exported the database and imported it into a new one.
But in this case I found no way to keep the BLOB- data. All the rows
containing a BLOB are killed after this export/import.
And I hoped to get along without the manual stuff as recompile a.s.o.

Andreas Mosmann

--
wenn email, dann AndreasMosmann <bei> web <punkt> de

Frank van Bortel schrieb am 21.04.2008 in
<2bcf4$480ce95c$524b5c40$22691 (AT) cache3 (DOT) tilbu1.nb.home.nl>:


The destination machines are a personal PC and a LapTop.

In former times I exported the database and imported it into a new one.
But in this case I found no way to keep the BLOB- data. All the rows
containing a BLOB are killed after this export/import.
And I hoped to get along without the manual stuff as recompile a.s.o.

Andreas Mosmann

--
wenn email, dann AndreasMosmann <bei> web <punkt> de

On Mon, 21 Apr 2008 18:50:09 +0200, Andreas Mosmann
<mosmann (AT) expires-30-04-2008 (DOT) news-group.org> wrote:

The admin. His script sucks.
There is a mismatch between the SYSTEM tablespace and the
controlfiles.
Why don't you just use RMAN duplicate, or a RMAN cold backup?
Why do people rather 'engineer' their own crap solution, as opposed to
reading the docs, and using the tools Oracle already provides for this
purpose?
And why do they start crying out for help here, without even trying to
troubleshoot it?

--
Sybrand Bakker
Senior Oracle DBA