Re: HELP !!! Can not even connect me...

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 13 Jun 2002 20:06:19 +0200
Message-ID: <ughnois280ofd8@corp.supernews.com>

"Mathias Wiedmer" <mathiaswiedmer_at_yahoo.com> wrote in message news:3D08DAB4.5010507_at_yahoo.com...
> Hi folks,
>
> last night I created a new tablespace on my oracle 9i.
> The whole night, an application i use, did theyr restore.
> Tody, I dont have any idea, I cant even connect me to the Instanze
anymore.
>
> There is a Errormessage like:
>
> ORA-01122: Database-File 18 brought Error while verifying
> ORA-01110: Datafile 18: `path/to/dbs/tablespacename`
> ORA-01203: wrong version: wrong Creation-SCN
>
> Does anybody have any idea?
>
> I geus, the application which uses the tablespace, made something wrong.
> Actually it used theyr own librarys (oracle 8) to connect an work with
> the Database.
>
>
> Thanks a lot for any response and best reguards
>
>
> Mathias Wiedmer
> Düsseldorf
> Germany
>

From tahiti.oracle.com I searched for the error message (which you should have done)

ORA-01203 wrong incarnation of this file - wrong creation SCN

Cause: The creation SCN in the file header is not the same as the creation SCN in the control file. This is probably a copy of a file that was dropped.

Action: Restore a current copy of the datafile and do recovery as needed.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Thu Jun 13 2002 - 13:06:19 CDT