Jeff Hunter, please help!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Jeff Hunter, please help!

  1. #1
    Join Date
    Jun 2000
    Posts
    55
    If database crashed during hotback up, do you loss any data? Can you bring your db to the point of failure? Is incomplete recovery a must?

    Thanks

  2. #2
    Join Date
    Mar 2001
    Posts
    16

    Talking

    hi gingbo
    1. data is not gonna lose
    2. mount the database
    3. issue "alter database datafile end backup"
    4. then take the datafile offline and restore and/or recover it
    5. Then bring the datafile online.

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Depends on what died. If you have lost a datafile, then you can follow the above procedure. If you have lost a control file, then it is probably an incomplete recovery.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    When a tablespace is in hot backup mode, and the database crashes, start up the database in mount mode. Query from V$BACKUP to find out which data files (also tabelspace) are in backup mode, then issue ALTER TABLESPACE END BACKUP; then ALTER DATABASE OPEN;
    You do not need to recover the database/datafile.

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