icon AWS Batch Starting Soon! – Register For Free Demo Session ENROLL NOW

Shell Script To Delete Old Archives Using RMAN

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • 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

Hope it Helps!

Let's Talk

Find your desired career path with us!

Let's Talk

Find your desired career path with us!