delete archived redo logs not needed to flash back to a guaranteed restore point

rman: delete archived redo logs not needed to flash back to a guaranteed restore point.sql

select extract(day from (sysdate - min(trunc(time))) day to second) + 1
from v$restore_point
/
I loaded the result into an environment variable.  (Many thanks to whoever posted the code for that on this site.  Experts Exchange rocks!)

Then I used RMAN to delete the archivelogs like this:
delete archivelog all completed before 'SYSDATE - $RESTORE_POINT_AGE';


rman
connect target /
CONNECT CATALOG RMAN/RMAN@RMANMX


CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
DELETE NOPROMPT ARCHIVELOG UNTIL TIME 'SYSDATE-6';
catalog recovery area;


First two commands are optional. But it is wise to use them. With these commands