ANKUSH THAVALI
- 28 Sep, 2023
- 0 Comments
- 24 Secs Read
Shell 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