Recover Datafile
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Recover Datafile

Hybrid View

  1. #1
    Join Date
    Nov 2000
    Posts
    440

    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.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    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

  3. #3
    Join Date
    Nov 2000
    Posts
    440
    So i need to create a test instance?
    and then recover databse until time, export user.

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    well why you dont get the export dump you used yesterday for your import?

  5. #5
    Join Date
    Nov 2000
    Posts
    440
    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
  •  



Click Here to Expand Forum to Full Width