删除了redo文件库还活着？

lujiaguai

唐sir:
不解，为何我删了3个redo，可是库却还活着？？

SQL>  select GROUP#,STATUS ,TYPE ,MEMBER from v$logfile;
    GROUP# STATUS  TYPE    MEMBER
---------- ------- ------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
         3         ONLINE  /u01/app/oracle/oradata/PROD4/redo03.log
         2         ONLINE  /u01/app/oracle/oradata/PROD4/redo02.log
         1         ONLINE  /u01/app/oracle/oradata/PROD4/redo01.log

SQL> ! ls /u01/app/oracle/oradata/PROD4
control01.ctl  example01.dbf  redo01.log  redo02.log  redo03.log  sysaux01.dbf  system01.dbf  temp01.dbf  undotbs01.dbf  users01.dbf

SQL> ! rm /u01/app/oracle/oradata/PROD4/redo*

SQL> ! ls /u01/app/oracle/oradata/PROD4
control01.ctl  example01.dbf  sysaux01.dbf  system01.dbf  temp01.dbf  undotbs01.dbf  users01.dbf

SQL> alter system checkpoint;
System altered.

SQL> alter system switch logfile;
System altered.

SQL> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     174
Current log sequence           175


SQL> update hr.employees set salary=10000 where employee_id=100;
1 row updated.

SQL> commit;
Commit complete.


SQL> select salary from hr.employees where employee_id=100;
    SALARY
----------
     10000

SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE

SQL> ! ls /u01/app/oracle/oradata/PROD4  
control01.ctl  example01.dbf  sysaux01.dbf  system01.dbf  temp01.dbf  undotbs01.dbf  users01.dbf

botang

Linux文件系统高度异步IO造成的。