datafile corrupted on non archivelog - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: datafile corrupted on non archivelog

  1. #11
    Join Date
    May 2002
    Posts
    163
    Hi Sam,

    As a new starter I have a doubt. Pls clarify the same.

    ------------------------------------------------------------------------------------
    Mount the database
    alter database datafile '/../filename' offline;
    alter database open;

    restore the backup copies of the damaged datafile
    ------------------------------------------------------------------------------------

    If the datafile is corrupted and tablepsace is offline how do I restore the backup copies of the damaged datafile?

    I will appreciate if you expalin the same in details.

    regards



    Nwcomer
    Student

  2. #12
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    When I mentioned the restore of the backup file, I ment the os copies of them. Rename the original file, copy the backup file into the original place and then apply the recovery procedures.

    Code:
       recover tablespace tablespace_name;
    
       alter tablespace tablespace_name online;

    Sam

    [Edited by sambavan on 05-06-2002 at 10:49 AM]
    Thanx
    Sam



    Life is a journey, not a destination!


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