General
==================================
Example of running oracle expdp, amd scp of generated dmp file to another server.
#!/bin/bash
. /etc/profile
. /etc/sh/orash/oracle_login.sh orainst
HOST='100.100.100.30'
USER='my_user'
PASSWD='my_pass'
cd /starhome/my_user/workarea/
expdp db_user/db_pass@orainst PARFILE=exp_sparx.prm
if [ $? -ne 0 ]
then
/usr/local/etc/starhome/bin/send_snmp.sh Critical "Export dump of MLT_VODAF_SPARX failed exiting" 987989 ;
exit;
fi
expdp db_user/db_pass@orainst PARFILE=exp_metadata.prm
if [ $? -ne 0 ]
then
/usr/local/etc/starhome/bin/send_snmp.sh Critical "Export Meta data dump of MLT_VODAF_SPARX failed exiting" 987989;
exit;
fi
sudo /software/oracle/oracle/scripts/change_dmp_permissions.sh
#chmod a+r,a+w /starhome/my_user/workarea/ora_exp/dmp_a_exp.dmp
#chmod a+r,a+w /starhome/my_user/workarea/ora_exp/dmp_b_exp.dmp
scp my_user@10.100.100.58:/starhome/my_user/workarea/ora_exp/dmp_a_exp.dmp my_user@100.100.100.30:/starhome/my_user/workarea/ora_exp/
if [ $? -ne 0 ]
then
/usr/local/etc/starhome/bin/send_snmp.sh Critical "Export dump file mlt_vod_sparx_exp_metadata.dmp transfer failed exiting" 987989;
exit;
fi
scp my_user@10.100.100.58:/starhome/my_user/workarea/ora_exp/dmp_b_exp.dmp my_user@100.100.100.30:/starhome/my_user/workarea/ora_exp/
if [ $? -ne 0 ]
then
/usr/local/etc/starhome/bin/send_snmp.sh Critical "Export dump file mlt_vod_sparx_exp_data.dmp transfer failed exiting" 987989;
exit;
==================================
scp
==================================
Example scp
scp my_file remote_user@remote_server:/remote_dir