注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

lazydba

hello

 
 
 

日志

 
 

甲骨文 - Opening the Database with the RESETLOGS Option  

2007-09-12 11:07:33|  分类: all about databa |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |
Database Backup and Recovery Advanced User's Guide
10g Release 2 (10.2)
Part Number B14191-02
?

Whenever you perform incomplete recovery or recovery with a backup control file, you must reset the online logs when you open the database. The new version of the reset database is called a new incarnation.

Resetting the redo log does the following:

  • Archives the current online redo logs (if they are accessible) and then erases the contents of the online redo logs and resets the log sequence number to 1. For example, if the current online redo logs are sequence 1000 and 1001 when you open de<RESETLOGSde<, then the database archives logs 1000 and 1001 and then resets the online logs to sequence 1 and 2.

  • Creates the online redo log files if they do not currently exist.

  • Reinitializes the control file metadata about online redo logs and redo threads.

  • Updates all current datafiles and online redo logs and all subsequent archived redo logs with a new de<RESETLOGSde< de<SCNde< and time stamp.

Because the database will not apply an archived log to a datafile unless the de<RESETLOGSde< de<SCNde< and time stamps match, the de<RESETLOGSde< prevents you from corrupting datafiles with archived logs that are not from direct parent incarnations of the current incarnation.

In prior releases, it was recommended that you back up the database immediately after the de<RESETLOGSde<. Because you can now easily recover a pre-de<RESETLOGSde< backup like any other backup, making a new database backup is optional. In order to perform recovery through resetlogs you must have all archived logs generated since the last backup and at least one control file (current, backup, or created).


  评论这张
 
阅读(157)| 评论(1)
推荐 转载

历史上的今天

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2017