删除Flashback Log后数据库关闭???

开启了闪回功能，无意中删除了Flashback 日志后停机了?

AlertLog:
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_rvwr_660.trc:
ORA-38701: Flashback database log 93 seq 3217 thread 1: "D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\FLASHBACK\O1_MF_5HL0DN6T_.FLB"
ORA-27041: unable to open file
OSD-04002: 无法打开文件
O/S-Error: (OS 2) 系统找不到指定的文件。
Thu Dec 10 09:59:41 2009
RVWR: terminating instance due to error 38701
Thu Dec 10 09:59:41 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_j000_5584.trc:
ORA-38701: 闪回数据库日志  序列  线程 : ""
Thu Dec 10 09:59:41 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_pmon_496.trc:
ORA-38701: Flashback database log  seq  thread : ""
Thu Dec 10 09:59:42 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_mman_540.trc:
ORA-38701: Flashback database log  seq  thread : ""
Thu Dec 10 09:59:42 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\udump\myoracle_ora_2524.trc:
ORA-01092: ORACLE instance terminated. Disconnection forced
Thu Dec 10 09:59:43 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_lgwr_548.trc:
ORA-38701: Flashback database log  seq  thread : ""
Thu Dec 10 09:59:43 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_dbw0_544.trc:
ORA-38701: Flashback database log  seq  thread : ""
Thu Dec 10 09:59:43 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_j001_4952.trc:
ORA-38701: Flashback database log  seq  thread : ""
Thu Dec 10 09:59:44 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_ckpt_552.trc:
ORA-38701: Flashback database log  seq  thread : ""
Thu Dec 10 09:59:47 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_smon_556.trc:
ORA-38701: Flashback database log  seq  thread : ""
Thu Dec 10 09:59:49 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\udump\myoracle_ora_2508.trc:
ORA-01092: ORACLE instance terminated. Disconnection forced
Thu Dec 10 09:59:49 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_q005_1944.trc:
ORA-38701: Flashback database log  seq  thread : ""
Thu Dec 10 09:59:52 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\udump\myoracle_ora_2576.trc:
ORA-01092: ORACLE instance terminated. Disconnection forced
Thu Dec 10 09:59:52 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_q000_4788.trc:
ORA-38701: Flashback database log  seq  thread : ""
Thu Dec 10 09:59:52 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_q002_5252.trc:
ORA-38701: Flashback database log  seq  thread : ""
Thu Dec 10 10:00:07 2009
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_reco_588.trc:
ORA-38701: Flashback database log  seq  thread : ""
Thu Dec 10 10:00:09 2009
Instance terminated by RVWR, pid = 660

  

关于Flashback日志管理的文档参考

 

This document is being delivered to you via Oracle Support\'s Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:
Oracle Server Enterprise Edition - Version: 10.1.0.2 to 10.2.0.1
Information in this document applies to any platform.
Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.1
Goal
The  recovery file dest is full of flashback logs. There are ORA-19815 errors in the production alert log, then its necessary to remove or reuse the flashback logs (FBL).

Solution
Flashback logs are handled internally and we have no control over them. This means
that we cannot delete flashback logs manually, the ONLY way to delete then
is disabling FLASHBACK.

The FlashBack Logs can ONLY be deleted by DISABLING FLASHBACK
on database level

SQL> startup mount
     alter database flashback off;
     alter database open;

During space pressure, the Flashback logs are deleted under two
conditions:

1) When an archivelog is deleted, it would also delete the flashback logs
    that are dependent on the archived log.
2) When quota is shrunk, then flashback logs is deleted to reclaim disk
    space. This is decreasing the DB_RECOVERY_FILE_DEST_SIZE to such a value
     that the  FLB itself will run into a space pressure and than the old
     FLB\'s will get  deleted.

We can hit bellow bug and then the flashback logs are not deleted
even there is space pressure in the Flash backup disk space.   
   

Bug 5106952
Hdr: 5106952 10.2.0.1.0 RDBMS 10.2.0.1.0 FLASHBACK_DB PRODID-5 PORTID-23
Abstract: FLASHBACK LOG SPACE NOT BEING RECLAIMED
Fixed In Ver: 11.0
Also the bug is  fixed in patch set 10.1.0.6  and 10.2.0.3 .


The workaround to this  bugs is to disable flashback database option then it  will  be possible to remove the FBL.

1.- First of all we need to check if there is any guaranteed restore point defined:

select name,scn,time,database_incarnation#,guarantee_flashback_database,storage_size from v$restore_point;


2.- Remove all the restore points

     Drop restore point <name>;

  3.- Check how much space is used before turning off Flashback

    select * from v$flash_recovery_area_usage;

4.- ALTER DATABASE FLASHBACK OFF;


5.-  Now you can delete the Flashback logs manually


6.- ALTER DATABASE FLASHBACK ON;


7.- Check that there are no flashback logs before turning back on

       select * from v$flash_recovery_area_usage;

 

总结：故障原因未明，不知道是不是Bug?

看来oracle 自己可以管理Flash日志文件，一般不需要手动删除