Recover database using backup controlfile until cancel
http://searchoracle.techtarget.com/answer/Recover-database-using-backup-controlfile-until-cancel
What is checked or what happens when we "run recover database using backup controlfile until cancel;"? What does this command do and when do we use this command?
If you were to recover the database with a current control file, Oralce will know the last SCN of the last checkpoint. So Oracle can use the information in the archived and online redo logs to apply recovery up to that SCN. This is called a "complete" recovery.
If you do not have the current control file, your option is to use a backup controlfile. Which means Oracle does not know the SCN to stop applying recovery. So you tell Oracle that you are using a "backup controlfile" and that you will tell it when to stop applying redo by replying "cancel." When Oracle starts recovery, it looks at the datafiles to know the last time a checkpoint was performed on the datafile. Oracle now knows to start applying recovery to the datafile for all SCNs after the SCN in the datafile header. Oracle rolls forward transactions. But Oracle does not know when to stop, and eventually, Oracle applies recovery in all of your archived redo logs. You can then tell Oracle to use the redo in the online redo logs. Oracle will ask you where to find more redo. At this point, you tell it to quit applying redo by replying CANCEL.
Hopefully, you never have to use this command. This is because you multiplex your control files and have three copies of the control file, all on different disk units. So if you lose a disk unit, you use the control files on the other disk units. The only time you need this command is when you lose all of your control files. In this case, either use a binary backup of the control file or you re-create the control file with the CREATE CONTROLFILE command and then recover with the backup control file.
最新文章
- UnityEditor
- android 弹出对话框之四周变暗处理方式
- [2014.01.27]wfRadar 雷达图组件 2.5
- C语言获取时间
- dlmalloc(Android bionic C库的malloc实现)简介
- 排序命令sort
- MVC小系列（十九）【mvc与站点地图】
- C#网页版计算器程序代码
- 【问题】pod setup 问题
- Menu的自己定义实现-------保卫萝卜造塔升级塔菜单实现
- java字符串，包，数组及空心正方形，菱形的实例
- 一个CSS简单入门网站
- [LeetCode] Partition to K Equal Sum Subsets 分割K个等和的子集
- 阿里面试100%问到，JVM性能调优篇
- ElasticSearch 2 (9) - 在ElasticSearch之下（图解搜索的故事）
- thinkphp链接多个数据库时怎么调用M方法？
- Linux 保护文件 不给修改
- WebSocket和long poll、ajax轮询的区别，ws协议测试
- 20170928xlVBA自定义分类汇总
- 51.纯 CSS 创作一个雷达扫描动画