SMON实例恢复问题！！
本帖最后由 zhou925290547 于 2013-04-05 16:04:11 编辑 我今天下午做了个实验，就是delete了scott用户下的emp表中empno=7788的那一条数据，没有提交，然后查看了一下这个表中的总数是13条，然后startup force 一下数据库，启动后我又查看了一下表中的数据还是13条，为什么我查出的那一条没有被recover啊！！！！告警日志里也提示说做了recover！！！求解答，在线等啊！！！
我把告警日志也贴出来吧！
ompleted: ALTER DATABASE MOUNT
Fri Apr 5 15:13:07 2013
ALTER DATABASE OPEN
Fri Apr 5 15:13:07 2013
Beginning crash recovery of 1 threads
Fri Apr 5 15:13:07 2013
Started redo scan
Fri Apr 5 15:13:07 2013
Completed redo scan
506 redo blocks read, 34 data blocks need recovery
Fri Apr 5 15:13:08 2013
Started redo application at
Thread 1: logseq 53, block 1164
Fri Apr 5 15:13:08 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 53 Reading mem 0
Mem# 0 errs 0: /u01/app/oracle/oradata/cuug/redo01a.log
Fri Apr 5 15:13:08 2013
Completed redo application
Fri Apr 5 15:13:08 2013
Completed crash recovery at
Thread 1: logseq 53, block 1670, scn 456404
34 data blocks read, 34 data blocks written, 506 redo blocks read
Fri Apr 5 15:13:08 2013
Thread 1 advanced to log sequence 54
Thread 1 opened at log sequence 54
Current log# 2 seq# 54 mem# 0: /u01/app/oracle/oradata/cuug/redo02a.log
Successful open of redo thread 1
Fri Apr 5 15:13:08 2013
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Apr 5 15:13:08 2013
SMON: enabling cache recovery
Fri Apr 5 15:13:08 2013
Successfully onlined Undo Tablespace 1.
Fri Apr 5 15:13:08 2013
SMON: enabling tx recovery
Fri Apr 5 15:13:08 2013
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=13, OS id=11118
Fri Apr 5 15:13:10 2013
Completed: ALTER DATABASE OPEN
Fri Apr 5 15:13:45 2013
Adjusting the default value of parameter parallel_max_servers
from 40 to 25 due to the value of parameter processes (40)
Fri Apr 5 15:13:45 2013
Starting ORACLE instance (normal)
Fri Apr 5 15:14:39 2013
Stopping background process MMNL
Fri Apr 5 15:14:39 2013
Stopping background process MMON
Starting background process MMON
Starting background process MMNL
MMON started with pid=10, OS id=11229
Fri Apr 5 15:14:40 2013
ALTER SYSTEM enable restricted session;
MMNL started with pid=11, OS id=11231
Fri Apr 5 15:22:43 2013
ALTER SYSTEM disable restricted session;
[解决办法]
