ORACLE 一致读(Consistent Read)的步骤
1. Read the Data Block.
2. Read the Row Header.
3. Check the Lock Byte to determine whether there's an ITL entry.
4. Read the ITL entry to determine the Transaction ID (Xid).
5. Read the Transaction Table using the Transaction ID. If the transaction has been committed and has a System Commit Number less than the query's System Change Number, update the status of the block (block cleanout) and start over at step 1.
6. Read the last undo block (Uba).
7. Compare the block transaction ID with the transaction table transaction ID. If the Transaction ID in the undo block doesn't equal the Transaction ID from the Transaction Table, then issue ORA-1555, Snapshot Too Old.
8. If the Transaction IDs are identical, make a copy of the data block in memory. Starting with the head undo entry, apply the changes to the copied data block.
9. If the tail undo entry (the actual first undo entry in the chain, or the last in the chain going backwards!) indicates another data block address, read the indicated undo block into memory and repeat steps 7 and 8 until the undo entries don't contain a value for the data block address.
10. When there's no "previous data block address," the transaction has been completely undone.
11. If the undo entry contains:
a. a pointer to a previous transaction undo block address, read the Transaction ID in the previous transaction undo block header and read the appropriate Transaction Table entry. Return to step 5.
b. an ITL record, restore the ITL record to the data block. Return to step 4.
注释说明：
事实上在第6步之前，会先比较query scn和control scn(下面红色字体是解释)，如果control scn > query scn，oracle根本就不去尝试读取undo block了，因为注定失败，立刻报1555错误.
第7步，表示
不是修改了当前block的事务没有commit
就是事务commit了但是commit scn >query scn，（因为第5步已经判断commit scn<query scn的情况）
所以准备要读取回滚段中的前镜像。
第9步，你可以把rollback的过程想象为一个链表，从一个undo block链到另一个undo block，�
相关文档：
数据库设计：
CREATE TABLE ADVERTISE_CATEGORY
(
CATEGORY_ID NUMBER PRIMARY KEY, --节点ID
CATEGORY_NAME VARCHAR2(500), &nb ......
1.什么是RMAN？
RMAN可以用来备份和还原数据库文件、归档日志和控制文件。它也可以用来执行完全或不完全的数据库恢复。
注意：RMAN不能用于备份初始化参数文件和口令文件。
RMAN启动数据库上的Oracle服务器进程来进行备份或还原。备份、还原、恢复是由这些进程驱动的。
RMAN可以由OEM的Backup Manager ......
1.OracleDBConsoleorcl oem控制台的服务进程
2.OracleJobSchedulerORCL 定时器的服务进程
3.OracleOraDb10g_home1iSQL*Plus isql*plus的服务进程
4.OracleOraDb10g_home1TNSListener 监听器的服务进程
5.Or ......
今天复习第三章，本来算起来应该是第二章的，但是第二章的内容是介绍数据库的管理工具，而对于我们而言，这些相对来说没有多大的必要，所以，现在步入复习Oracle实例的管理。这章的内容包括初始化参数文件的维护和管理，以各种不同的方式启动和概念比数据库Oracle Instance，以及对Oracle I ......
