Hi,

I checked out the link but I'm still not sure what I need to use for my sceanrio.

Here's the output from v$rman_status

select status, start_time, end_time, operation from v$rman_status where operation='BACKUP' order by start_time;

STATUS START_TIM END_TIME OPERATION
----------------------- --------- --------- ---------------------------------
COMPLETED 16-JUN-11 16-JUN-11 BACKUP
COMPLETED 16-JUN-11 16-JUN-11 BACKUP
COMPLETED 16-JUN-11 16-JUN-11 BACKUP
COMPLETED 16-JUN-11 16-JUN-11 BACKUP
COMPLETED 17-JUN-11 17-JUN-11 BACKUP
COMPLETED 17-JUN-11 17-JUN-11 BACKUP
COMPLETED 17-JUN-11 17-JUN-11 BACKUP -- 17th is sysdate on the server today

March 12th was when the system date was changed on the server ..
so the output also has
COMPLETED 11-MAR-12 11-MAR-12 BACKUP
COMPLETED 11-MAR-12 11-MAR-12 BACKUP
COMPLETED 11-MAR-12 11-MAR-12 BACKUP
FAILED 11-MAR-12 11-MAR-12 BACKUP
COMPLETED 11-MAR-12 11-MAR-12 BACKUP
COMPLETED 12-MAR-12 12-MAR-12 BACKUP
COMPLETED 12-MAR-12 12-MAR-12 BACKUP

So, basically I need to get rid of all the entries of 2012.

Thanks again

Jay