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

From: Mathias Wiedmer <mathiaswiedmer_at_yahoo.com>
Date: Thu, 13 Jun 2002 20:26:37 +0200
Message-ID: <3D08E3DD.6030201@yahoo.com>

If there is any possibility to drop the fault TS, whithout connecting, I   would be fine. The problem are all the other tablespaces, which I need. Just to delete the datafile is properbly not enough?!

Mathias Wiedmer

Sybrand Bakker wrote:

> "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
>>Dseldorf
>>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:26:37 CDT