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.
04-08-2003, 11:05 AM
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
04-08-2003, 11:15 AM
So i need to create a test instance?
and then recover databse until time, export user.
04-08-2003, 11:19 AM
well why you dont get the export dump you used yesterday for your import?
04-08-2003, 11:32 AM
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.