RMAN Sample Script

-

 EXAMPLE : 1

export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 <<Has to be change>>
export ORACLE_SID=TEST2 <<Has to be change>>
export PATH=$ORACLE_HOME/bin:$PATH
fdate=`date "+%d-%b-%Y"`
ddate=`date -d "-5 days" "+%d-%b-%Y"`
BACKUP_LOCATION=/mnt/backup/TEST2_BACKUP; <<Has to be change>>
export BACKUP_LOCATION
BACKLOGDIR=/mnt/backup/TEST2_BACKUP <<Has to be change>>
export BACKLOGDIR
LOGFILE=$BACKLOGDIR/RMAN_`date +%d%m%Y-%H%M`.log
export LOGFILE;
cd $BACKUP_LOCATION
mkdir RMAN_$fdate
echo " RMAN PROD_DATABASE backup started at `date`" >> $LOGFILE

$ORACLE_HOME/bin/rman nocatalog <<EOF | tee $LOGFILE
connect target /

run {
allocate channel d1 type disk;
allocate channel d2 type disk;
backup as compressed backupset filesperset 5 incremental level 0 database format 
'$BACKUP_LOCATION/RMAN_$fdate/%d_data_full_%s_%p_%u' plus archivelog format '$BACKUP_LOCATION/RMAN_$fdate/Arch_%d_%u';
backup current controlfile format '$BACKUP_LOCATION/RMAN_$fdate/%d_control_%s_%p_%u';
release channel d1;
release channel d2;
}
EOF


EXAMPLE : 2

export ORACLE_HOME=/IFSDBT/app/oracle/product/19.3.0/dbhome_1
export ORACLE_SID=IFSTST
export PATH=$ORACLE_HOME/bin:$PATH
fdate=`date "+%d-%b-%Y"`
ddate=`date -d "-5 days" "+%d-%b-%Y"`
BACKUP_LOCATION=/IFSDBT/RMAN/RMAN_BACKUP 
export BACKUP_LOCATION
BACKLOGDIR=/IFSDBT/RMAN/log
export BACKLOGDIR
LOGFILE=$BACKLOGDIR/RMAN_`date +%d%m%Y-%H%M`.log
export LOGFILE;
cd $BACKUP_LOCATION
mkdir RMAN_$fdate
echo " RMAN PROD_DATABASE backup started at `date`" >> $LOGFILE

$ORACLE_HOME/bin/rman nocatalog <<EOF | tee $LOGFILE
connect target /

run {
   ALLOCATE CHANNEL c1 DEVICE TYPE DISK;
    BACKUP AS COMPRESSED BACKUPSET DATABASE FORMAT '$BACKUP_LOCATION/RMAN_$fdate/full_db_%d_%T_%U.bkp';
    BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL FORMAT '$BACKUP_LOCATION/RMAN_$fdate/arch_%d_%T_%U.bkp' DELETE INPUT;
    BACKUP CURRENT CONTROLFILE FORMAT '$BACKUP_LOCATION/RMAN_$fdate/controlfile_%d_%T_%U.ctl';
    BACKUP SPFILE FORMAT '$BACKUP_LOCATION/RMAN_$fdate/spfile_%d_%T_%U.bkp';
    CROSSCHECK BACKUP;
    CROSSCHECK ARCHIVELOG ALL;
    REPORT OBSOLETE;
    DELETE NOPROMPT OBSOLETE;
    DELETE NOPROMPT ARCHIVELOG ALL BACKED UP 1 TIMES TO DEVICE TYPE DISK;
    DELETE NOPROMPT EXPIRED BACKUP;
    DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
    RELEASE CHANNEL c1;
}
EOF


EXAMPLE : 3

#!/bin/bash

# Set Oracle environment variables
ORACLE_HOME=/IFSDBT/app/oracle/product/19.3.0/dbhome_1
ORACLE_SID=IFSTST
PATH=$ORACLE_HOME/bin:$PATH
LOG_DIR=/IFSDBT/RMAN/RMAN_BACKUP/log
BACKUP_DIR=/IFSDBT/RMAN/RMAN_BACKUP
DATE=$(date +%Y%m%d_%H%M%S)

