06-01-2012
Hi... Sorry to reply until now... the info you gave me helped me to make my script work, but in the end i totally change it using the first one as example the final script is this one:
Code :
#!/bin/sh
####################################################
# Declaracion de Variables de Entorno #
####################################################
export local=/home/local/
# export svr20=alertas_ficocel
# export svr21=eventos1
# rojo echo ^[[31mhola^[[37m
# verde echo ^[[32mhola^[[37m
export FECHA=$(date +"%h %d")
#export FECHA=$(date +%B %d)
#export FECHA=$(date +%h %d)
export RESULTADO_OK=without warnings
export RESULTADO_OKDP="completed at"
#export RESULTADO_OKDP="successfully completed at"
export formato_fecha=`(date +%Y%m%d)`
####################################################
# Defeinicion de Procedimientos torno #
####################################################
# ==================================================================================================================
valida_export()
{
if [ $X1 = 0 ]
then
echo [31m El Export $DMP, no Existe , Revisar el Servidor Local y Comuniquese con el Administrador de Base de Datos .....[37m
sleep 2
fi
if [ $X1 = 1 ]
then
echo [31m El Export $LOG, no Existe , Revisar el Servidor Local y Comuniquese con el Administrador de Base de Datos .....[37m
sleep 2
fi
if [ $X1 = 2 ]
then
echo [31m El Export 111 , no Existe archivos de Respaldos del $FECHA , Revisar el Servidor Local y Comuniquese con el Administrador de Base de Datos .....[37m
sleep 2
fi
}
# ==================================================================================================================
valida_servicio()
{
if [ $XR1 != 0 ]
then
echo [31m El Respaldo de $DB Ha Fallado, Revisar el archivo log en $DIR$LOG y Comuniquese con el Administrador de Base de Datos ...[37m
TEMX=`cat $DIR$LOG | grep "successfully"`
echo [31m $TEMX [37m
else
echo
echo [32m Respaldo de $DB Finalizo Correctamente........ [37m
echo [32m $TEM [37m
fi
}
# =====================================================================================================================
valida_archivos()
{
if [ -f $DIR$DMP ]
then
if [ -f $DIR$LOG ]
then
if [ $tipo = 0 ]
then
#TEM=`cat $DIR$LOG | grep "$RESULTADO_OK"`
SD=`ls -trl $DIR | grep "$FECHA" | wc -l`
if [ $SD != 0 ]
then
XR1=0
echo
ls -trl $DIR | grep "$FECHA"
TEM=`cat $DIR$LOG | grep "$RESULTADO_OK"`
if [ $? = 0 ]
then
XR1=0
valida_servicio
echo
echo ==============================================================================
else
XR1=1
valida_servicio
echo
echo ==============================================================================
fi
else
X1=2
echo
valida_export
echo
echo ==============================================================================
fi
else
#TEM=`cat $DIR$LOG | grep "$RESULTADO_OKDP"`
SD=`ls -trl $DIR | grep "$FECHA" | wc -l`
if [ $SD != 0 ]
then
XR1=0
echo
ls -trl $DIR | grep "$FECHA"
TEM=`cat $DIR$LOG | grep "$RESULTADO_OKDP"`
if [ $? = 0 ]
then
XR1=0
valida_servicio
echo
echo ==============================================================================
else
XR1=1
valida_servicio
echo
echo ==============================================================================
fi
else
X1=1
echo
ls -trl $DIR | grep "$FECHA"
# valida_servicio
valida_export
echo
echo ==============================================================================
fi
fi
else
X1=1
valida_export
echo ==============================================================================
fi
else
X1=0
valida_export
fi
}
# ================================================================================================================
valida_archivos1()
{
if [ -f $DIR$DMP1 ]
then
if [ -f $DIR$DMP2 ]
then
if [ -f $DIR$DMP3 ]
then
if [ -f $DIR$DMP4 ]
then
if [ -f $DIR$LOG ]
then
if [ $tipo = 0 ]
then
#TEM=`cat $DIR$LOG | grep "$RESULTADO_OK"`
SD=`ls -trl $DIR | grep "$FECHA" | wc -l`
if [ $SD != 0 ]
then
XR1=0
echo
ls -trl $DIR | grep "$FECHA"
TEM=`cat $DIR$LOG | grep "$RESULTADO_OK"`
if [ $? = 0 ]
then
XR1=0
valida_servicio
echo
echo ==============================================================================
else
XR1=1
valida_servicio
echo
echo ==============================================================================
fi
else
X1=2
echo
valida_export
echo
echo ==============================================================================
fi
else
#
SD=`ls -trl $DIR | grep "$FECHA" | wc -l`
if [ $SD != 0 ]
then
XR1=0
echo
XR1=0
echo
ls -trl $DIR | grep "$FECHA"
TEM=`cat $DIR$LOG | grep "$RESULTADO_OKDP"`
if [ $? = 0 ]
then
XR1=0
valida_servicio
echo
echo ==============================================================================
else
XR1=1
valida_servicio
echo
echo ==============================================================================
fi
else
X1=2
echo
valida_export
echo
echo ==============================================================================
fi
fi
else
X1=1
ls -trl $DIR | grep "$FECHA"
valida_export
fi
else
X1=0
valida_export
fi
else
X1=0
# valida_export
fi
X1=0
# valida_export
else
X1=0
# valida_export
fi
X1=0
# valida_export
else
X1=0
# valida_export
fi
}
# ==================================================================================================================
valida_archivos2()
{
if [ -f $DIR$DMP1 ]
then
if [ -f $DIR$LOG1 ]
then
if [ $tipo = 0 ]
then
SD=`ls -trl $DIR | grep "$FECHA" | wc -l`
if [ $SD != 0 ]
then
XR1=0
echo
ls -trl $DIR$DMP1
ls -trl $DIR$LOG1
TEM1=`cat $DIR$LOG1 | grep $RESULTADO_OK`
if [ $? = 0 ]
then
DB=$LOG1
XR1=0
TEM=$TEM1
valida_servicio
else
DB=$LOG1
LOG=$LOG1
XR1=1
valida_servicio
fi
else
X1=2
echo
valida_export
echo
#echo ==============================================================================
fi
else
SD=`ls -trl $DIR | grep "$FECHA" | wc -l`
if [ $SD != 0 ]
then
XR1=0
echo
ls -trl $DIR$DMP1
ls -trl $DIR$LOG1
TEM1=`cat $DIR$LOG1 | grep "$RESULTADO_OKDP"`
if [ $? = 0 ]
then
DB=$LOG1
LOG=$LOG1
XR1=0
TEM=$TEM1
valida_servicio
else
DB=$LOG1
LOG=$LOG1
XR1=1
valida_servicio
fi
else
DB=$LOG1
LOG=$LOG1
X1= 2
echo
valida_export
echo
#echo ==============================================================================
fi
fi
else
X1=1
ls -trl $DIR | grep "$FECHA"
LOG=$LOG1
valida_export
fi
else
DMP=$DMP1
X1=0
valida_export
fi
if [ -f $DIR$DMP2 ]
then
if [ -f $DIR$LOG2 ]
then
# ls -trl $DIR | grep "$FECHA"
if [ $tipo = 0 ]
then
SD=`ls -trl $DIR | grep "$FECHA" | wc -l`
if [ $SD != 0 ]
then
XR1=0
echo
ls -trl $DIR$DMP2
ls -trl $DIR$LOG2
TEM2=`cat $DIR$LOG2 | grep "$RESULTADO_OK"`
if [ $? = 0 ]
then
DB=$LOG2
XR1=0
TEM=$TEM2
valida_servicio
else
DB=$LOG2
LOG=$LOG2
XR1=1
valida_servicio
fi
else
X1=2
echo
valida_export
echo
#echo ==============================================================================
fi
else
SD=`ls -trl $DIR | grep "$FECHA" | wc -l`
if [ $SD != 0 ]
then
XR1=0
echo
ls -trl $DIR$DMP2
ls -trl $DIR$LOG2
TEM2=`cat $DIR$LOG1 | grep "$RESULTADO_OKDP"`
if [ $? = 0 ]
then
DB=$LOG2
XR1=0
TEM=$TEM2
valida_servicio
echo
echo ==============================================================================
else
DB=$LOG2
LOG=$LOG2
XR1=1
valida_servicio
echo
echo ==============================================================================
fi
else
X1=2
echo
valida_export
echo
echo ==============================================================================
fi
fi
else
X1=1
ls -trl $DIR | grep "$FECHA"
LOG=$LOG2
valida_export
fi
else
DMP=$DMP2
X1=0
valida_export
fi
}
# ================================================================================================================
valida_archivos3()
{
if [ -f $DIR$DMP1 ]
then
if [ -f $DIR$LOG1 ]
then
if [ $tipo = 0 ]
then
SD=`ls -trl $DIR | grep "$FECHA" | wc -l`
if [ $SD != 0 ]
then
XR1=0
echo
ls -trl $DIR$DMP1
ls -trl $DIR$LOG1
TEM1=`cat $DIR$LOG1 | grep $RESULTADO_OK`
if [ $? = 0 ]
then
DB=$LOG1
XR1=0
TEM=$TEM1
valida_servicio
else
XR1=1
valida_servicio
fi
else
X1= 2
echo
valida_export
echo
#echo ==============================================================================
fi
else
SD=`ls -trl $DIR | grep "$FECHA" | wc -l`
if [ $SD != 0 ]
then
XR1= 0
echo
ls -trl $DIR$DMP1
ls -trl $DIR$LOG1
TEM2=`cat $DIR$LOG1 | grep $RESULTADO_OKDP`
if [ $? = 0 ]
then
DB=$LOG1
XR1=0
TEM=$TEM1
valida_servicio
else
XR1=1
valida_servicio
fi
else
X1= 2
echo
valida_export
echo
#echo ==============================================================================
fi
fi
else
X1=1
ls -trl $DIR | grep "$FECHA"
LOG=$LOG1
valida_export
fi
else
DMP=$DMP1
X1=0
valida_export
fi
if [ -f $DIR$DMP2 ]
then
if [ -f $DIR$LOG2 ]
then
# ls -trl $DIR | grep "$FECHA"
if [ $tipo = 0 ]
then
SD=`ls -trl $DIR | grep "$FECHA" | wc -l`
if [ $SD != 0 ]
then
XR1=0
echo
ls -trl $DIR$DMP2
ls -trl $DIR$LOG2
TEM2=`cat $DIR$LOG2 | grep $RESULTADO_OK`
if [ $? = 0 ]
then
DB=$LOG2
XR1=0
TEM=$TEM2
valida_servicio
else
XR1=1
valida_servicio
fi
else
X1=2
echo
valida_export
echo
#echo ==============================================================================
fi
else
SD=`ls -trl $DIR | grep "$FECHA" | wc -l`
if [ $SD != 0 ]
then
XR1=0
echo
ls -trl $DIR$DMP2
ls -trl $DIR$LOG2
TEM2=`cat $DIR$LOG1 | grep $RESULTADO_OKDP`
if [ $? = 0 ]
then
DB=$LOG2
XR1=0
TEM=$TEM2
valida_servicio
else
XR1=1
valida_servicio
fi
else
X1= 2
echo
valida_export
echo
#echo ==============================================================================
fi
fi
else
X1=1
ls -trl $DIR | grep "$FECHA"
LOG=$LOG1
valida_export
fi
else
DMP=$DMP2
X1=0
valida_export
fi
if [ -f $DIR$DMP3 ]
then
if [ -f $DIR$LOG3 ]
then
#ls -trl $DIR | grep "$FECHA"
if [ $tipo = 0 ]
then
SD=`ls -trl $DIR | grep "$FECHA" | wc -l`
if [ $SD != 0 ]
then
XR1=0
echo
ls -trl $DIR$DMP3
ls -trl $DIR$LOG3
TEM3=`cat $DIR$LOG3 | grep $RESULTADO_OK`
if [ $? = 0 ]
then
DB=$LOG3
XR1=0
TEM=$TEM3
valida_servicio
echo
echo ==============================================================================
else
XR1=1
valida_servicio
echo
echo ==============================================================================
fi
else
X1=2
echo
valida_export
echo
echo ==============================================================================
fi
else
SD=`ls -trl $DIR | grep "$FECHA" | wc -l`
if [ $SD != 0 ]
then
XR1=0
echo
ls -trl $DIR$DMP3
ls -trl $DIR$LOG3
TEM3=`cat $DIR$LOG3 | grep $RESULTADO_OKDP`
if [ $? = 0 ]
then
DB=$LOG3
XR1=0
TEM=$TEM3
valida_servicio
else
XR1=1
valida_servicio
echo
echo ==============================================================================
fi
else
X1=2
echo
valida_export
echo
echo ==============================================================================
fi
fi
else
X1=1
ls -trl $DIR | grep "$FECHA"
LOG=$LOG3
valida_export
fi
else
DMP=$DMP3
X1=0
valida_export
fi
}
# ====================================================================================================================
valida_archivos4()
{
if [ -f $DIR$DMP1 ]
then
if [ -f $DIR$LOG1 ]
then
if [ $tipo = 0 ]
then
SD=`ls -trl $DIR | grep "$FECHA" | wc -l`
if [ $SD != 0 ]
then
XR1=0
echo
ls -trl $DIR$DMP1
ls -trl $DIR$LOG1
TEM1=`cat $DIR$LOG1 | grep $RESULTADO_OK`
if [ $? = 0 ]
then
DB=$LOG1
XR1=0
TEM=$TEM1
valida_servicio
else
DB=$LOG1
LOG=$LOG1
XR1=1
valida_servicio
fi
else
X1= 2
echo
valida_export
echo
#echo ==============================================================================
fi
else
SD=`ls -trl $DIR | grep "$FECHA" | wc -l`
if [ $SD != 0 ]
then
XR1= 0
echo
ls -trl $DIR$DMP1
ls -trl $DIR$LOG1
TEM2=`cat $DIR$LOG1 | grep $RESULTADO_OKDP`
if [ $? = 0 ]
then
DB=$LOG1
XR1=0
TEM=$TEM1
valida_servicio
else
XR1=1
valida_servicio
fi
else
X1= 2
echo
valida_export
echo
#echo ==============================================================================
fi
fi
else
X1=1
ls -trl $DIR | grep "$FECHA"
LOG=$LOG1
valida_export
fi
else
DMP=$DMP1
X1=0
valida_export
fi
if [ -f $DIR$DMP2 ]
then
if [ -f $DIR$LOG2 ]
then
# ls -trl $DIR | grep "$FECHA"
if [ $tipo = 0 ]
then
SD=`ls -trl $DIR | grep "$FECHA" | wc -l`
if [ $SD != 0 ]
then
XR1=0
echo
ls -trl $DIR$DMP2
ls -trl $DIR$LOG2
TEM2=`cat $DIR$LOG2 | grep $RESULTADO_OK`
if [ $? = 0 ]
then
DB=$LOG2
XR1=0
TEM=$TEM2
valida_servicio
else
LOG=$LOG2
DB=$LOG2
XR1=1
valida_servicio
fi
else
X1=2
echo
valida_export
echo
#echo ==============================================================================
fi
else
SD=`ls -trl $DIR | grep "$FECHA" | wc -l`
if [ $SD != 0 ]
then
XR1=0
echo
ls -trl $DIR$DMP2
ls -trl $DIR$LOG2
TEM2=`cat $DIR$LOG1 | grep $RESULTADO_OKDP`
if [ $? = 0 ]
then
DB=$LOG2
XR1=0
TEM=$TEM2
valida_servicio
else
XR1=1
valida_servicio
fi
else
X1= 2
echo
valida_export
echo
#echo ==============================================================================
fi
fi
else
X1=1
ls -trl $DIR | grep "$FECHA"
LOG=$LOG1
valida_export
fi
else
DMP=$DMP2
X1=0
valida_export
fi
if [ -f $DIR$DMP3 ]
then
if [ -f $DIR$LOG3 ]
then
#ls -trl $DIR | grep "$FECHA"
if [ $tipo = 0 ]
then
SD=`ls -trl $DIR | grep "$FECHA" | wc -l`
if [ $SD != 0 ]
then
XR1=0
echo
ls -trl $DIR$DMP3
ls -trl $DIR$LOG3
TEM3=`cat $DIR$LOG3 | grep $RESULTADO_OK`
if [ $? = 0 ]
then
LOG=$LOG3
DB=$LOG3
XR1=0
TEM=$TEM3
valida_servicio
echo
# echo ==============================================================================
else
DB=$LOG3
XR1=1
valida_servicio
echo
# echo ==============================================================================
fi
else
X1=2
echo
valida_export
echo
# echo ==============================================================================
fi
else
SD=`ls -trl $DIR | grep "$FECHA" | wc -l`
if [ $SD != 0 ]
then
XR1=0
echo
ls -trl $DIR$DMP3
ls -trl $DIR$LOG3
TEM3=`cat $DIR$LOG3 | grep $RESULTADO_OKDP`
if [ $? = 0 ]
then
DB=$LOG3
XR1=0
TEM=$TEM3
valida_servicio
else
XR1=1
valida_servicio
echo
# echo ==============================================================================
fi
else
X1=2
echo
valida_export
echo
# echo ==============================================================================
fi
fi
else
X1=1
ls -trl $DIR | grep "$FECHA"
LOG=$LOG3
valida_export
fi
else
DMP=$DMP3
X1=0
valida_export
fi
if [ -f $DIR$DMP4 ]
then
if [ -f $DIR$LOG4 ]
then
#ls -trl $DIR | grep "$FECHA"
if [ $tipo = 0 ]
then
SD=`ls -trl $DIR | grep "$FECHA" | wc -l`
if [ $SD != 0 ]
then
XR1=0
echo
ls -trl $DIR$DMP4
ls -trl $DIR$LOG4
TEM4=`cat $DIR$LOG4 | grep $RESULTADO_OK`
if [ $? = 0 ]
then
DB=$LOG4
LOG=$LOG4
XR1=0
TEM=$TEM4
valida_servicio
echo
echo ==============================================================================
else
DB=$LOG4
XR1=1
valida_servicio
echo
echo ==============================================================================
fi
else
X1=2
echo
valida_export
echo
echo ==============================================================================
fi
else
SD=`ls -trl $DIR | grep "$FECHA" | wc -l`
if [ $SD != 0 ]
then
XR1=0
echo
ls -trl $DIR$DMP4
ls -trl $DIR$LOG4
TEM4=`cat $DIR$LOG4 | grep $RESULTADO_OKDP`
if [ $? = 0 ]
then
DB=$LOG4
XR1=0
TEM=$TEM4
valida_servicio
else
XR1=1
valida_servicio
echo
echo ==============================================================================
fi
else
X1=2
echo
valida_export
echo
echo ==============================================================================
fi
fi
else
X1=1
ls -trl $DIR | grep "$FECHA"
LOG=$LOG4
valida_export
fi
else
DMP=$DMP4
X1=0
valida_export
fi
}
# ====================================================================================================================
# ====================================================================================================================
# ====================================================================================================================
clear
banner $FECHA
#banner $(date +"%B %d")
sleep 1
echo ==============================================================================
echo
echo EXPORT DE BASE DE DATOS DE TOKENS -- Servisdor Windows 172.23.6.49 - Svr-tokens
#echo [35m EXPORT DE BASE DE DATOS DE TOKENS .....[35m
DB=TOKENS
DMP=FULL_EXP_tokens.dmp
LOG=full_exp_tokens.log
DIR=/variosnew/fullexports/TOKENS/
tipo=0
valida_archivos
sleep 1
## ========================================================
echo
echo EXPORT DE BASE DE DATOS DE DICORP -- Servidor AIX 192.9.200.115 -- fico630p
echo
DB=GRP
DMP=FULLGRP817.dmp
LOG=exp_fullgrp817.log
DIR=/variosnew/fullexports/GRP/
tipo=0
valida_archivos
sleep 1
## ========================================================
echo
echo EXPORT DE BASE DE DATOS DE LOGIS -- Servidor AIX 192.9.200.115 -- fico630p
DB=LOGIS8
DMP=FULL_LOGIS8I.dmp
LOG=FULL_LOGIS8I.log
DIR=/variosnew/fullexports/LOGIS8I/
tipo=0
valida_archivos
sleep 1
## ========================================================
echo
echo EXPORT DE BASE DE DATOS DE DOCUNETINTESA -- Servisdor Windows 172.23.6.123 - Intesa-docunet
echo
DB=DOCUNETINTESA
DMP=FULLEXP_Intesadocu.DMP
LOG=fullexp_intesadocu.log
DIR=/variosnew/fullexports/DOCUNETINTESA/
tipo=0
valida_archivos
sleep 2
## ========================================================
echo
echo EXPORT DE BASE DE DATOS DE CONTABILIDAD -- Servidor AIX 192.9.200.115 -- fico630p
echo
DB=CONTAB
DMP=FULL_CONTAB.dmp
LOG=FULL_CONTAB.log
DIR=/variosnew/fullexports/CONTAB/
tipo=0
valida_archivos
sleep 2
## ========================================================
echo
echo EXPORT DE BASE DE DATOS DE INTERPRETADOR
echo
DB=INTERPRETADOR
DMP=INTERP.DP
LOG=interp.log
DIR=/variosnew/fullexports/INTERP/
tipo=1
valida_archivos
sleep 2
## ========================================================
echo
echo EXPORT DE BASE DE DATOS DE FEXPRESS -- Servidor AIX 192.9.200.115 -- fico630p
echo
DB=FEXPRESS
DMP=FULL_FEXPRESS.dmp
LOG=full_fexpress.log
DIR=/variosnew/fullexports/FEXPRESS/
tipo=0
valida_archivos
sleep 2
## ========================================================
echo
echo EXPORT DE BASE DE DATOS DE DBREMESA -- Servidor AIX 192.9.200.115 -- fico630p
echo
DB=DBREMESA
DMP=FULL_DBREMESA.dmp
LOG=FULL_DBREMESA.log
DIR=/variosnew/fullexports/DBREMESA/
tipo=0
valida_archivos
sleep 2
## ========================================================
echo
echo EXPORT DE BASE DE DATOS DE DOCUNET
echo
DB=DOCUNET
DMP=FULL_EXP_DOCUNET.DMP
LOG=full_exp_docunet.log
DIR=/variosnew/fullexports/DOCUNET/
tipo=0
valida_archivos
sleep 2
## ========================================================
echo
echo EXPORT DE BASE DE DATOS DE FICOPEN
echo
DB=FICOPEN
DMP=FULL_FICOPEN.DMP
LOG=full_ficopen.log
DIR=/variosnew/fullexports/FICOPEN/
tipo=1
valida_archivos
sleep 2
## ========================================================
echo
echo EXPORT DE BASE DE DATOS DE SIGI
echo
DB="SIGI PSI"
DMP=FULLEXP_SIGI10G.DMP
LOG=fullexp_sigi10g.log
DIR=/variosnew/fullexports/SIGI/
tipo=0
valida_archivos
sleep 2
## ========================================================
echo
echo EXPORT DE BASE DE DATOS DE INTERBANCA -- Servidor AIX 192.9.200.92 --
echo
DB="INTERBANCA HONDURAS"
DMP=fullVIRT9i.dmp.Z
LOG=exp_FULLVIRT9i.log
DIR=/variosnew/fullexports/INTERBANCA/
tipo=0
valida_archivos
sleep 2
## ========================================================
echo
echo EXPORT DE BASE DE DATOS DE IMAGENES
echo
DB="IMAGENES HONDURAS"
DMP=FULLEXP_IMAGENES.DMP
LOG=full_imp_imagenes.log
DIR=/variosnew/fullexports/IMAGENES/
tipo=0
valida_archivos
sleep 2
## ========================================================
echo
echo EXPORT DE BASE DE DATOS DE KIOSKOS
echo
DB=KIOSKOS
DMP=fulldp_soadb.dmp.gz
LOG=fullexpdp_soadb.log
DIR=/variosnew/fullexports/KIOSKOS/
tipo=1
valida_archivos
sleep 2
## ========================================================
echo
echo EXPORT DE BASE DE DATOS DE ANSWER
echo
DB=ANSWERIT
DMP=full_answerit.dmp
LOG=exp_fullanswerit.log
DIR=/variosnew/fullexports/ANSWER/
tipo=0
valida_archivos
sleep 2
## ========================================================
echo
echo EXPORT DE BASE DE DATOS DE HOLDING
echo
DB=HOLDING
DMP=FULL_HOLDING.dmp
LOG=full_HOLDING.log
DIR=/variosnew/fullexports/HOLDING/
tipo=0
valida_archivos
sleep 2
## ========================================================
echo
echo EXPORT DE BASE DE DATOS DE FLINKP
echo
DB=FLINKP
DMP=FLINKP.DP
LOG=flinkp.log
DIR=/variosnew/fullexports/FLINKP/
tipo=1
valida_archivos
sleep 2
## ========================================================
echo
echo EXPORT DE BASE DE DATOS DE INTERBANCA PANAMA
echo
DB=INTERBANCAPANAMA
DMP=fullVIRT9i_pa.dmp.Z
LOG=exp_FULLVIRT9i_pa.log
DIR=/variosnew/fullexports/INTERBANCAPANAMA/
tipo=0
valida_archivos
sleep 2
## ========================================================
echo
echo EXPORT DE BASE DE DATOS ABANKS PANAMA
echo
DB=ABANKSPA
DMP=abankspa_$formato_fecha.dmp.Z
LOG=abankspa_$formato_fecha.log
DIR=/variosnew/fullexports/ABANKSPA/
tipo=0
valida_archivos
sleep 2
echo
echo EXPORT DE BASE DE DATOS ABANKS GUATEMALA
echo
DB=ABANKSG
DMP=abanksgt_$formato_fecha.dmp.Z
LOG=abanksgt_$formato_fecha.log
DIR=/variosnew/fullexports/ABANKSGT/
tipo=0
valida_archivos
sleep 2
## ========================================================
echo
echo EXPORT DE BASE DE DATOS BANRED24
echo
DB=BANRED24
DMP=full_switch_$formato_fecha.dmp.Z
LOG=full_switch_$formato_fecha.log
DIR=/variosnew/fullexports/BANRED24/
tipo=1
valida_archivos
sleep 2
## ========================================================
echo
echo EXPORT DE BASE DE DATOS DE FICOHSA SEGUROS
echo
DB=INTESA
DMP=intesa_$formato_fecha.dmp.Z
LOG=intesa_$formato_fecha.log
DIR=/variosnew/fullexports/INTESA/
tipo=1
valida_archivos
sleep 2
## ========================================================
echo
echo EXPORT DE BASE DE DATOS DE ABANKS HONDURAS
echo
DB=ORAB817
DMP=FULLORAB817_$formato_fecha.dmp
LOG=fullexp_ORAB817_$formato_fecha.log
DIR=/variosnew/fullexports/FULL_COMPLETO/
tipo=0
valida_archivos
sleep 2
## ========================================================
echo
echo EXPORT DE BASE DE DATOS DE PAGOSWS
echo
DB=PAGOSWS
DMP=pagoswsd.dmp.Z
LOG=pagoswsd.log
DIR=/variosnew/fullexports/PAGOSWS/
tipo=1
valida_archivos
sleep 2
## ========================================================
echo
echo EXPORT DE BASE DE DATOS DE BPA
echo
DB=BPA
DB1=GFFBPA.log
DB2=GFFBPBPA.log
DMP1=GFFBPA.DP
DMP2=GFFBPBPA.DP
LOG1=GFFBPA.log
LOG2=GFFBPBPA.log
DIR=/variosnew/fullexports/BPA/
tipo=1
valida_archivos2
sleep 2
## ========================================================
echo
echo EXPORT DE BASE DE DATOS DE AHIBA
echo
DB=AHIBA
DB1=fullexp_ahiba_nr
DB2=fullexp_ahiba
DB3=exp_ahiba_par
DMP1=FULL_AHIBA_NR.dmp
DMP2=FULL_AHIBA.dmp
DMP3=EXP_AHIBA_PAR.dmp
LOG1=fullexp_ahiba_nr.log
LOG2=fullexp_ahiba.log
LOG3=exp_ahiba_par.log
DIR=/variosnew/fullexports/AHIBA/
tipo=0
valida_archivos3
sleep 2
## ========================================================
echo
echo EXPORT DE BASE DE DATOS DE WORKFLOW
echo
DB=WORKFLOW
DMP1=fullexp_WORKFLOW01.dmp
DMP2=fullexp_WORKFLOW02.dmp
DMP3=fullexp_WORKFLOW03.dmp
DMP4=fullexp_WORKFLOW04.dmp
LOG=fullexp_WORKFLOW.log
DIR=/variosnew/fullexports/WORKFLOW/
tipo=1
valida_archivos1
sleep 2
## ========================================================
echo
echo EXPORT DE BASE DE DATOS DE WFBPEL
echo
DB=WFBPEL
DMP1=fullexp_WFBPEL01.dmp
DMP2=fullexp_WFBPEL02.dmp
DMP3=fullexp_WFBPEL03.dmp
DMP4=fullexp_WFBPEL04.dmp
LOG=fullexp_WFBPEL.log
DIR=/variosnew/fullexports/WFBPEL/
tipo=1
valida_archivos1
sleep 2
## ========================================================
echo
echo EXPORT DE BASE DE DATOS DE HISTORICO
echo
DB=HIST817
DB1=hist_2012_ORA_BANK.log
DB2=hist_2012_VARIOS.log
DB3=hist_2012_VASA.log
DB4=hist_full_export.log
DMP1=hist_2012_ORA_BANK.dmp
DMP2=hist_2012_VARIOS.dmp
DMP3=hist_2012_VASA.dmp
DMP4=hist_full_export.dmp
LOG1=hist_2012_ORA_BANK.log
LOG2=hist_2012_VARIOS.log
LOG3=hist_2012_VASA.log
LOG4=hist_full_export.log
DIR=/variosnew/fullexports/HIST817/
tipo=0
valida_archivos4
sleep 2
## ========================================================
Thank you for everything!
8 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Everyone,
How to assign the specific value which return from database?
here is the return value from database -->
(return status = 0)
0 <----- this
I only need to get the "0" .. assign to another declare variable.
hope someone will help me..
Please
thank you.. (4 Replies)
Discussion started by: ryanW
4 Replies
2. Shell Programming and Scripting
Ok, I sort of need to create a command files that will be ftped to another server to run.
I have some input variable that will need to be read, and then transformed into another script file. Here are some examples.
Server 1:
outputCmd.sh
passing in ./outputCmd.sh nh8oaxt Release_4_0... (1 Reply)
Discussion started by: orozcom
1 Replies
3. UNIX for Dummies Questions & Answers
Ok so all i'm trying to do here is output a file and change the color of a specific word. I can't use grep with color because I need all lines of the file not just lines that match the pattern.
I can get this substitution to work but when it displays it shows exactly what i'm putting it rather... (14 Replies)
Discussion started by: MrEddy
14 Replies
4. Shell Programming and Scripting
hi friends,
The code:
i=1
while
do
filename=`/usr/bin/ls -l| awk '{ print $9}'`
echo $filename>>summary.csv
#Gives the name of the file stored at column 9
count=`wc -l $filename | awk '{print $1}'`
echo $count>>summary.csv
#Gives just the count of lines of file "filename"
i=`expr... (1 Reply)
Discussion started by: rajsharma
1 Replies
5. Shell Programming and Scripting
With this script i want to print the output to a specific field-number . Can anybody help?
awk 'NR=FNR{split(FILENAME,fn,"_");nr=$2;f = $1} END{for (i=1;i<=f;i++) print i,$fn=nr}' input_5.csv input_6.csvinput_5.csv
4 135
5 185
6 85
11 30input_6.csv
1 90
3 58
4 135
7 60
8 55
10... (1 Reply)
Discussion started by: sdf
1 Replies
6. Shell Programming and Scripting
(5 Replies)
Discussion started by: radioactive9
5 Replies
7. Solaris
Hi, was after some help for the following. I want to enforce local passwd authentication for service accounts and kerberos authentication for users.
Solaris 11 lets me assign different PAM modules to specific users via usermod and linux lets me define via UID, but I can't find a way to do this... (0 Replies)
Discussion started by: melias
0 Replies
8. Shell Programming and Scripting
I have been reading old posts and trying to come up with a solution for the below: Use a tab-delimited input file to assign
point to variables that are used to update a specific field, Rank. I really couldn't find too much in the way of assigning points
to variable, but made an attempt at an awk... (4 Replies)
Discussion started by: cmccabe
4 Replies