oracle数据库备份过期,RMAN 备份过期不能自动删除

最新推荐文章于 2024-04-19 22:35:18 发布

weixin_39648492

最新推荐文章于 2024-04-19 22:35:18 发布

阅读量355

点赞数

文章标签： oracle数据库备份过期

备份脚本如下： $BAK_LEVEL 是一个变量根据星期得出备份级别周天0级，周三1级其余2级

run

{

configure retention policy to recovery window of 7 days;

configure controlfile autobackup on;

allocate channel c1 type disk;

allocate channel c2 type disk;

backup incremental level= $BAK_LEVEL skip inaccessible Database

format='/u02/oradata/RMAN_BACKUP/orcl_lev"$BAK_LEVEL"_%U_%T_%s.ora' tag='orcl_lev_"$BAK_LEVEL""$WEEK_DAILY"'

plus archivelog filesperset 20 delete all input format='/u02/oradata/RMAN_BACKUP/arch_%U_%T_%s.ora' ;

backup current controlfile tag='bak_ctlfile_"$BAK_LEVEL""$WEEK_DAILY"' format='/u02/oradata/RMAN_BACKUP/ctl_file_%U_%T_%s.ora';

backup spfile tag='spfile_"$BAK_LEVEL""$WEEK_DAILY"' format='/u02/oradata/RMAN_BACKUP/ORCL_spfile_%U_%T_%s.ora';

release channel c2;

release channel c1;

}

report obsolete;

delete noprompt obsolete;

crosscheck backupset;

delete noprompt expired backup;

list backup summary;

resync catalog;

下面是备份的汇总结果: 8月份的都还在

还有一个问题就是，有一个表空间没备份：CONFIGURE EXCLUDE FOR TABLESPACE ‘XXX’

RMAN> list backup summary;

List of Backups

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

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

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

90644 B A A DISK 2012-08-27 11:13:34 1 1 NO TAG20120827T111018

90645 B A A DISK 2012-08-27 11:13:34 1 1 NO TAG20120827T111018

90646 B A A DISK 2012-08-27 11:16:51 1 1 NO TAG20120827T111018

90647 B A A DISK 2012-08-27 11:16:51 1 1 NO TAG20120827T111018

90751 B A A DISK 2012-08-27 11:30:47 1 1 NO TAG20120827T113046

90831 B A A DISK 2012-08-28 01:00:23 1 1 NO TAG20120828T010016

90832 B A A DISK 2012-08-28 01:00:23 1 1 NO TAG20120828T010016

90867 B A A DISK 2012-08-28 01:06:25 1 1 NO TAG20120828T010624

90984 B A A DISK 2012-08-29 01:00:31 1 1 NO TAG20120829T010016

90985 B A A DISK 2012-08-29 01:00:38 1 1 NO TAG20120829T010016

91026 B A A DISK 2012-08-29 01:07:11 1 1 NO TAG20120829T010711

91140 B A A DISK 2012-08-30 01:00:21 1 1 NO TAG20120830T010012

91141 B A A DISK 2012-08-30 01:00:34 1 1 NO TAG20120830T010012

91181 B A A DISK 2012-08-30 01:06:55 1 1 NO TAG20120830T010655

91292 B A A DISK 2012-08-31 01:00:31 1 1 NO TAG20120831T010014

91293 B A A DISK 2012-08-31 01:00:32 1 1 NO TAG20120831T010014

91332 B A A DISK 2012-08-31 01:06:46 1 1 NO TAG20120831T010646

91446 B A A DISK 2012-09-01 01:00:25 1 1 NO TAG20120901T010016

91447 B A A DISK 2012-09-01 01:00:38 1 1 NO TAG20120901T010016

91487 B A A DISK 2012-09-01 01:06:59 1 1 NO TAG20120901T010659

91603 B A A DISK 2012-09-02 01:00:16 1 1 NO TAG20120902T010012

91604 B A A DISK 2012-09-02 01:00:25 1 1 NO TAG20120902T010012

91605 B 0 A DISK 2012-09-02 01:06:10 1 1 NO ORCL_LEV_0SUN

91606 B 0 A DISK 2012-09-02 01:09:24 1 1 NO ORCL_LEV_0SUN

91607 B 0 A DISK 2012-09-02 01:12:33 1 1 NO ORCL_LEV_0SUN

91608 B 0 A DISK 2012-09-02 01:13:22 1 1 NO ORCL_LEV_0SUN

91609 B 0 A DISK 2012-09-02 01:16:12 1 1 NO ORCL_LEV_0SUN

91643 B A A DISK 2012-09-02 01:16:24 1 1 NO TAG20120902T011623

91680 B F A DISK 2012-09-02 01:16:31 1 1 NO TAG20120902T011631

91740 B A A DISK 2012-09-03 01:00:20 1 1 NO TAG20120903T010016

91741 B A A DISK 2012-09-03 01:00:20 1 1 NO TAG20120903T010016

91742 B 2 A DISK 2012-09-03 01:02:46 1 1 NO ORCL_LEV_2MON

91743 B 2 A DISK 2012-09-03 01:03:39 1 1 NO ORCL_LEV_2MON

91744 B 2 A DISK 2012-09-03 01:04:32 1 1 NO ORCL_LEV_2MON

91745 B 2 A DISK 2012-09-03 01:05:00 1 1 NO ORCL_LEV_2MON

91746 B 2 A DISK 2012-09-03 01:05:57 1 1 NO ORCL_LEV_2MON

91776 B A A DISK 2012-09-03 01:06:08 1 1 NO TAG20120903T010608

91791 B F A DISK 2012-09-03 01:06:11 1 1 NO BAK_CTLFILE_2MON

91815 B F A DISK 2012-09-03 01:06:16 1 1 NO TAG20120903T010615

92092 B A A DISK 2012-09-04 01:02:23 1 1 NO TAG20120904T010011

92093 B A A DISK 2012-09-04 01:02:26 1 1 NO TAG20120904T010011

92094 B A A DISK 2012-09-04 01:05:27 1 1 NO TAG20120904T010011

92095 B A A DISK 2012-09-04 01:05:37 1 1 NO TAG20120904T010011

92096 B 2 A DISK 2012-09-04 01:08:08 1 1 NO ORCL_LEV_2TUE

92097 B 2 A DISK 2012-09-04 01:09:04 1 1 NO ORCL_LEV_2TUE

92098 B 2 A DISK 2012-09-04 01:09:53 1 1 NO ORCL_LEV_2TUE

92099 B 2 A DISK 2012-09-04 01:10:27 1 1 NO ORCL_LEV_2TUE

92100 B 2 A DISK 2012-09-04 01:11:47 1 1 NO ORCL_LEV_2TUE

92201 B A A DISK 2012-09-04 01:11:59 1 1 NO TAG20120904T011159

92216 B F A DISK 2012-09-04 01:12:02 1 1 NO BAK_CTLFILE_2TUE

92228 B F A DISK 2012-09-04 01:12:04 1 1 NO SPFILE_2TUE

92240 B F A DISK 2012-09-04 01:12:06 1 1 NO TAG20120904T011206

92322 B A A DISK 2012-09-05 01:00:41 1 1 NO TAG20120905T010016

92323 B A A DISK 2012-09-05 01:00:41 1 1 NO TAG20120905T010016

92324 B 1 A DISK 2012-09-05 01:03:20 1 1 NO ORCL_LEV_1WED

92325 B 1 A DISK 2012-09-05 01:04:28 1 1 NO ORCL_LEV_1WED

92326 B 1 A DISK 2012-09-05 01:05:29 1 1 NO ORCL_LEV_1WED

92327 B 1 A DISK 2012-09-05 01:05:55 1 1 NO ORCL_LEV_1WED

92328 B 1 A DISK 2012-09-05 01:07:26 1 1 NO ORCL_LEV_1WED

92362 B A A DISK 2012-09-05 01:07:39 1 1 NO TAG20120905T010738

92377 B F A DISK 2012-09-05 01:07:42 1 1 NO BAK_CTLFILE_1WED

92389 B F A DISK 2012-09-05 01:07:44 1 1 NO SPFILE_1WED

92401 B F A DISK 2012-09-05 01:07:46 1 1 NO TAG20120905T010746

92489 B A A DISK 2012-09-06 01:00:26 1 1 NO TAG20120906T010011

92490 B A A DISK 2012-09-06 01:00:34 1 1 NO TAG20120906T010011

92491 B 2 A DISK 2012-09-06 01:03:10 1 1 NO ORCL_LEV_2THU

92492 B 2 A DISK 2012-09-06 01:04:07 1 1 NO ORCL_LEV_2THU

92493 B 2 A DISK 2012-09-06 01:04:57 1 1 NO ORCL_LEV_2THU

92494 B 2 A DISK 2012-09-06 01:05:27 1 1 NO ORCL_LEV_2THU

92495 B 2 A DISK 2012-09-06 01:06:46 1 1 NO ORCL_LEV_2THU

92531 B A A DISK 2012-09-06 01:06:53 1 1 NO TAG20120906T010652

92546 B F A DISK 2012-09-06 01:06:56 1 1 NO BAK_CTLFILE_2THU

92558 B F A DISK 2012-09-06 01:06:58 1 1 NO SPFILE_2THU

92570 B F A DISK 2012-09-06 01:07:00 1 1 NO TAG20120906T010700

92655 B A A DISK 2012-09-07 01:00:22 1 1 NO TAG20120907T010011

92656 B A A DISK 2012-09-07 01:00:34 1 1 NO TAG20120907T010011

92657 B 2 A DISK 2012-09-07 01:03:03 1 1 NO ORCL_LEV_2FRI

92658 B 2 A DISK 2012-09-07 01:03:57 1 1 NO ORCL_LEV_2FRI

