首先要先定位磁盘问题,怀疑到是过期备份导致的。df -h | awk $5 >= 90||$4>=90 {print}
Filesystem Size Used Avail Use% Mounted on
1.4T 1.3T 115G 92% /d01_test2
15G 15G 373M 98% /u01_test1
12G 12G 545M 96% /u01_test2
然后切换合适的ORACLE_SID之后,我们开始RMAN操作rman target /
Configure retention policy to redundancy 1;--指保留一次备份,其余的都是过期的
--Configure retention policy to recovery window of 7 days;--指保留7天内的备份,其余的都是过期的
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 97 11-MAY- 00:25:40
Backup Piece 101 11-MAY- 00:25:40 /ora_daily2/xxx_041013211003_g3o6oo7o_3_1.rmn
Back