oracle删除冗余信息,【大话IT】RAC 冗余的归档日志，如何删除？

最新推荐文章于 2021-12-30 15:51:27 发布

讲究将就

最新推荐文章于 2021-12-30 15:51:27 发布

阅读量198

点赞数

文章标签： oracle删除冗余信息

RAC2 的 /backup/archivelog 目录下的日志情况

[oracle@rac2 archivelog]$ ls -lrt

total 4550424

-rw-r----- 1 oracle asmadmin 227684864 Mar 12 22:00 2_40941_810775392.dbf

-rw-r----- 1 oracle asmadmin 73326080 Mar 12 22:02 2_40942_810775392.dbf

-rw-r----- 1 oracle asmadmin 263373824 Mar 12 22:45 2_40943_810775392.dbf

-rw-r----- 1 oracle asmadmin 260094976 Mar 13 02:57 2_40944_810775392.dbf

-rw-r----- 1 oracle asmadmin 260424192 Mar 13 04:14 2_40945_810775392.dbf

-rw-r----- 1 oracle asmadmin 262589440 Mar 13 04:28 2_40946_810775392.dbf

-rw-r----- 1 oracle asmadmin 260955648 Mar 13 04:34 2_40947_810775392.dbf

-rw-r----- 1 oracle asmadmin 267134976 Mar 13 04:42 2_40948_810775392.dbf

-rw-r----- 1 oracle asmadmin 260605440 Mar 13 04:59 2_40949_810775392.dbf

-rw-r----- 1 oracle asmadmin 260115456 Mar 13 05:35 2_40950_810775392.dbf

-rw-r----- 1 oracle asmadmin 115465216 Mar 13 07:00 2_40951_810775392.dbf

-rw-r----- 1 oracle asmadmin 25901568 Mar 13 13:00 2_40958_810775392.dbf

-rw-r----- 1 oracle asmadmin 33665536 Mar 13 13:19 2_40959_810775392.dbf

-rw-r----- 1 oracle asmadmin 119296 Mar 13 13:19 2_40960_810775392.dbf

-rw-r----- 1 oracle asmadmin 260085248 Mar 13 14:49 2_40961_810775392.dbf

-rw-r----- 1 oracle asmadmin 260286464 Mar 13 15:51 2_40962_810775392.dbf

-rw-r----- 1 oracle asmadmin 260134400 Mar 13 16:31 2_40963_810775392.dbf

-rw-r----- 1 oracle asmadmin 260710912 Mar 13 17:12 2_40964_810775392.dbf

-rw-r----- 1 oracle asmadmin 260125696 Mar 13 17:58 2_40965_810775392.dbf

-rw-r----- 1 oracle asmadmin 260333056 Mar 13 18:03 2_40966_810775392.dbf

-rw-r----- 1 oracle asmadmin 261620224 Mar 13 19:00 2_40967_810775392.dbf

-rw-r----- 1 oracle asmadmin 260137472 Mar 13 20:09 2_40968_810775392.dbf

[oracle@rac2 archivelog]$

2 归档日志的备份情况

2 40941 13230418712 2015-03-12 20:14:28 7908 A 1 1 YES TAG20150312T220014

2 40942 13231970675 2015-03-12 22:00:08 7912 A 1 1 YES TAG20150313T070015

2 40943 13232061676 2015-03-12 22:02:53 7912 A 1 1 YES TAG20150313T070015

2 40944 13232376342 2015-03-12 22:45:34 7912 A 1 1 YES TAG20150313T070015

2 40945 13233530183 2015-03-13 02:57:56 7912 A 1 1 YES TAG20150313T070015

2 40946 13234078687 2015-03-13 04:14:04 7912 A 1 1 YES TAG20150313T070015

2 40947 13234207729 2015-03-13 04:28:14 7911 A 1 1 YES TAG20150313T070015

2 40948 13234267512 2015-03-13 04:34:26 7911 A 1 1 YES TAG20150313T070015

2 40949 13234347360 2015-03-13 04:42:05 7911 A 1 1 YES TAG20150313T070015

2 40950 13234481445 2015-03-13 04:59:45 7911 A 1 1 YES TAG20150313T070015

2 40951 13234694442 2015-03-13 05:34:58 7911 A 1 1 YES TAG20150313T070015

