DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Datafile recovery -- Urgent

  1. #1
    Join Date
    Sep 2005
    Posts
    278

    Datafile recovery -- Urgent

    The status of the datafile is RECOVER, I have flash back recovery enable.

    In my 1.6 yrs carear this is the first time, I never recover the datafile, there are three datafiles for the tablespace. But all of the important objects of the schema is stored in that tablespace

    Need guidance to recover.

  2. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Supply following info

    1. database archive log or noarchive log mode
    2. What kind of backups you have RMAN or others. to tape or disk. What is the latest backuo
    3. How many data files in recover mode
    4. Database version
    5. Do you have all the archive logs after the last backup of the lost data files.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  3. #3
    Join Date
    Sep 2005
    Posts
    278
    The database is in Archive Log Mode, only one Datafile is in Recovery mode, the last backup is of 21-Jul-2006. I have archive logs after the last backup. The backup is taken through RMAN to disk

    The version of Database is 10gr2.

    Is it possible to recover only specific datafile, without effecting the other?

  4. #4
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    1. identify the FILE_ID of the lost datafile
    2. Start rman
    3. RMAN> restore datafile file_id;
    4. RMAN> recover datafile file_id;

    If should recover the datafile if all the archive logs are available.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  5. #5
    Join Date
    Sep 2005
    Posts
    278
    Is it all, the fileid is 10

    Should I wait for senior DBA, or if it is all then I will go through it.

    Waiting for ur valuable input.

    Thanks

  6. #6
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    If you have a Sr. DBA.. definitely talk him before you do anything.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    just offline the tablespace and recover the tablespace

  8. #8
    Join Date
    Sep 2005
    Posts
    278
    dear pando do u mean to recover the entire tablespace or a specifc datafile, after making the tablespace offline?

    HTML Code:
    According to Thomasps
    
    1. identify the FILE_ID of the lost datafile
    2. Start rman 
    3. RMAN> restore datafile file_id;
    4. RMAN> recover datafile file_id;

  9. #9
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    alter tablespace x offline
    recover tablespace x
    alter tablespace x online

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