fast recovery area oracle,Fast Recovery Area空间用满后的自动清理机制

最新推荐文章于 2024-01-18 10:25:05 发布

holy-pills

最新推荐文章于 2024-01-18 10:25:05 发布

阅读量368

点赞数

文章标签： fast recovery area oracle

RMAN> report need backup;

RMAN retention policy will be applied to the command

RMAN retention policy is set to redundancy 2

Report of files with less than 2 redundant backups

File #bkps Name

---- ----- -----------------------------------------------------

RMAN> list backup of datafile 2 summary;

List of Backups

===============

Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag

------- -- -- - ----------- ----------------- ------- ------- ---------- ---

25 B F A DISK 20150506 15:11:29 1 1 NO TAG20150506T151059

27 B F A DISK 20150506 15:13:24 1 1 NO TAG20150506T151252

没过一会儿，FRA目录又撑满了，这次我们尝试将sequence 1~10的archivedlog备份到/oradata06/vlib/目录下，看看这部分空间能否腾出来

###3、测试ARCHIVELOG DELETION POLICY TO NONE的情况下FRA里的archivelog是否会被删除

backup archivelog sequence between 1 and 10 format '/oradata06/vlib/arc_%U';

Starting backup at 20150506 16:10:30

using channel ORA_DISK_1

channel ORA_DISK_1: starting archived log backup set

channel ORA_DISK_1: specifying archived log(s) in backup set

input archived log thread=1 sequence=1 RECID=38 STAMP=879000498

input archived log thread=1 sequence=2 RECID=2 STAMP=878999036

input archived log thread=1 sequence=3 RECID=57 STAMP=879002329

input archived log thread=1 sequence=4 RECID=58 STAMP=879002333

input archived log thread=1 sequence=5 RECID=59 STAMP=879002472

input archived log thread=1 sequence=6 RECID=60 STAMP=879002478

input archived log thread=1 sequence=7 RECID=61 STAMP=879002481

input archived log thread=1 sequence=8 RECID=62 STAMP=879002818

input archived log thread=1 sequence=9 RECID=63 STAMP=879002828

input archived log thread=1 sequence=10 RECID=64 STAMP=879002837

channel ORA_DISK_1: starting piece 1 at 20150506 16:10:30

channel ORA_DISK_1: finished piece 1 at 20150506 16:10:45

piece handle=/oradata06/vlib/arc_08q693nm_1_1 tag=TAG20150506T161030 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15

Finished backup at 20150506 16:10:45

---alert.log里观察到1~10的archivelog被删除了

Deleted Oracle managed file /oradata06/fra/TSTDB1/archivelog/2015_05_06/o1_mf_1_1_1jVB-byQo_.arc

Deleted Oracle managed file /oradata06/fra/TSTDB1/archivelog/2015_05_06/o1_mf_1_2_1jVB-hUR3_.arc

Deleted Oracle managed file /oradata06/fra/TSTDB1/archivelog/2015_05_06/o1_mf_1_1_1jV0O3oPw_.arc

Deleted Oracle managed file /oradata06/fra/TSTDB1/archivelog/2015_05_06/o1_mf_1_3_1jVF2uK7X_.arc

Deleted Oracle managed file /oradata06/fra/TSTDB1/archivelog/2015_05_06/o1_mf_1_4_1jVF38mNH_.arc

Deleted Oracle managed file /oradata06/fra/TSTDB1/archivelog/2015_05_06/o1_mf_1_5_1jVFBN_2Y_.arc

Deleted Oracle managed file /oradata06/fra/TSTDB1/archivelog/2015_05_06/o1_mf_1_6_1jVFBlUyY_.arc

Deleted Oracle managed file /oradata06/fra/TSTDB1/archivelog/2015_05_06/o1_mf_1_7_1jVFB_ZRX_.arc

Deleted Oracle managed file /oradata06/fra/TSTDB1/archivelog/2015_05_06/o1_mf_1_8_1jVFW46iI_.arc

Deleted Oracle managed file /oradata06/fra/TSTDB1/archivelog/2015_05_06/o1_mf_1_9_1jVFWfjwo_.arc

Deleted Oracle managed file /oradata06/fra/TSTDB1/archivelog/2015_05_06/o1_mf_1_10_1jVFXC84I_.arc

---尽管我们为archivelog配置的策略是永久不删除，但是在FRA满的时候archivelog仍然会被删除

RMAN> show ARCHIVELOG DELETION POLICY;

RMAN configuration parameters for database with db_unique_name TSTDB1 are:

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

过不久archivelog再次撑满，这次我们将archivelog的delete policy配置成至少备份两次到disk

###4、测试ARCHIVELOG DELETION POLICY TO backed up X times 的情况下FRA里的archivelog在何种条件下才会被删除

CONFIGURE ARCHIVELOG DELETION POLICY TO backed up 2 times to device type disk;

RMAN> show ARCHIVELOG DELETION POLICY;

RMAN configuration parameters for database with db_unique_name TSTDB1 are:

CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK;

---先备份一次sequence: 11~20的archivelog到/oradata06/vlib/，看这些archivelog会否直接被删除

backup archivelog sequence between 11 and 20 format '/oradata06/vlib/arc_%U';

Starting backup at 20150506 16:24:07

using channel ORA_DISK_1

channel ORA_DISK_1: starting archived log backup set

channel ORA_DISK_1: specifying archived log(s) in backup set

input archived log thread=1 sequence=11 RECID=65 STAMP=879002846

input archived log thread=1 sequence=12 RECID=66 STAMP=879002855

input archived log thread=1 sequence=13 RECID=68 STAMP=879003131

input archived log thread=1 sequence=14 RECID=67 STAMP=879003130

input archived log thread=1 sequence=15 RECID=69 STAMP=879003132

input archived log thread=1 sequence=16 RECID=70 STAMP=879003141

input archived log thread=1 sequence=17 RECID=71 STAMP=879003149

input archived log thread=1 sequence=18 RECID=72 STAMP=879003153

input archived log thread=1 sequence=19 RECID=73 STAMP=879003159

input archived log thread=1 sequence=20 RECID=74 STAMP=879003168

channel ORA_DISK_1: starting piece 1 at 20150506 16:24:08

channel ORA_DISK_1: finished piece 1 at 20150506 16:24:23

piece handle=/oradata06/vlib/arc_09q694h8_1_1 tag=TAG20150506T162408 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15

Finished backup at 20150506 16:24:23

---备份完一次后我们没有看到alert.log里11~20这些archivelog被删除的信息，再备份一次

backup archivelog sequence between 11 and 20 format '/oradata06/vlib/arc_%U';

Starting backup at 20150506 16:25:41