www.htz.pw > @recovery_file_dest.sql
"RECOVERY FILE DEST AND SIZE"
NAME QUOTA USED RECLAIMABLE FILES
------------------------------ -------------------- -------------------- -------------------- ----------
+ARCH_S1 1024M 904M 143M 15
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE number
-------------------- ------------------ ------------------------- ----------
CONTROL FILE 1.17 0 1
REDO LOG 59.38 0 8
ARCHIVED LOG 32.32 13.96 7
BACKUP PIECE 0 0 0
IMAGE COPY 0 0 0
FLASHBACK LOG 0 0 0
FOREIGN ARCHIVED LOG 0 0 0
Deleted Oracle managed file +ARCH_S1/asm11gs1/archivelog/2014_05_06/thread_1_seq_28.661.846888275
Deleted Oracle managed file +ARCH_S1/asm11gs1/archivelog/2014_05_06/thread_1_seq_27.660.846888279
Deleted Oracle managed file +ARCH_S1/asm11gs1/archivelog/2014_05_06/thread_1_seq_29.327.846888281
Deleted Oracle managed file +ARCH_S1/asm11gs1/archivelog/2014_05_06/thread_1_seq_30.671.846889485
RFS[2]: Opened log for thread 1 sequence 38 dbid 99090287 branch 841538336
Archived Log entry 146 added for thread 1 sequence 38 rlc 841538336 ID 0x5fdc3cf dest 2:
Tue May 06 23:10:40 2014
Media Recovery Log +ARCH_S1/asm11gs1/archivelog/2014_05_06/thread_1_seq_38.671.846889831
Tue May 06 23:10:44 2014
RFS[2]: Selected log 4 for thread 1 sequence 39 dbid 99090287 branch 841538336
Tue May 06 23:10:54 2014
Media Recovery Waiting for thread 1 sequence 39 (in transit)
Recovery of Online Redo Log: Thread 1 Group 4 Seq 39 Reading mem 0
Mem# 0: +DATA_S1/asm11gs1/onlinelog/group_4.267.841392453
Mem# 1: +ARCH_S1/asm11gs1/onlinelog/group_4.640.841392455
Tue May 06 23:11:08 2014
这里我们看到备库已经开始删除了,此时FRA的使用目录达到了80%,默认开始删除是从80%开始的
现在我们把db_recovery_file_dest_size增加。
www.htz.pw > alter system set db_recovery_file_dest_size=2500M;
System altered.
增加后,在alert中没有发现delete操作了。
www.htz.pw > @recovery_file_dest.sql
"RECOVERY FILE DEST AND SIZE"
NAME QUOTA USED% USED% RECLAIMABLE FILES
------------------------------ -------------------- -------------------- ------ -------------------- ----------
+ARCH_S1 2500M 1966M 79 423M 38
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE number
-------------------- ------------------ ------------------------- ----------
CONTROL FILE .48 0 1
REDO LOG 24.32 0 8
ARCHIVED LOG 53.8 16.92 29
BACKUP PIECE 0 0 0
IMAGE COPY 0 0 0
FLASHBACK LOG 0 0 0
FOREIGN ARCHIVED LOG 0 0 0
发现有删除操作
Tue May 06 23:25:32 2014
Deleted Oracle managed file +ARCH_S1/asm11gs1/archivelog/2014_05_06/thread_1_seq_35.264.846889759
直到fra区使用达到80%,开始新的删除操作