Este script serve como script padrão para gerar "backup" tipo export (datadump), do ORACLE.
É só escrever vi script_backup.sh
chmod +x script_backup.sh
Lembrando que temos que criar o usuário o diretório e dar grant do usuário no diretório
cd /home/oracle
source .bash_profile
DIA=`date +'%w'`
clear
cont=0
if [ $DIA -eq 0 ]; then
clear
echo "."
echo "."
echo " *********************************************** "
echo " *** *** "
echo " *** REALIZANDO BACKUP DE Domingo *** "
echo " *** *** "
echo " *** <<SEU_BANCO>>. *** "
echo " *** *** "
echo " *********************************************** "
echo " *** GERANDO BACKUP *** "
expdp <<USUARIO_BANCO>>/<<SENHA_USUARIO>>@<<SEU_BANCO>> full=Y directory=<<DIRETORIO_CRIADO_NO_ORACLE>> dumpfile=<<SEU_BANCO>>_DOMINGO.dmp logfile=<<SEU_BANCO>>_DOMINGO.log
echo " *** ZIPANDO ENVIANDO E LIBERANDO ESPACO *** "
zip /var/backup/LOG_DOMINGO.zip /u01/app/oracle/admin/<<SEU_BANCO>>/dpdump/<<SEU_BANCO>>_DOMINGO.log
rm /u01/app/oracle/admin/<<SEU_BANCO>>/dpdump/<<SEU_BANCO>>_DOMINGO.log
zip /var/backup/DMP_DOMINGO.zip /u01/app/oracle/admin/<<SEU_BANCO>>/dpdump/<<SEU_BANCO>>_DOMINGO.dmp
rm /u01/app/oracle/admin/<<SEU_BANCO>>/dpdump/<<SEU_BANCO>>_DOMINGO.dmp
echo " *** DELETANDO PROXIMO DIA LIBERANDO ESPACO *** "
rm /var/backup/LOG_SEGUNDA.zip
rm /var/backup/DMP_SEGUNDA.zip
echo "."
echo " *********************************************** "
echo " *** *** "
echo " *** MANUTENCAO SEMANAL TODOS OS DOMINGOS *** "
echo " *** *** "
echo " *********************************************** "
exit
fi
if [ $DIA -eq 1 ]; then
clear
echo "."
echo "."
echo " *********************************************** "
echo " *** *** "
echo " *** REALIZANDO BACKUP DE segunda *** "
echo " *** SERVIDOR *** "
echo " *** *** "
echo " *** <<SEU_BANCO>>. *** "
echo " *** *** "
echo " *********************************************** "
echo "."
echo "."
echo " *** GERANDO BACKUP *** "
expdp <<USUARIO_BANCO>>/<<SENHA_USUARIO>>@<<SEU_BANCO>> full=Y directory=<<DIRETORIO_CRIADO_NO_ORACLE>> dumpfile=<<SEU_BANCO>>_SEGUNDA.dmp logfile=<<SEU_BANCO>>_SEGUNDA.log
echo " *** ZIPANDO ENVIANDO E LIBERANDO ESPACO *** "
zip /var/backup/LOG_SEGUNDA.zip /u01/app/oracle/admin/<<SEU_BANCO>>/dpdump/<<SEU_BANCO>>_SEGUNDA.log
rm /u01/app/oracle/admin/<<SEU_BANCO>>/dpdump/<<SEU_BANCO>>_SEGUNDA.log
zip /var/backup/DMP_SEGUNDA.zip /u01/app/oracle/admin/<<SEU_BANCO>>/dpdump/<<SEU_BANCO>>_SEGUNDA.dmp
rm /u01/app/oracle/admin/<<SEU_BANCO>>/dpdump/<<SEU_BANCO>>_SEGUNDA.dmp
echo " *** DELETANDO PROXIMO DIA LIBERANDO ESPACO *** "
rm /var/backup/LOG_TERCA.zip
rm /var/backup/DMP_TERCA.zip
exit
fi
if [ $DIA -eq 2 ]; then
clear
echo "."
echo "."
echo " *********************************************** "
echo " *** *** "
echo " *** REALIZANDO BACKUP DE Terca *** "
echo " *** SERVIDOR *** "
echo " *** *** "
echo " *** <<SEU_BANCO>>. *** "
echo " *** *** "
echo " *********************************************** "
echo "."
echo "."
echo " *** GERANDO BACKUP *** "
expdp <<USUARIO_BANCO>>/<<SENHA_USUARIO>>@<<SEU_BANCO>> full=Y directory=<<DIRETORIO_CRIADO_NO_ORACLE>> dumpfile=<<SEU_BANCO>>_TERCA.dmp logfile=<<SEU_BANCO>>_TERCA.log
echo " *** ZIPANDO ENVIANDO E LIBERANDO ESPACO *** "
zip /var/backup/LOG_TERCA.zip /u01/app/oracle/admin/<<SEU_BANCO>>/dpdump/<<SEU_BANCO>>_TERCA.log
rm /u01/app/oracle/admin/<<SEU_BANCO>>/dpdump/<<SEU_BANCO>>_TERCA.log
zip /var/backup/DMP_TERCA.zip /u01/app/oracle/admin/<<SEU_BANCO>>/dpdump/<<SEU_BANCO>>_TERCA.dmp
rm /u01/app/oracle/admin/<<SEU_BANCO>>/dpdump/<<SEU_BANCO>>_TERCA.dmp
echo " *** DELETANDO PROXIMO DIA LIBERANDO ESPACO *** "
rm /var/backup/LOG_QUARTA.zip
rm /var/backup/DMP_QUARTA.zip
exit
fi
if [ $DIA -eq 3 ]; then
clear
echo "."
echo "."
echo " *********************************************** "
echo " *** *** "
echo " *** REALIZANDO BACKUP DE Quarta *** "
echo " *** SERVIDOR *** "
echo " *** *** "
echo " *** <<SEU_BANCO>>. *** "
echo " *** *** "
echo " *********************************************** "
echo "."
echo "."
echo " *** GERANDO BACKUP *** "
expdp <<USUARIO_BANCO>>/<<SENHA_USUARIO>>@<<SEU_BANCO>> full=Y directory=<<DIRETORIO_CRIADO_NO_ORACLE>> dumpfile=<<SEU_BANCO>>_QUARTA.dmp logfile=<<SEU_BANCO>>_QUARTA.log
echo " *** ZIPANDO ENVIANDO E LIBERANDO ESPACO *** "
zip /var/backup/LOG_QUARTA.zip /u01/app/oracle/admin/<<SEU_BANCO>>/dpdump/<<SEU_BANCO>>_QUARTA.log
rm /u01/app/oracle/admin/<<SEU_BANCO>>/dpdump/<<SEU_BANCO>>_QUARTA.log
zip /var/backup/DMP_QUARTA.zip /u01/app/oracle/admin/<<SEU_BANCO>>/dpdump/<<SEU_BANCO>>_QUARTA.dmp
rm /u01/app/oracle/admin/<<SEU_BANCO>>/dpdump/<<SEU_BANCO>>_QUARTA.dmp
echo " *** DELETANDO PROXIMO DIA LIBERANDO ESPACO *** "
rm /var/backup/LOG_QUINTA.zip
rm /var/backup/DMP_QUINTA.zip
exit
fi
if [ $DIA -eq 4 ]; then
clear
echo "."
echo "."
echo " *********************************************** "
echo " *** *** "
echo " *** REALIZANDO BACKUP DE Quinta *** "
echo " *** SERVIDOR *** "
echo " *** *** "
echo " *** <<SEU_BANCO>>. *** "
echo " *** *** "
echo " *********************************************** "
echo "."
echo "."
echo " *** GERANDO BACKUP *** "
expdp <<USUARIO_BANCO>>/<<SENHA_USUARIO>>@<<SEU_BANCO>> full=Y directory=<<DIRETORIO_CRIADO_NO_ORACLE>> dumpfile=<<SEU_BANCO>>_QUINTA.dmp logfile=<<SEU_BANCO>>_QUINTA.log
echo " *** ZIPANDO ENVIANDO E LIBERANDO ESPACO *** "
zip /var/backup/LOG_QUINTA.zip /u01/app/oracle/admin/<<SEU_BANCO>>/dpdump/<<SEU_BANCO>>_QUINTA.log
rm /u01/app/oracle/admin/<<SEU_BANCO>>/dpdump/<<SEU_BANCO>>_QUINTA.log
zip /var/backup/DMP_QUINTA.zip /u01/app/oracle/admin/<<SEU_BANCO>>/dpdump/<<SEU_BANCO>>_QUINTA.dmp
rm /u01/app/oracle/admin/<<SEU_BANCO>>/dpdump/<<SEU_BANCO>>_QUINTA.dmp
echo " *** DELETANDO PROXIMO DIA LIBERANDO ESPACO *** "
rm /var/backup/LOG_SEXTA.zip
rm /var/backup/DMP_SEXTA.zip
exit
fi
if [ $DIA -eq 5 ]; then
clear
echo "."
echo "."
echo " *********************************************** "
echo " *** *** "
echo " *** REALIZANDO BACKUP DE Sexta *** "
echo " *** SERVIDOR *** "
echo " *** *** "
echo " *** <<SEU_BANCO>>. *** "
echo " *** *** "
echo " *********************************************** "
echo "."
echo "."
echo " *** GERANDO BACKUP *** "
expdp <<USUARIO_BANCO>>/<<SENHA_USUARIO>>@<<SEU_BANCO>> full=Y directory=<<DIRETORIO_CRIADO_NO_ORACLE>> dumpfile=<<SEU_BANCO>>_SEXTA.dmp logfile=<<SEU_BANCO>>_SEXTA.log
echo " *** ZIPANDO ENVIANDO E LIBERANDO ESPACO *** "
zip /var/backup/LOG_SEXTA.zip /u01/app/oracle/admin/<<SEU_BANCO>>/dpdump/<<SEU_BANCO>>_SEXTA.log
rm /u01/app/oracle/admin/<<SEU_BANCO>>/dpdump/<<SEU_BANCO>>_SEXTA.log
zip /var/backup/DMP_SEXTA.zip /u01/app/oracle/admin/<<SEU_BANCO>>/dpdump/<<SEU_BANCO>>_SEXTA.dmp
rm /u01/app/oracle/admin/<<SEU_BANCO>>/dpdump/<<SEU_BANCO>>_SEXTA.dmp
echo " *** DELETANDO PROXIMO DIA LIBERANDO ESPACO *** "
rm /var/backup/LOG_SABADO.zip
rm /var/backup/DMP_SABADO.zip
exit
fi
if [ $DIA -eq 6 ]; then
clear
echo "."
echo "."
echo " *********************************************** "
echo " *** *** "
echo " *** REALIZANDO BACKUP DE Sabado *** "
echo " *** SERVIDOR *** "
echo " *** *** "
echo " *** <<SEU_BANCO>>. *** "
echo " *** *** "
echo " *********************************************** "
echo "."
echo "."
echo " *** GERANDO BACKUP *** "
expdp <<USUARIO_BANCO>>/<<SENHA_USUARIO>>@<<SEU_BANCO>> full=Y directory=<<DIRETORIO_CRIADO_NO_ORACLE>> dumpfile=<<SEU_BANCO>>_SABADO.dmp logfile=<<SEU_BANCO>>_SABADO.log
echo " *** ZIPANDO ENVIANDO E LIBERANDO ESPACO *** "
zip /var/backup/LOG_SABADO.zip /u01/app/oracle/admin/<<SEU_BANCO>>/dpdump/<<SEU_BANCO>>_SABADO.log
rm /u01/app/oracle/admin/<<SEU_BANCO>>/dpdump/<<SEU_BANCO>>_SABADO.log
zip /var/backup/DMP_SABADO.zip /u01/app/oracle/admin/<<SEU_BANCO>>/dpdump/<<SEU_BANCO>>_SABADO.dmp
rm /u01/app/oracle/admin/<<SEU_BANCO>>/dpdump/<<SEU_BANCO>>_SABADO.dmp
echo " *** DELETANDO PROXIMO DIA LIBERANDO ESPACO *** "
rm /var/backup/LOG_DOMINGO.zip
rm /var/backup/DMP_DOMINGO.zip
exit
fi