12c rac 怎樣刪除閃回日志，釋放空間

小實驗，開啟閃回和關閉閃回。

12c RAC 閃回環(huán)境
實際上就是后臺啟動了rvwr這個進程，然后自動創(chuàng)建了一個flashback目錄，然后寫入閃回日志而已。當我們臨時想清理閃回日志，只要關閉閃回就可以了，系統(tǒng)會自動delete閃回日志的。

SYS@orcl1> alter database flashback off;

Database altered.

看日志

2018-01-06 09:46:54.618000 +08:00
RVWR shutting down  --關閉進程
Deleted Oracle managed file +DATADG/ORCL/FLASHBACK/log_1.355.964691155
Deleted Oracle managed file +DATADG/ORCL/FLASHBACK/log_2.357.964691159
Flashback Database Disabled 
Completed: alter database flashback off

看asm目錄

ASMCMD [+datadg/orcl/flashback] > ls
log_1.355.964691155
log_2.357.964691159
ASMCMD [+datadg/orcl/flashback] > ls
ASMCMD-8002: entry 'flashback' does not exist in directory '+datadg/orcl/'
ASMCMD [+datadg/orcl/flashback] >

啟動閃回

SYS@orcl1> alter database flashback on;

Database altered.

SYS@orcl1> 

看日志，實際是后天進程啟動RVWR

alter database flashback on
Starting background process RVWR
RVWR started with pid=33, OS id=17582  --啟動進程
2018-01-06 09:51:26.483000 +08:00
Flashback Database Enabled at SCN 11549479
Completed: alter database flashback on

asm自動創(chuàng)建目錄

ASMCMD [+datadg/orcl/flashback] > ls -l
Type       Redund  Striped  Time             Sys  Name
FLASHBACK  UNPROT  COARSE   JAN 06 09:00:00  Y    log_1.357.964691481
FLASHBACK  UNPROT  COARSE   JAN 06 09:00:00  Y    log_2.355.964691483
ASMCMD [+datadg/orcl/flashback] >