Incompleet Recovery
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Incompleet Recovery

  1. #1
    Join Date
    Jan 2006
    Posts
    2

    Question Incompleet Recovery

    I want to perforam an incompleet recovery. My current SCN number is 1000 for all datafiles. and i want to go back to a perevios SCN no. of a perticular datafile not all the datafiles. is it possible? if yes then plzzz tell me how...?

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    If that datafile is the single component of a tablespace, then in some circumstances you could do a tablespace point in time recovery (TSPITR). It 's a big subject, start here:
    http://download-west.oracle.com/docs...ov.htm#1004810
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

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