ra10g/下的全部文件）
[oracle@ora10g fd]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 25 15:57:57 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select count(*) from dba_objects;
COUNT(*)
----------
50314
SQL> create user aaron8219 identified by oracle;
User created.
SQL> grant dba to aaron8219;
Grant succeeded.
SQL> conn aaron8219/oracle
Connected.
SQL> create table test1(int number);
Table created.
SQL> select count(*) from dba_objects;
COUNT(*)
----------
50315
SQL> insert into test1 values(1);
1 row created.
SQL> insert into test1 values(2);
1 row created.
SQL> select * from test1;
INT
----------
1
2
SQL> select group#,status,members from v$log;
GROUP# STATUS MEMBERS
---------- ---------------- ----------
1 CURRENT 1
2 UNUSED 1
3 INACTIVE 1
SQL> exit --注意，这里执行exit会触发隐式提交，也就是说，insert的语句已经从buffer中写入了redo01.log中
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@ora10g fd]$ cd /u01/app/oracle/oradata
[oracle@ora10g oradata]$ cd ora10g
[oracle@ora10g ora10g]$ ll
total 1068440
-rw-r----- 1 oracle oinstall 7061504 Aug 25 16:01 control01.ctl
-rw-r----- 1 oracle oinstall 7061504 Aug 25 16:01 control02.ctl
-rw-r----- 1 oracle oinstall 7061504 Aug 25 16:01 control03.ctl
-rw-r----- 1 oracle oinstall 104865792 Aug 25 15:52 example01.dbf
-rw-r----- 1 oracle oinstall 52429312 Aug 25 16:01 redo01.log
-rw-r----- 1 oracle oinstall 52429312 Aug 25 15:52 redo02.log
-rw-r----- 1 oracle oinstall 52429312 Aug 25 15:52 redo03.log
-rw-r----- 1 oracle oinstall 251666432 Aug 25 16:01 sysaux01.dbf
-rw-r----- 1 oracle oinstall 503324672 Aug 25 15:57 system01.dbf
-rw-r----- 1 oracle oinstall 20979712 Aug 25 15:50 temp01.dbf
-rw-r----- 1 oracle oinstall 31465472 Aug 25 15:57 undotbs01.dbf
-rw-r----- 1 oracle oinstall 5251072 Aug 25 15:52 users01.dbf
--删除数据库文件，模拟故障
[oracle@ora10g ora10g]$ rm -rf *.*
[oracle@ora10g ora10g]$ ll
total 0
[oracle@ora10g ora10g]$ ps -ef | grep ora_lgwr
oracle 4566 1 0 15:52 00:00:01 ora_lgwr_ora10g
oracle 6784 2999 0 16:02 pts/2 00:00:00 grep ora_lgwr
[oracle@ora10g ora10g]$ cd /proc/4566/fd
[oracle@ora10g fd]$ ll
total 0
lr-x------ 1 oracle oinstall 64 Aug 25 16:02 0 -> /dev/null
lr-x------ 1 oracle oinstall 64 Aug 25 16:02 1 -> /dev/null
lrwx------ 1 oracle oinstall 64 Aug 25 16:02 10 -> /u01/app/oracle/admin/ora10g/adump/ora_4556.aud
l-wx------ 1 oracle oinstall 64 Aug 25 16:02 11 -> /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/dbca/ora10g/mkplug_v3_ora10g.log
lr-x------ 1 oracle oinstall 64 Aug 25 16:02 12 -> /dev/zero
lr-x------ 1 oracle oinstall 64 Aug 25 16:02 13 -> /dev/zero
lrwx------ 1 oracle oinstall 64 Aug 25 16:02 14 -> /u01/app/oracle/product/10.2.0/db_1/dbs/hc_ora10g.dat
lrwx------ 1 oracle oinstall 64 Aug 25 16:02 15 -> /u01/app/oracle/product/10.2.0/db_1/dbs/lkORA10G
lrwx------ 1 oracle oinstall 64 Aug 25 16:02 16 -> /u01/app/oracle/oradata/ora10g/control01.ctl (deleted)
lrwx------ 1 oracle oinstall 64 Aug 25 16:02 17 -> /u01/app/oracle/oradata/ora10g/control02.ctl (deleted)
lrwx------ 1 oracle oinstall 64 Aug 25 16:02 18 -> /u01/app/oracle/oradata/ora10g/control03.ctl (deleted)
lrwx------ 1 oracle oinstall 64 Aug 25 16:02 19 -> /u01/app/oracle/oradata/ora10g/redo01.log (deleted)
l-wx------ 1 oracle oi