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

Thread: online tablespace backup was interrupted by a system failure

  1. #1
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Hi

    Does anyone know how to recover from an system failure when perfoming online backup?

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Two possibilities.

    1. With instance mounted, isue
    ALTER DATABASE DATAFILE 'filexxx' END BACKUP;
    for all the files of the tablespace that was in backup mode.

    2. Restore the previous backup of datafiles and recover the database as usually.

    In both cases youl'll get the database in the state it was immediately before the crash.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Thanx ;)

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