# Create backup and log directories if they don't exist
mkdir -p $BACKUP_DIR
mkdir -p $LOG_DIR

# Log file for RMAN output
LOGFILE=$LOG_DIR/full_backup_$DATE.log

# Run RMAN backup
rman target / <<EOF > $LOGFILE
RUN {
    ALLOCATE CHANNEL c1 DEVICE TYPE DISK;
    BACKUP AS COMPRESSED BACKUPSET DATABASE FORMAT '$BACKUP_DIR/full_db_%d_%T_%U.bkp';
    BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL FORMAT '$BACKUP_DIR/arch_%d_%T_%U.bkp' DELETE INPUT;
    BACKUP CURRENT CONTROLFILE FORMAT '$BACKUP_DIR/controlfile_%d_%T_%U.ctl';
    BACKUP SPFILE FORMAT '$BACKUP_DIR/spfile_%d_%T_%U.bkp';
CROSSCHECK BACKUP;
    CROSSCHECK ARCHIVELOG ALL;
    REPORT OBSOLETE;
    DELETE NOPROMPT OBSOLETE;
    DELETE NOPROMPT ARCHIVELOG ALL BACKED UP 1 TIMES TO DEVICE TYPE DISK;
    DELETE NOPROMPT EXPIRED BACKUP;
    DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
    RELEASE CHANNEL c1;
}
EOF

# Check if any errors occurred during backup
if grep -i "ORA-" $LOGFILE; then
    echo "Backup failed. Check the log file for details: $LOGFILE"
else
    echo "Backup completed successfully. Log file: $LOGFILE"
fi


Comments

Post a Comment

Popular posts from this blog

Managing Oracle Data Files – Resizing and Adding

-
In Oracle databases, proper management of data files is essential to ensure performance, availability, and scalability. This guide explains how to view , resize , and add data files using SQL*Plus, SQL Developer, TOAD, and command-line tools. 🔍 When to Resize Data Files? Resize a data file when available free space is less than 500MB . Use caution: only resize files that are not already at their maximum size (typically 32GB for most configurations). Always connect using a privileged user like SYS or SYSTEM . 🔧 Monitor via Alert Log You should always monitor changes in the alert log :           # Connect as Oracle OS user                su - oracle           # Monitor the alert log in real-time                tail -900f /u01/.../trace/alert_<SID>.log 📘 Using SQL*Plus or SQL Developer View Existing Data Files    ...
Read more

Oracle Database Basic Consepts (Start / Stop / Check Database Status)

-
🟢 Starting the Oracle Database                SQL> STARTUP; This command initiates the Oracle instance, mounts the database, and opens it for use. For environments using pluggable databases (PDBs), you may need to open them separately:                SQL>  ALTER PLUGGABLE DATABASE ALL OPEN; 🔴 Shutting Down the Oracle Database                SQL> SHUTDOWN IMMEDIATE; This command performs a clean shutdown, rolling back uncommitted transactions and disconnecting users. For emergency situations where immediate shutdown is required, you can use:                SQL> SHUTDOWN ABORT; 🔍 Checking Database Status 1. Verify Oracle Processes: On Unix/Linux:                ps -ef | grep pmon If the pmon process is running, the database instance is act...
Read more

Kubernetes Administration – Essential Commands for IFS Cloud

-
This guide covers practical Kubernetes (K8s) administration tasks including managing namespaces , pods , deployments , PVCs , and PVs . Ideal for teams working with IFS Cloud deployments on Kubernetes . 📁 Namespace Management 🔥 Delete a Namespace                kubectl delete namespace hypdev --force 🧱 Pod Operations ❌ Delete or Recreate a Pod                kubectl delete pod <pod-name> --grace-period=0 --force -n <namespace> Example:                kubectl delete pod ifsapp-reporting-86b484b7cc-zws87 --grace-period=0 --force -n hypprd 🔍 Describe a Pod                kubectl describe pod <pod-name> -n <namespace> Examples:                kubectl describe pod ifsapp-proxy-xxxxxxxx-8k4ph -n hypprd          ...
Read more