Copies SAP HANA

hdbsql -u SYSTEM -p <contrasenya> -I /usr/sap/NDB/HDB00/work/copies.sql

export A20174_ECOALF_PRODL."*" AS BINARY INTO '/usr/sap/NDB/HDB00/work' with replace threads 10;
export A20174_ECOALF_PRODM."*" AS BINARY INTO '/usr/sap/NDB/HDB00/work' with replace threads 10;
export A20174_FUNDACION_ECOALF_PROD."*" AS BINARY INTO '/usr/sap/NDB/HDB00/work' with replace threads 10;
export A20174_ECOALF_DE_PROD."*" AS BINARY INTO '/usr/sap/NDB/HDB00/work' with replace threads 10;

Guió

#/bin/sh
#
# Script copies HANA134 a INTAREX
#
# Autor: David Marti
# Data:  11/12/2018
#
echo "Iniciant el proces de copia …"
export PATH=$PATH:/bin:/usr/bin
/usr/sap/NDB/HDB00/hdbenv.sh
echo "Esborrant copies anteriors …"
/bin/rm -Rf /usr/sap/NDB/HDB00/work/index
/bin/rm -Rf /usr/sap/NDB/HDB00/work/export
echo "Fent les copies de seguretat …"
/usr/sap/NDB/HDB00/exe/hdbsql -n sv-ger-hana134.cloudiax.com:30015 -u SYSTEM -p contrasenya -I /usr/sap/NDB/HDB00/work/copies.sql
echo "Comprimint les copies …"
cd /usr/sap/NDB/HDB00/work
data="date '+%Y%m%d%H%M%S'"
/bin/tar -cvzf A20174_$data.tar.gz export index
echo "Fi de les copies de seguretat."