【原】SCN Oracle Start-up Checks

简介: 作者:david_zhang@sh 【转载时请以超链接形式标明文章】 链接:http://www.cnblogs.com/david-zhang-index/archive/2012/07/01/2572190.

作者:david_zhang@sh 【转载时请以超链接形式标明文章】

链接:http://www.cnblogs.com/david-zhang-index/archive/2012/07/01/2572190.html

oracle数据库启动时,scn检查原则及解决办法:

Condition on Star-Up Oracle Behavior DBA Action
CF checkpoint < Datafile checkpoint SCN "Control file too old"error Restore a newer control file
CF checkpoint > Datafile checkpoint SCN Media recovery required Most likely a datafile has been restored from backup Recovery is now required
CF checkpoint = Datafile checkpoint SCN Start up normally None
Database in mount mode,instance thread status = OPEN Crash recovery required None

 备注:cf=control file

相关文章
|
Oracle 关系型数据库 DataX
工作记录之ORacleSQL报错:oracle ORA-01476:divisor is equal to zero
com.alibaba.datax.common.exception.DataXException: Code:[Framework-14], Description:[DataX传输脏数据超过用户预期,该错误通常是由于源端数据存在较多业务脏数据导致,请仔细检查DataX汇报的脏数据日志信息, 或者您可以适当调大脏数据阈值 .]. - 脏数据条数检查不通过,限制是[0]条,但实际上捕获了[42]条.
807 0