Shell Script To Delete Old Archives Using RMAN

 Shell Script To Delete Old Archives Using RMAN

================================================

If the requirement is to delete archive log backups automatically (without taking backup), then below shell script can be configured in crontab.


prepare the shell script.


cat rman_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/rman_arch_del.sh > /tmp/rmanarch.log

Comments

Post a Comment

Popular posts from this blog

Tablespace Monitoring Shell Script

 Below script can be configured in crontab to send a notification to the support DBAs in case tablespace usage crosses a threshold. 1. First, make the below .sql file, which will be used inside the shell script. In this script we have defined the threshold as 90%. You can change it as per your requirement. cat /export/home/oracle/Housekeeping/scripts/tablespace_alert.sql       set feedback off set pagesize 70; set linesize 2000 set head on COLUMN Tablespace        format a25 heading 'Tablespace Name' COLUMN autoextensible         format a11              heading 'AutoExtend' COLUMN files_in_tablespace    format 999             heading 'Files' COLUMN total_tablespace_space format 99999999 heading 'TotalSpace' COLUMN total_used_space       format 99999999 heading 'UsedSpace' COLUMN total_tablespace_free_space format 99999999 he...
Read more

Alert Log Rotation Script In Oracle

 Alert Log Rotation Script In Oracle ==================================== Day by day, alert log size will grow in Oracle database. So for housekeeping, we need to move the existing alert log to a backup location and compress there. Upon moving the alert log, the database will create a fresh alert log automatically. Below is the shell script. WE need to define the ORACLE_HOME in the script. and ORACLE_SID will be passed as an argument while running the script. # $Header: rotatealertlog.sh # *====================================================================================+ # | AUTHOR : DBACLASS SUPPORT TEAM # | | # +====================================================================================+ # | #!/bin/bash echo ======================== echo Set Oracle Database Env echo ======================== ORACLE_SID=$1; export ORACLE_SID ORACLE_HOME=/oracle/app/oracle/product/12.1.0.2/dbhome_1 ORACLE_BASE=/oracle/app/oracle; export ORACLE_BASE LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/...
Read more

Shell script to monitor asm diskgroup usage

 Shell script to monitor asm diskgroup usage =========================================== REQUIREMENT: Write a shell script, which will trigger a mail alert, if the utilization of the asm diskgroup reached 90 percent. SOLUTION: 1. Below is the shell script. Make sure to update ORACLE_HOME, ORACLE_SID inside the shell script. cat /export/home/oracle/asm_dg.sh export ORACLE_HOME=/oracle/app/oracle/product/12.1.0.2/dbhome_1 export ORACLE_SID=PRODDB1 export PATH=$ORACLE_HOME/bin:$PATH logfile=/export/home/oracle/asm_dg.log sqlplus -s "/as sysdba" > /dev/null << EOF spool $logfile SET LINESIZE 150 SET PAGESIZE 9999 SET VERIFY off COLUMN group_name FORMAT a25 HEAD 'DISKGROUP_NAME' COLUMN state FORMAT a11 HEAD 'STATE' COLUMN type FORMAT a6 HEAD 'TYPE' COLUMN total_mb FORMAT 999,999,999 HEAD 'TOTAL SIZE(GB)' COLUMN free_mb FORMAT 999,999,999 HEAD 'FREE SIZE (GB)' COLUMN used_mb FORMAT 999,999,999 HEAD 'USED SIZE (GB)' COLUMN pct...
Read more