Live Tablespace restore/rollback to a old state
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Live Tablespace restore/rollback to a old state

  1. #1
    Join Date
    Jul 2003
    Posts
    135

    Question Live Tablespace restore/rollback to a old state

    Environment: Oracle 10g Standard edition (datapump not available), Windows 2003 server

    1. How can we restore/rollback to a old state at tablespace level without
    . bouncing/shutting down the database
    . without export and import

    We can take tablspace hotbackup. What I am trying to do is not exactly recovery but rollback to hotback tablespace file. Now while database is up, OS will not let me delete/rename the exisiting dbf file.

    2. When we take tablespace export, is it consistent data? -
    what is happening to data changes (DML, DDL etc.) while export (or import) is going on.
    while importing what happens to exisiting tables which have been overwritten with new definitions im export dump file.

    Thanks in advance for helping.

    -D

  2. #2
    Join Date
    Nov 2000
    Posts
    224
    1) Try tablespace point in time recovery, I have never done it, but here is your link,
    http://www.lc.leidenuniv.nl/awcourse...2/ostspitr.htm

    2) Oracle provides you read consistent image of data when doing export.

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