-
Recover Datafile
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.
-
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
-
So i need to create a test instance?
and then recover databse until time, export user.
-
well why you dont get the export dump you used yesterday for your import?
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|