过着简单,真实的生活,喜欢收藏变形金刚(TFE,G1,SL系列),研究金融股市,KOF98,篮球,学习研究Oracle技术,我并不是一个全职的Oracle DBA,但是对于Oracle技术的热爱和研究,是一个不争的事实,愿意结交广大Oracle技术爱好者!MSN:oracle_kof_tf@hotmail.com

resetlogs的作用

上一篇 / 下一篇  2008-02-03 13:39:47 / 个人分类:Oracle数据库技术-Backup&Recovery

The primary function of resetlogs is to discard the redo that was not  
applied during incomplete recovery, ensuring that the skipped redo  
can never be accidentally applied by a subsequent recovery. To  
accomplish this, resetlogs effectively invalidates all existing redo  
in all online and archived redo logfiles. This has the side effect of  
making any existing datafile backups unusable for future recovery  
operations.

Resetlogs also reinitializes the controlfile information about online  
logs and redo threads, clears the contents of any existing online  
redo log files, creates the online redo log files if they do not  
currently exist, and resets the log sequence number in all threads to  
one.

因此再次切记,我们最好在resetlogs之后,做一次全库backup.

TAG:

 

评分:0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

Open Toolbar