drop table and constraints - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: drop table and constraints

  1. #11
    Join Date
    Feb 2001
    Posts
    51

    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?


    thanks

  2. #12
    Join Date
    Aug 2000
    Posts
    462
    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
    Posts
    389
    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
    Posts
    51
    k
    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