Im programming an interactive menu that verifies the exports of my oracle DB, and im having some trouble finding a process that outputs for example a green command line when the export terminated successfully. i have something like this
The cat does nothing, the cat is completely useless there and can be thrown away. It's grep that does all the work.
LINE=`grep successfully /variosnew/fullexports/IMAGES/full_imp_images.log`
if [ $? -eq 0 ]
then
printf "\033[01;32m%s\033[00m\n" "$LINE"
else
printf "\033[01;31m%s\033[00m\n" "'successfully' not found in log"
fi
Please show a sample from your logfile so I can tell how to match it more specifically. If successfully appears at the beginning of a line, you could grep "^successfully" for instance.
If I get your meaning, i.e. 'distinct' like in SQL, people often use sort -u for that, but I suspect there are dates and the like which make the entries differ from each other even when you'd like them to be combined. Things like cut and/or awk can trim it down to the parts you want, after which you can sort -u to remove the duplicates. Depending on the problem, sometimes people do it all in one awk, noting down the things to keep in an associative array until the program ends, when they're all printed without duplicates. The output from this tends to be in unpredictable and arbitrary order however.
i really don want to remove duplicates, cause there aint no duplicates... my problem now is that whenever the export terminate successfully or unsuccesfully it recognizes it like a successfull command and it displays the messages in green. I tried
In general this seems like a good way to detect success here, since there's only one way for it to be successful -- anything other than 'terminated successfully' will be considered an error. As long as you know there isn't going to be more than one thing in the file, this should work.
If there could be a successful run followed by a failed one, it will find the successful run and print success falsely.
Yes, but why would it be printing that? :wall: If you don't mean 'distinct' in the SQL sense, what do you mean it in? What's distinct, about what?
You're going to have to show the input you have, the output you want, and the logic which explains why one causes the other if you want to be understood without playing a game of 20-questions.
Ok, i need that i.e. the export did not was execute successfully displays any other message of warning. Why? because it has to be reported to the dba's or system admins for a fast solution since the export could fail for more than one reason. If the export terminated successfully i need to print the message "export terminated successfully".. with that i have no problem... now, the thing is, when i mean "distinct", its an example, i mean different to successfull, because i found out today that the grep command finds the successfull and the unsuccessfull line equals.. thats why i need to print a different message when it goes unsuccesfull. But with the grep for 'Terminated successfully' i believe i have my alternative. Thats my way of see it. Then again this is part of my input and output:
if [ $? -eq 0 ]
then
printf "\033[01;32m%s\033[00m\n" "$LINE2"
else
printf "\033[01;31m%s\033[00m\n" "And error was found, please contact your dba or sysadm"
fi
ls -trl /variosnew/fullexports/IMAGES/;
sleep 5
;;
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:
#!/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 e[31m El Export $DMP, no Existe , Revisar el Servidor Local y Comuniquese con el Administrador de Base de Datos .....e[37m
sleep 2
fi
if [ $X1 = 1 ]
then
echo e[31m El Export $LOG, no Existe , Revisar el Servidor Local y Comuniquese con el Administrador de Base de Datos .....e[37m
sleep 2
fi
if [ $X1 = 2 ]
then
echo e[31m El Export 111 , no Existe archivos de Respaldos del $FECHA , Revisar el Servidor Local y Comuniquese con el Administrador de Base de Datos .....e[37m
sleep 2
fi
}
# ==================================================================================================================
valida_servicio()
{
if [ $XR1 != 0 ]
then
echo e[31m El Respaldo de $DB Ha Fallado, Revisar el archivo log en $DIR$LOG y Comuniquese con el Administrador de Base de Datos ...e[37m
TEMX=`cat $DIR$LOG | grep "successfully"`
echo e[31m $TEMX e[37m
else
echo
echo e[32m Respaldo de $DB Finalizo Correctamente........ e[37m
echo e[32m $TEM e[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 e[35m EXPORT DE BASE DE DATOS DE TOKENS .....e[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
## ========================================================