2 40952 13235065455 2015-03-13 07:00:07 7914 A 1 1 YES TAG20150313T130038

2 40953 13235075492 2015-03-13 07:02:04 7914 A 1 1 YES TAG20150313T130038

2 40954 13235522988 2015-03-13 08:04:42 7914 A 1 1 YES TAG20150313T130038

2 40955 13240380803 2015-03-13 09:05:38 7915 A 1 1 YES TAG20150313T130038

2 40956 13245544762 2015-03-13 10:01:00 7915 A 1 1 YES TAG20150313T130038

2 40957 13255868759 2015-03-13 11:00:14 7915 A 1 1 YES TAG20150313T130038

2 40958 13267594054 2015-03-13 12:37:05 7916 A 1 1 YES TAG20150313T130038

2 40959 13267702194 2015-03-13 13:00:36 7919 A 1 1 YES TAG20150313T131903

RMAN>

3 删除已经备份过的日志，

RMAN> delete archivelog like '/backup/archivelog/%' backed up 1 times to device type disk;

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=341 instance=orcl2 device type=DISK

RMAN-08138: WARNING: archived log not deleted - must create more backups

archived log file name=/backup/archivelog/1_37915_810775392.dbf thread=1 sequence=37915

RMAN-08138: WARNING: archived log not deleted - must create more backups

archived log file name=/backup/archivelog/1_37916_810775392.dbf thread=1 sequence=37916

RMAN-08138: WARNING: archived log not deleted - must create more backups

archived log file name=/backup/archivelog/1_37917_810775392.dbf thread=1 sequence=37917

RMAN-08138: WARNING: archived log not deleted - must create more backups

archived log file name=/backup/archivelog/1_37918_810775392.dbf thread=1 sequence=37918

RMAN-08138: WARNING: archived log not deleted - must create more backups

archived log file name=/backup/archivelog/1_37919_810775392.dbf thread=1 sequence=37919

RMAN-08138: WARNING: archived log not deleted - must create more backups

archived log file name=/backup/archivelog/1_37920_810775392.dbf thread=1 sequence=37920

RMAN-08138: WARNING: archived log not deleted - must create more backups

archived log file name=/backup/archivelog/1_37921_810775392.dbf thread=1 sequence=37921

RMAN-08138: WARNING: archived log not deleted - must create more backups

archived log file name=/backup/archivelog/2_40960_810775392.dbf thread=2 sequence=40960

RMAN-08138: WARNING: archived log not deleted - must create more backups

archived log file name=/backup/archivelog/2_40961_810775392.dbf thread=2 sequence=40961

RMAN-08138: WARNING: archived log not deleted - must create more backups

archived log file name=/backup/archivelog/2_40962_810775392.dbf thread=2 sequence=40962

RMAN-08138: WARNING: archived log not deleted - must create more backups

archived log file name=/backup/archivelog/2_40963_810775392.dbf thread=2 sequence=40963

RMAN-08138: WARNING: archived log not deleted - must create more backups

archived log file name=/backup/archivelog/2_40964_810775392.dbf thread=2 sequence=40964

RMAN-08138: WARNING: archived log not deleted - must create more backups

archived log file name=/backup/archivelog/2_40965_810775392.dbf thread=2 sequence=40965

RMAN-08138: WARNING: archived log not deleted - must create more backups

archived log file name=/backup/archivelog/2_40966_810775392.dbf thread=2 sequence=40966

RMAN-08138: WARNING: archived log not deleted - must create more backups

archived log file name=/backup/archivelog/2_40967_810775392.dbf thread=2 sequence=40967

RMAN-08138: WARNING: archived log not deleted - must create more backups

archived log file name=/backup/archivelog/2_40968_810775392.dbf thread=2 sequence=40968

List of Archived Log Copies for database with db_unique_name ORCL

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

Key Thrd Seq S Low Time

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

81931 2 40958 A 2015-03-13 12:37:05

Name: /backup/archivelog/2_40958_810775392.dbf

81937 2 40959 A 2015-03-13 13:00:36

Name: /backup/archivelog/2_40959_810775392.dbf

Do you really want to delete the above objects (enter YES or NO)? NO

4 删除已经备份过的日志，

RMAN> delete noprompt archivelog like '/backup/archivelog/%' backed up 1 times to device type disk;