Recover Datafile

[steeve123]

I did a big import yesterday and i had a problem.

Mon Apr 07 16:19:55 2003
KCF: write/open error block=0x180070 online=1
file=25 D:\ORA8I\ORANT\DATABASE\INTEGRA.ORA
error=27069 txt: 'OSD-04026: Invalid parameter passed. (OS 1572976)'
Automatic datafile offline due to write error on
file 25: D:\ORA8I\ORANT\DATABASE\INTEGRA.ORA


Its a bug from Oracle, metalink note: 148894.1
My datafile was in autoextend and reach 12 gig, then boom.

Since i have lost of users on different tablespaces, i cant close the database and solve it right away. So i took from my backup the datafile in trouble from friday night.

Now i want to recover the datafile until monday morning. I thought this command would of work, but there's no "until time" for the recover datafile command. RECOVER DATAFILE 'D:\ORA8I\ORANT\DATABASE\INTEGRA.ORA' UNTIL TIME '2003-04-07 10:00:00';
ORA-00274: illegal recovery option UNTIL

NOTE: i dont use rman.



So my question is:

Is my only option is to take from my friday backup the datafile in trouble + system datafile + control_file + online log + archive log , create a new test instance, recover the database "until time", then issue a export of owner in tablespace in trouble.
Now i have a nice export.
In my real instance, i drop that tablespace and recreate it, then issue an import.

Is it my only option?

note: My database is 24/24, i dont have much downtime available.

[pando]

well you cannot do incomplete recovery of an datafile, you ca do that with a database but NOT a datafile, and it is logical if you think about it

[steeve123]

So i need to create a test instance?
and then recover databse until time, export user.

[pando]

well why you dont get the export dump you used yesterday for your import?

[steeve123]

I just found out that we have a full export from friday night.

I will drop all 15 owner related to that datafile. And i just found out that we need only 5 owner, all other is garbage.
So i will drop, recreate that tablespace, then 5 owner import.

So no need to create test instance and all.