2025年RMAN--obsolete 和 expired的区别

科技前沿 • 2025-02-20 22:57 • 阅读 28

大家好，我是讯享网，很高兴认识大家。

EXPIRED状态：

此状态与crosscheck命令相关，crosscheck backup 命令是对备份进行交叉检查，检查备份集是否有效。当crosscheck命令检查到某备份已经在系统层面删除的时候即物理上不存在的时候，就会将available状态置为expired状态，但这个时候并没有真正删除备份【所以删除备份不能在系统层面删除，而应该在rman中删除，使用delete backup】；

如：

RMAN> list backup tag='con_bak';
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
34 Full 9.64M DISK 00:00:02 23-OCT-14
BP Key: 34 Status: AVAILABLE Compressed: NO Tag: CON_BAK
Piece Name: /bak/control19plo5s3_1_1
Control File Included: Ckp SCN: Ckp time: 23-OCT-14

[Oracle@orclA ~]$ rm /bak/control19plo5s3_1_1
-- 将该备份从系统上删除
RMAN> crosscheck backup;
-- 交叉检查备份集是否有效
RMAN> list backup tag='con_bak';
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
34 Full 9.64M DISK 00:00:02 23-OCT-14
BP Key: 34 Status: EXPIRED Compressed: NO Tag: CON_BAK
Piece Name: /bak/control19plo5s3_1_1
Control File Included: Ckp SCN: Ckp time: 23-OCT-14

RMAN> list backup summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
34 B F X DISK 23-OCT-14 1 1 NO CON_BAK

RMAN> delete noprompt expired backup;

OBSOLETE状态：

obsolete状态是根据rman备份的保留策略来定的，当超过保留策略的备份就会被标记为obsolete状态，使用 report obsolete 命令来查看，使用delete noprompt obselete来删除备份；

讯享网

如：

RMAN> run{
2> CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
3> backup current controlfile format '/bak/con_test_%U' tag='bakcontest';
4> }

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 35 23-OCT-14
Backup Piece 35 23-OCT-14 /bak/con_test_1aplo6pd_1_1

RMAN> delete noprompt obsolete;

总结：

obsolete出现主要是由于违背备份的保留策略【废弃】而导致的，删除需用delete obsolete，而expired是在crosscheck检查备份集是否有效，主要表现在只是系统层面上删了备份，而没有删除备份信息，【失效状态】，删除需用delete expired；

2025年RMAN--obsolete 和 expired的区别

相关推荐