====== Oracle: Recovery Manager  ======
===== Start Recovery Manager =====

<code bash>
rman target /
</code>

===== Delete Archive Logs =====

Delete all archive logs but keep the last 45 days:

<code sql>
DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -45';
</code>

To remove archive logs older than 3 days without prompting, e.g. via cron, after backup run:

<code sql>
DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -45';
</code>

A sample script could be (deleting all logs except the last three days):

<code bash>
#!/bin/bash
 
. ${HOME}/.profile
 
rman target / << __EOF__
DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -3';
EXIT
__EOF__
</code>

{{tag>admin database dba oracle rman sysadmin}}