flashback error: Unable to allocate flashback log
Recovery Writer (RVWR) is stuck until more space
is available in the recovery area.
Unable to write Flashback database log data because the
recovery area is full, presence of a guaranteed
restore point and no reusable flashback logs.
1. 查看闪回日志目录
|
1 |
show parameter recover |
2. 查看闪回目录的使用状态
|
1 |
select * from v$flash_recovery_area_usage; |
3.扩大闪回大小
|
1 |
alter system set db_recovery_file_dest_size =200G; |
4.闪回日志保留时间
|
1 |
show parameter retention |
5.查看还原点信息
|
1 |
SELECT NAME,TO_CHAR(TIME,'YYYY/MM/DD HH24:MI:SS'),GUARANTEE_FLASHBACK_DATABASE FROM V$RESTORE_POINT; |
删除还原点：
|
1 |
DROP RESTORE POINT RESTORE_POINT_1; |
6.查看并关闭闪回
|
1 2 |
select flashback_on from v$database; alter database flashback off; |
分类: oracle