Prev: 10g ORA-30625: method dispatch on NULL SELF argument is disallowed
Next: Oracle Spatial SDO Aggregate Union fails with ORA-29913 ODCIAGGREGATEMERGE
From: Andreas Mosmann on 21 Apr 2008 12:50
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
From: Frank van Bortel on 21 Apr 2008 15:22
Andreas Mosmann wrote:

>
> .. 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?
>

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
From: Andreas Mosmann on 21 Apr 2008 17:00
Frank van Bortel schrieb am 21.04.2008 in
<2bcf4$480ce95c$524b5c40$22691(a)cache3.tilbu1.nb.home.nl>:

> Andreas Mosmann wrote:

>>
>> .. 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?
>>

> 1) A new administrator - look up db cloning with RMAN:
> 7 lines of code...
Sounds simple, but I did not find up to now. I look for.
> 2) trace and log files - alter log to start with.

> And you could provide a little more info:
Sorry, I didn't want to be boring ;)
> * What version of Oracle
Oracle 9.2.0.7i
> * What platform (other than the obvious Microsoft)
MS Windows (Source: Win2003 Server, Destination: WinXP Prof)
> * same, or other machine (if other - patch levels the same?!?)
different machines, same patchlevel, different number of processors

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.

> FvB
Thank you very much
Andreas Mosmann

--
wenn email, dann AndreasMosmann <bei> web <punkt> de
 | 
Pages: 1
Prev: 10g ORA-30625: method dispatch on NULL SELF argument is disallowed
Next: Oracle Spatial SDO Aggregate Union fails with ORA-29913 ODCIAGGREGATEMERGE