I need to delete applied archive logs on the standby database .. So I have searched the web and I have found a lot of ways and scripts to make it happen so I do not need a solution to this .. but while I was looking I came acorss this one
delete noprompt archivelog all completed before 'sysdate-10';
In the context of standby database what does completed means .. Does it mean the completion_time of the archivelog or it means that it is applied to the standby
I do not think that "completed " refers to the date that archivelog has been (or "could be" ) applied in dataguard .
I think that "completed" refers the date on which the rman archivelog backup has been completed (just as rman command)