Re: Help needed making a DB copy

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Thu, 18 Mar 2004 03:06:52 +1100
Message-ID: <405877a0$0$8356$afc38c87@news.optusnet.com.au>

"Vince Laurent" <eAddict_at_yahoo.com> wrote in message news:lbpg50hvfeg87jadpinso1uu2ngu0n1s9b_at_4ax.com...
> Why would I get the following error?
>
> SQL> @/oracle/SND/v1.trc
> ORACLE instance started.
>
> Total System Global Area 610062344 bytes
> Fixed Size 737288 bytes
> Variable Size 301989888 bytes
> Database Buffers 306012160 bytes
> Redo Buffers 1323008 bytes
>
> Control file created.
>
> SQL> alter database open resetlogs;
>
> alter database open resetlogs
> *
> ERROR at line 1:
> ORA-01092: ORACLE instance terminated. Disconnection forced
>
> The v1.trc file is the exported controlfile from DEV cleaned out so it
> just creates a control file.
>
> I am running Oracle 9.2.0.4 on HP-UX 11i
>
> Vince
> --------------------------------------

Because your init.ora or spfile refers to an undo tablespace which doesn't exist.

It can also happen for other reasons, but working out whether it's this or that... well, that's what the alert log is for. You should read it sometime.

Regards
HJR Received on Wed Mar 17 2004 - 10:06:52 CST