Oracle: RMAN To delete expired backupsets

RMAN> crosscheck backup completed between '22-FEB-22' and '24-FEB-22'; allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=4431 device type=DISK allocated channel: ORA_DISK_2 channel ORA_DISK_2: SID=908 device type=DISK allocated channel: ORA_DISK_3 channel ORA_DISK_3: SID=2228 device type=DISK allocated channel: ORA_DISK_4 channel ORA_DISK_4: SID=2669 device type=DISK crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/usr/opt/app/dbdump/hot_backup/fsprod/FSPROD_Inc0_T20220222_s11188_p1_1097359666.bak RECID=11175 STAMP=1097359670 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/usr/opt/app/dbdump/hot_backup/fsprod/FSPROD_Inc0_T20220222_s11187_p1_1097359666.bak RECID=11178 STAMP=1097359670 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/usr/opt/app/dbdump/hot_backup/fsprod/FSPROD_Inc0_T20220222_s11190_p1_1097359666.bak RECID=11176 STAMP=1097359668 crosschecked backup piece: found to be 'EXPIRED' [...] RMAN> delete expired backupset completed before 'SYSDATE'; using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 using channel ORA_DISK_4 List of Backup Pieces BP Key BS Key Pc# Cp# Status Device Type Piece Name ------- ------- --- --- ----------- ----------- ---------- 326612 326531 1 1 EXPIRED DISK /usr/opt/app/dbdump/hot_backup/fsprod/FSPROD_Inc0_T20220222_s11188_p1_1097359666.bak 326613 326532 1 1 EXPIRED DISK /usr/opt/app/dbdump/hot_backup/fsprod/FSPROD_Inc0_T20220222_s11190_p1_1097359666.bak 326614 326533 1 1 EXPIRED DISK /usr/opt/app/dbdump/hot_backup/fsprod/FSPROD_Inc0_T20220222_s11189_p1_1097359666.bak [...] Do you really want to delete the above objects (enter YES or NO)? yes deleted backup piece backup piece handle=/usr/opt/app/dbdump/hot_backup/fsprod/FSPROD_Inc0_T20220222_s11188_p1_1097359666.bak RECID=11175 STAMP=1097359670 deleted backup piece backup piece handle=/usr/opt/app/dbdump/hot_backup/fsprod/FSPROD_Inc0_T20220222_s11190_p1_1097359666.bak RECID=11176 STAMP=1097359668 deleted backup piece backup piece handle=/usr/opt/app/dbdump/hot_backup/fsprod/FSPROD_Inc0_T20220222_s11189_p1_1097359666.bak RECID=11177 STAMP=1097359669 deleted backup piece [...] OR RMAN> list expired backup; THEN RMAN> delete expired backup;

Comments

Post a Comment

Popular posts from this blog

Oracle: To clean up WRI$_ADV_OBJECTS

 set linesize 200; select segment_name, segment_type, bytes from dba_segments where tablespace_name='SYSAUX' order by bytes asc; COL OCCUPANT_NAME FORMAT A30 SELECT OCCUPANT_NAME,SPACE_USAGE_KBYTES FROM V$SYSAUX_OCCUPANTS ORDER BY SPACE_USAGE_KBYTES DESC; COL SEGMENT_NAME FORMAT A30 COL OWNER FORMAT A10 COL TABLESPACE_NAME FORMAT A10 COL SEGMENT_TYPE FORMAT A15 SELECT * FROM (SELECT SEGMENT_NAME,OWNER,TABLESPACE_NAME,BYTES/1024/1024 "SIZE(MB)",SEGMENT_TYPE FROM DBA_SEGMENTS WHERE TABLESPACE_NAME='SYSAUX' ORDER BY BYTES DESC) WHERE ROWNUM<=10; 1.  automatic clean-up default 31 days           SELECT dbms_stats.get_stats_history_availability from Dual; 2. modify retention policy        exec  dbms_stats.alter_stats_history_retention (14); 3. a manual cleaning  exec dbms_stats.purge_stats (sysdate-14);   ALTER TABLE WRI$_ADV_OBJECTS MOVE; ALTER INDEX WRI$_ADV_OBJECTS_IDX_01 REBUILD; ALTER INDEX WRI$_ADV_OBJECTS_IDX_02 R...
Read more