oracle scn学习

一直不明白scn怎么工作的，今天他妈的不搞清楚，不睡了。
偶发现如果想要了解scn必须知道各种恢复是怎么回事。
1。3种恢复类型

• Instance recovery
• Crash recovery
• Media recovery.

前两种是在实例启动过程中自动进行运行的，只有介质恢复才需要手动处理。

instance recovery is only used in rac environment ,it's the application of online redo log  by one instance that detected the crash of the other instances.暂时不了解。

Oracle performs an automatic crash recovery when the instance is started after a shutdown abort or after a crash.

A crash recovery 'only' uses the online redo log to recover online datafiles.

Crash recovery is the recovery of a database in a single-instance configuration or an Oracle Real Application Clusters configuration in which all instances have crashed. In contrast, instance recovery is the recovery of one failed instance by a live instance in an Oracle Real Application Clusters configuration.
how to detect the need of crash recovery ? if stop scn in control file is null or 0xfff.ffffffff,or less than system checkpoint scn ,then the database must be shutdown abort.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7928987/viewspace-416153/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7928987/viewspace-416153/