DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14
  1. #11
    Join Date
    Feb 2001

    now i'm really confused.

    I did a hot backup. thats all I can answer you. the rest, I don't quite understand how to do so.

    couldn't I just cp /u03/stage/system01.dbf and all of the related files back to its orginal location and run some kind of a recover command?


  2. #12
    Join Date
    Aug 2000
    After point-in-time recovery to 3 hours ago, won't all subsequent transactions be lost upon open resetlogs?

  3. #13
    Join Date
    Feb 2001
    In 8.1.6 u can use tablespace point in time recovery.
    But do have the latest database available or the backup , as previous threads suggest u have already overwritten latest datafiles.

  4. #14
    Join Date
    Feb 2001
    this is the moment of truth. I manually cp everything back.

    now this is what i got.
    SQL> recover database until time '2001-02-28:12:00:00';
    ORA-00283: recovery session canceled due to errors
    ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

    what next?

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.