Oracle DB 12.1.0.2
Solaris 11.4
Hello Team,
Good morning.
I did a crosscheck backup on disk and found backups on 12 and 15 Aug 2020. RMAN retention recovery window is set to 2 days.
RMAN> crosscheck backup;
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backup/files/CC_df_DWARE1_20200812_26571_1 RECID=26173 STAMP=1048269258
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backup/files/CC_df_DWARE1_20200812_26572_1 RECID=26174 STAMP=1048269262
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backup/files/CC_df_DWARE1_20200812_26570_1 RECID=26175 STAMP=1048269255
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backup/files/CC_df_DWARE1_20200812_26569_1 RECID=26181 STAMP=1048269254
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/DWARE1/AUTOBACKUP/2020_08_12/s_1048274205.6675.1048274205 RECID=26187 STAMP=1048274205
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backup/files/CC_df_DWARE1_20200815_26917_1 RECID=26490 STAMP=1048544360
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backup/files/CC_df_DWARE1_20200815_26918_1 RECID=26491 STAMP=1048544360
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backup/files/CC_df_DWARE1_20200815_26916_1 RECID=26492 STAMP=1048544360
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backup/files/CC_df_DWARE1_20200815_26915_1 RECID=26493 STAMP=1048544360
The problem is when is execute delete obsolete backups on 12 and 15 are not deleted.
RMAN> delete obsolete device type disk;
RMAN retention policy will be applied to the command
Kindly advise.
Thanks,
Joe
RMAN retention policy is set to recovery window of 2 days
no obsolete backups found