Hot backup doubt
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Hot backup doubt

  1. #1
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323

    Question

    Hi


    Let us assume that my database is running in Archive log mode, and suddenly my hard disk has crashed, which contains all datafiles, control files, online redolog files. Fortunately I had a hot backup just few mins before the hard disk crash, and no new archive log has been generated. Assume that some of the transactions were made to the database.

    1. Can it be possible to recover the database fully? If yes, please let me know the steps to be performing to recover fully.

    2. Do I need to backup online redologs, during my hot backup?

    3. Do I need to keep my previous archive log files, after my hot backup performed successfully?

    Any help in this regard highly appreciated.

    Thanks In Advance.
    Nagesh

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    1. If you loose your online redo logs as well then you can't recover your database "fully". Transactions recorded in online redo logs can not be revoverd if you lost them before it has been archived.

    2. You do not backup your online redo log files during hotbackup.

    3. You don't have to keep the archived log files after a successful hotback unless you want a PITR before that successful hotbackup.

    Sanjay


  3. #3
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    Thanks Sanjay,

    That means, always one should prepare for the worst. Right?

    To avoid this kind of circumstances, what would you suggest?


    Thanks in Advance.

    Nagesh

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    That is why we keep multiple log file members on different disks.

    Ciao
    Sanjay

  5. #5
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    Thanks Sanjay.
    Nagesh

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