Interesting Situation-Restore
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Interesting Situation-Restore

  1. #1
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316

    Wink

    Here is the situation that we are in:

    One table was dropped (by mistake), so we resotored the needed datafile, control files, redo logs (from a cold backup) to development machine. Took all the not-needed datafiles offline, renamed the restored file to the new location. And bingo, we had a new database, with that table data as of the cold backup.

    NOW, here is the question:
    With the database having only limited number of datafiles online, is it possible to apply the archieve logs to a certain point in time ?? I don't think so, since all the peices are in sync (and Oracle does not need to recover)- but I thought to check with the GURUs of dbasupport.com !

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    There is something called Tablespace Point in Time Recovery which allow you to recover a tablespace to a time different to other tablespaces in the database, the process is pretty long, check the documentation

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Here is a link that would help you

    http://www.oradoc.com/ora816/server....itr.htm#430218

    Sam
    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