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

Thread: recover a database

  1. #1
    Join Date
    Jan 2001
    Posts
    32
    Hi all

    I have a database in Oracle 7.3.4, that is in archive log mode,
    if the database don't crash, but i want to recover the database until 1 hour ago (in others worlds, undo the last hour of transaction).

    can i do it with recovery command.

    example

    recover database until time '2001-06-01:13:56:2';


  2. #2
    Join Date
    Mar 2001
    Posts
    635
    Hi

    You can do it as long as you have the archive log files

    Regards
    Santosh

  3. #3
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    you will have to restore the old backup (older than the point in time of recovert you need) and then *recover* the database using the archived logs.

    You can't go back in time without recovering the database !

    - Rajeev
    Rajeev Suri

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Once you do this then you might also want to take the database to the incarnation level by reseting the logs. Be aware, once you reset your logs, then you cannot use the old logs for any recovery.


    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