Chinaunix首页 | 论坛 | 博客
  • 博客访问: 244936
  • 博文数量: 64
  • 博客积分: 1416
  • 博客等级: 上尉
  • 技术积分: 565
  • 用 户 组: 普通用户
  • 注册时间: 2010-03-18 10:54
文章分类

全部博文(64)

文章存档

2011年(4)

2010年(60)

我的朋友

分类: Oracle

2010-04-01 19:53:49

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. 

阅读(1299) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~