Kiran Dalvi28 Sep, 20230 Comments24 Secs ReadShell Script To Delete Old Archives Using RMAN Prepare the shell script. cat arch_del.sh #!/bin/bash export ORACLE_HOME=/oracle/app/oracle/product/12.1.0.2.0 export ORACLE_SID=PARIS12C export PATH=$ORACLE_HOME/bin:$PATH delBackup () { rman log=/home/oracle/arch_del.log << EOF connect target / DELETE noprompt ARCHIVELOG ALL COMPLETED BEFORE ‘sysdate-1’; CROSSCHECK ARCHIVELOG ALL; DELETE EXPIRED ARCHIVELOG ALL; exit EOF } # Main delBackup Now configure in crontab: 00 22 * * * /u01/app/oracle/arch_del.sh > /tmp/rmanarch.log Hope it Helps! Oracle DBAShare: How to Monitor Standby DatabaseShell Script To Monitor Lag In Standby Datbase Using Dgmgrl