92659 B 2 A DISK 2012-09-07 01:04:47 1 1 NO ORCL_LEV_2FRI

92660 B 2 A DISK 2012-09-07 01:05:20 1 1 NO ORCL_LEV_2FRI

92661 B 2 A DISK 2012-09-07 01:06:40 1 1 NO ORCL_LEV_2FRI

92696 B A A DISK 2012-09-07 01:06:44 1 1 NO TAG20120907T010643

92711 B F A DISK 2012-09-07 01:06:47 1 1 NO BAK_CTLFILE_2FRI

92723 B F A DISK 2012-09-07 01:06:49 1 1 NO SPFILE_2FRI

92735 B F A DISK 2012-09-07 01:06:52 1 1 NO TAG20120907T010651

92832 B F A DISK 2012-09-07 17:59:26 1 1 NO TAG20120907T175925

92856 B A A DISK 2012-09-08 01:00:56 1 1 NO TAG20120908T010017

92857 B A A DISK 2012-09-08 01:01:15 1 1 NO TAG20120908T010017

92858 B 2 A DISK 2012-09-08 01:03:54 1 1 NO ORCL_LEV_2SAT

92859 B 2 A DISK 2012-09-08 01:04:50 1 1 NO ORCL_LEV_2SAT

92860 B 2 A DISK 2012-09-08 01:05:40 1 1 NO ORCL_LEV_2SAT

92861 B 2 A DISK 2012-09-08 01:06:02 1 1 NO ORCL_LEV_2SAT

92862 B 2 A DISK 2012-09-08 01:07:05 1 1 NO ORCL_LEV_2SAT

92904 B A A DISK 2012-09-08 01:07:08 1 1 NO TAG20120908T010708

92919 B F A DISK 2012-09-08 01:07:11 1 1 NO BAK_CTLFILE_2SAT

92931 B F A DISK 2012-09-08 01:07:13 1 1 NO SPFILE_2SAT

92943 B F A DISK 2012-09-08 01:07:15 1 1 NO TAG20120908T010715

93025 B A A DISK 2012-09-09 01:00:28 1 1 NO TAG20120909T010012

93026 B A A DISK 2012-09-09 01:00:49 1 1 NO TAG20120909T010012

93027 B 0 A DISK 2012-09-09 01:08:16 1 1 NO ORCL_LEV_0SUN

93028 B 0 A DISK 2012-09-09 01:13:01 1 1 NO ORCL_LEV_0SUN

93029 B 0 A DISK 2012-09-09 01:13:20 1 1 NO ORCL_LEV_0SUN

93030 B 0 A DISK 2012-09-09 01:14:52 1 1 NO ORCL_LEV_0SUN

93031 B 0 A DISK 2012-09-09 01:16:41 1 1 NO ORCL_LEV_0SUN

93066 B A A DISK 2012-09-09 01:16:45 1 1 NO TAG20120909T011644

93076 B F A DISK 2012-09-09 01:16:47 1 1 NO BAK_CTLFILE_0SUN

93088 B F A DISK 2012-09-09 01:16:49 1 1 NO SPFILE_0SUN

93100 B F A DISK 2012-09-09 01:16:51 1 1 NO TAG20120909T011650

93170 B A A DISK 2012-09-10 01:00:19 1 1 NO TAG20120910T010015

93171 B A A DISK 2012-09-10 01:00:19 1 1 NO TAG20120910T010015

93172 B 2 A DISK 2012-09-10 01:02:40 1 1 NO ORCL_LEV_2MON

93173 B 2 A DISK 2012-09-10 01:03:39 1 1 NO ORCL_LEV_2MON

93174 B 2 A DISK 2012-09-10 01:04:30 1 1 NO ORCL_LEV_2MON

93175 B 2 A DISK 2012-09-10 01:04:49 1 1 NO ORCL_LEV_2MON

93176 B 2 A DISK 2012-09-10 01:05:50 1 1 NO ORCL_LEV_2MON

93206 B A A DISK 2012-09-10 01:05:58 1 1 NO TAG20120910T010558

93221 B F A DISK 2012-09-10 01:06:01 1 1 NO BAK_CTLFILE_2MON

93233 B F A DISK 2012-09-10 01:06:03 1 1 NO SPFILE_2MON

93245 B F A DISK 2012-09-10 01:06:05 1 1 NO TAG20120910T010605

93534 B F A DISK 2012-09-10 13:27:53 1 1 NO TAG20120910T132752

RMAN>

weixin_39648492

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
oracle数据库备份过期,RMAN 备份过期不能自动删除

备份脚本如下： $BAK_LEVEL 是一个变量根据星期得出备份级别周天0级，周三1级其余2级run{configure retention policy to recovery window of 7 days;configure controlfile autobackup on;allocate channel c1 type disk;allocate channel c2 ty...
复制链接

扫一扫

oracle数据库备份过期,RMAN 备份过期不能自动删除

“相关推荐”对你有帮助么？