Hot backups and data integrity
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Hot backups and data integrity

Hybrid View

  1. #1
    Join Date
    Aug 2000
    Posts
    143

    Question

    When taking hot backups, it is recommended to back one tablespace at a time. When the backup is over, tablespaces are left with transactions in one table that do not correspond to transactions in another table. Has this ever caused problems for anyone after database recovery?

  2. #2
    Join Date
    Jun 2000
    Posts
    417
    That's what redo/archived logs are for :)

    I've never run into a situation in a production environment where I've had to recover a hot backup, but in small tests there's never been a problem.

  3. #3
    Join Date
    Aug 2000
    Posts
    143
    If I had to recover from a hot backup, would I have to apply all redo/arc logs produced from the start of the backup?

    If so Is oracle clever enough to know that certain transactions already exist on some tables but not on corresponding tables?

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095

    The absolute best explanation I have found on this topic is at:
    [url]http://osi.oracle.com/wa/ask/owa/ask_tom_pkg.display?p_dispid=271815712711[/url]





  5. #5
    Join Date
    Sep 2000
    Posts
    128
    When you issue the recover - oracle knows exactly what transactions to apply from what redo log files by the SCN's.

    It will prompt you for the relevant files to my knowledge. Haven't done a hot recoverer since my course though :)

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