官术网_书友最值得收藏!

Restore versus recovery

On several occasions, people have asked me about the differences between restore and recovery. Due to these questions, I will take this opportunity to explain the difference in some simple words to make it clear:

  • Restore: It is the act that involves the restoration of all files that will be required to recover your database to a consistent state, for example, copying all backup files from a secondary location such as tape or storage to your stage area
  • Recovery: It is the process to apply all transactions recorded in your archive logs, rolling your database forward to a point-in-time or until the last transaction recorded is applied, thus recovering your database to the point-in-time you need

You will see some examples of how restore and recovery work later in this book. Now let's take a closer look at what is redo log and the two possible modes your database could be operating in. This will help you understand in a bit more in depth what type of backup and recovery you could use on your environment.

主站蜘蛛池模板: 克什克腾旗| 奉化市| 景德镇市| 崇阳县| 金湖县| 将乐县| 关岭| 会宁县| 太原市| 涞源县| 宜兰市| 卓资县| 靖远县| 革吉县| 齐河县| 资兴市| 邢台市| 灌阳县| 新巴尔虎左旗| 陆川县| 应用必备| 大田县| 措勤县| 阳山县| 和政县| 沈丘县| 内江市| 江孜县| 壶关县| 华安县| 庆阳市| 屏南县| 日土县| 柳河县| 成安县| 饶平县| 富顺县| 台东市| 卢龙县| 仁寿县| 五原县|