过着简单,真实的生活，喜欢收藏变形金刚(TFE,G1,SL系列)，研究金融股市，KOF98，篮球，学习研究Oracle技术,我并不是一个全职的Oracle DBA，但是对于Oracle技术的热爱和研究，是一个不争的事实，愿意结交广大Oracle技术爱好者！MSN:oracle_kof_tf@hotmail.com
Recovery through resetlogs
上一篇 /
下一篇 2008-02-03 14:38:49
/ 个人分类：Oracle数据库技术-Backup&Recovery
下面就是如何跨越resetlogs来恢复db,请注意change num的输入：
1. Copy the current DB control files to another location.
2. Restore the data files and control files from a backup before the lastRESETLOGSoperation.
3. Mount DB
4. In alert file,find the “change num“ at the completion of the previousRESETLOGSoperation.
5. Recover the DB until the change num locate in the alert file
Sql>recover database until change 309121 using backup controlfile;
6. Shutdown DB using “normal”
7. Restore the current control files from the location specified in step 1.
8. Mount DB
9. Recover DB using the appropriate opetion in RECOVER DATABASE command.
10. Open DB
11. Validate the data you recover.
12. Make sure recovery go to the correct log sequence num by view v$log.
13. Backup DB to prevent recovery through reset logs.
导入论坛
引用链接
收藏
分享给好友
推荐到圈子
管理
举报
TAG:
