How to delete backup of control file
Hi all,
I have assigned redundancy as 1 for my RMAN backup due to space issue. But I want that the archivelogs should be deleted after two days or after getting backed up two times.
As the redundancy is set to 1, archive log deletion policy for two times will not work. I have used below script which is working fine-
run{
allocate channel ch1 type Disk maxpiecesize = 1024M;
crosscheck archivelog all;
delete noprompt archivelog until time 'SYSDATE-2';
release channel ch1;
}
But the problem is that, we are deleting the backup with 'delete noprompt backup of database' before the actual backup starts.