-- 5.Oracle 使用delete obsolete命令删除过期备份
/*
ORACLE正确删除归档并回收空间的方法:
一个ORACLE归档日志经常满,表现为/archivelog这个文件空间占用100%大家总是抱怨ORACLE为何没有归档维护工具,很多人直接删除了事,
错了,ORACLE有,而且很智能,可以正确的删除归档和 FLASHBACK,不过切记,ORACLE归档日志对于ORACLE的数据恢复和备份非常重要,不到万不得已不要删除归档日志。
delete expired archivelog all;
这时候我们再去OEM中就看不到这些日志文件了,如果你的从来没有做过这个动作的话,我们可以比较这个动作前的controlfile和动作后的controlfile的文件大小
*/
[oracle@MS ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Wed Feb 5 08:56:08 2025
Version 19.20.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: MS (DBID=******, not open)
RMAN>
RMAN>
RMAN>
RMAN> backup validate check logical database archivelog all;
Starting backup at 05-FEB-25
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1767 instance=MS2 device type=DISK
specification does not match any archived log in the repository
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00005 name=+DATA/MS/DATAFILE/tbs_MS.295.1152060507
input datafile file number=00002 name=+DATA/MS/DATAFILE/sysaux.284.1152058917
input datafile file number=00003 name=+DATA/MS/DATAFILE/undotbs1.285.1152058919
input datafile file number=00001 name=+DATA/MS/DATAFILE/system.283.1152058917
input datafile file number=00004 name=+DATA/MS/DATAFILE/undotbs2.287.1152058923
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
1 OK 0 17943 140800 708728851
File Name: +DATA/MS/DATAFILE/system.283.1152058917
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 82416
Index 0 16238
Other 0 24203
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
2 OK 0 38147 337920 708728811
File Name: +DATA/MS/DATAFILE/sysaux.284.1152058917
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 90361
Index 0 100806
Other 0 108606
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
3 OK 0 565 170880 643976212
File Name: +DATA/MS/DATAFILE/undotbs1.285.1152058919
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 170315
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
4 OK 0 394 108800 708728847
File Name: +DATA/MS/DATAFILE/undotbs2.287.1152058923
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 108406
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
5 OK 0 4540 3932160 708075356
File Name: +DATA/MS/DATAFILE/tbs_MS.295.1152060507
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 153162
Index 0 89
Other 0 3774369
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
List of Control File and SPFILE
===============================
File Type Status Blocks Failing Blocks Examined
------------ ------ -------------- ---------------
SPFILE OK 0 2
Control File OK 0 1284
Finished backup at 05-FEB-25
RMAN>
RMAN>
RMAN>
RMAN> list backup by file;
List of Datafile Backups
========================
File Key TY LV S Ckp SCN Ckp Time #Pieces #Copies Compressed Tag
---- ------- - -- - ---------- --------- ------- ------- ---------- ---
1 50 B F A 708728856 23-JAN-25 1 1 NO TAG20250124T091925
48 B F A 708728856 23-JAN-25 1 1 NO TAG20250123T074743
45 B F A 708716197 23-JAN-25 1 1 NO TAG20250123T023005
41 B F A 708660517 22-JAN-25 1 1 NO TAG20250122T103755
37 B F A 708640593 22-JAN-25 1 1 NO TAG20250122T023006
33 B F A 708561568 21-JAN-25 1 1 NO TAG20250121T023005
29 B F A 708519141 20-JAN-25 1 1 NO TAG20250120T160722
21 B F A 708301715 18-JAN-25 1 1 NO TAG20250118T023005
13 B F A 708163881 16-JAN-25 1 1 NO TAG20250116T103325
9 B F A 708163131 16-JAN-25 1 1 NO TAG20250116T101134
7 B F A 708163012 16-JAN-25 1 1 NO TAG20250116T100819
3 B F A 708157955 16-JAN-25 1 1 NO TAG20250116T083301
2 50 B F A 708728856 23-JAN-25 1 1 NO TAG20250124T091925
48 B F A 708728856 23-JAN-25 1 1 NO TAG20250123T074743
45 B F A 708716197 23-JAN-25 1 1 NO TAG20250123T023005
41 B F A 708660517 22-JAN-25 1 1 NO TAG20250122T103755
37 B F A 708640593 22-JAN-25 1 1 NO TAG20250122T023006
33 B F A 708561568 21-JAN-25 1 1 NO TAG20250121T023005
29 B F A 708519141 20-JAN-25 1 1 NO TAG20250120T160722
21 B F A 708301715 18-JAN-25 1 1 NO TAG20250118T023005
13 B F A 708163881 16-JAN-25 1 1 NO TAG20250116T103325
9 B F A 708163131 16-JAN-25 1 1 NO TAG20250116T101134
7 B F A 708163012 16-JAN-25 1 1 NO TAG20250116T100819
3 B F A 708157955 16-JAN-25 1 1 NO TAG20250116T083301
3 50 B F A 708728856 23-JAN-25 1 1 NO TAG20250124T091925
48 B F A 708728856 23-JAN-25 1 1 NO TAG20250123T074743
45 B F A 708716197 23-JAN-25 1 1 NO TAG20250123T023005
41 B F A 708660517 22-JAN-25 1 1 NO TAG20250122T103755
37 B F A 708640593 22-JAN-25 1 1 NO TAG20250122T023006
33 B F A 708561568 21-JAN-25 1 1 NO TAG20250121T023005
29 B F A 708519141 20-JAN-25 1 1 NO TAG20250120T160722
21 B F A 708301715 18-JAN-25 1 1 NO TAG20250118T023005
13 B F A 708163881 16-JAN-25 1 1 NO TAG20250116T103325
9 B F A 708163131 16-JAN-25 1 1 NO TAG20250116T101134
7 B F A 708163012 16-JAN-25 1 1 NO TAG20250116T100819
3 B F A 708157955 16-JAN-25 1 1 NO TAG20250116T083301
4 50 B F A 708728856 23-JAN-25 1 1 NO TAG20250124T091925
48 B F A 708728856 23-JAN-25 1 1 NO TAG20250123T074743
45 B F A 708716197 23-JAN-25 1 1 NO TAG20250123T023005
41 B F A 708660517 22-JAN-25 1 1 NO TAG20250122T103755
37 B F A 708640593 22-JAN-25 1 1 NO TAG20250122T023006
33 B F A 708561568 21-JAN-25 1 1 NO TAG20250121T023005
29 B F A 708519141 20-JAN-25 1 1 NO TAG20250120T160722
21 B F A 708301715 18-JAN-25 1 1 NO TAG20250118T023005
13 B F A 708163881 16-JAN-25 1 1 NO TAG20250116T103325
9 B F A 708163131 16-JAN-25 1 1 NO TAG20250116T101134
7 B F A 708163012 16-JAN-25 1 1 NO TAG20250116T100819
3 B F A 708157955 16-JAN-25 1 1 NO TAG20250116T083301
5 50 B F A 708728856 23-JAN-25 1 1 NO TAG20250124T091925
48 B F A 708728856 23-JAN-25 1 1 NO TAG20250123T074743
45 B F A 708716197 23-JAN-25 1 1 NO TAG20250123T023005
41 B F A 708660517 22-JAN-25 1 1 NO TAG20250122T103755
37 B F A 708640593 22-JAN-25 1 1 NO TAG20250122T023006
33 B F A 708561568 21-JAN-25 1 1 NO TAG20250121T023005
29 B F A 708519141 20-JAN-25 1 1 NO TAG20250120T160722
21 B F A 708301715 18-JAN-25 1 1 NO TAG20250118T023005
13 B F A 708163881 16-JAN-25 1 1 NO TAG20250116T103325
9 B F A 708163131 16-JAN-25 1 1 NO