• Script permettant de propager un parametre RMAN sur tous les SID up

#!/bin/bash
############################### BANCO SANTANDER CH ##############################
#
# Script Name : rman_parameter.sh
# Author      : Mikaël DE LAGRANDRIE
# Role        : UNIX script to push RMAN parameter
# Usage       : none
#
# -------------------------------------------------------------------------------
# REVISIONS
# -------------------------------------------------------------------------------
# 1.0 => Initial version (15/04/2024)
#
################################################################################
 
 
# Checking if current user is Oracle
if [ "$USER" != "oracle" ]; then
        echo "ERROR - this script must be run under ORACLE"
    exit
fi
 
# Oracle sids
oracle_sids=( $(ps -ef | grep  oracle | grep ora_pmon  | sed 's/ora_pmon_//'| awk '{print $8}' |grep -v grep | grep -v sed) )
 
# compter membre array
oracle_sids_nmr=${#oracle_sids[@]}
 
# DG Status and FRA on SID list
for i in "${oracle_sids[@]}"
do
:
echo "#########################################"
echo "######### $i ####################"
 
ORACLE_SID=$i
export ORACLE_HOME=`grep -w ${ORACLE_SID} /etc/oratab | cut -d ":" -f 2`
 
 
echo "==== FRA ===="
rman target / <<EOF
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;
delete noprompt archivelog until time 'sysdate-1';
exit;
EOF
done