Bayu Kurniawan R

Think about GIS, Linux and Oracle

You are currently browsing the archives for the day Monday, April 21st, 2008.

Export, Archiving, Delete Older file Oracle Database automaticly using Linux Script and Crontab

This is script that export Oracle Database, archive it automatically and delete archive automatically where archive older than 20 day

####################
# Oracle Backup            #
# Bayu Kurniawan R       #
# 17 April 2008             #
####################

# Buat environment
PATH=$PATH:$HOME/bin
export PATH
unset USERNAME
ORACLE_HOME=/opt/oracle/product/9ir2/
ORACLE_BASE=/opt/oracle
ORACLE_SID=orcl
export ORACLE_HOME ORACLE_BASE ORACLE_SID
PATH=$PATH:$HOME/bin:$ORACLE_HOME:$ORACLE_HOME/bin

# File naming : year.month.day
tanggal=$(date +%y%m%d)

# Path to save file
dir=/home/bayu

# Daily Backup DB Oracle
echo Exporting DB Oracle ….
su - oracle -c “exp user/password@orcl file=$dir/file_$tanggal.dmp log=$dir/file_$tanggal.log”

echo Archiving Oracle Backup…
tar -zcf $dir/file_$tanggal.tar.gz $dir/file_$tanggal.dmp $dir/file_$tanggal.log

echo Removing Oracle .dmp and .log…
rm $dir/file_$tanggal.dmp $dir/file_$tanggal.log

echo Removing Dump Oracle which older than 20 day…
find /home/bayu -name file*tar.gz -mtime +20 -exec rm -f {} \

# End #

Save it as backup.sh

Edit the Crontab
crontab -e

Add following line

0 22 * * * /opt/oracle/product/9ir2/bin/backup.sh

This script will execute backup.sh everyday at 22.00

5 comments

Google Maps API

Google Maps API menyajikan Google Maps di halaman web dengan JavaScript. API menyediakan sejumlah utility untuk memanipulasi peta (seperti pada http://maps.google.com) dan menambahkan content pada peta melalui bermacam layanan, memungkinkan untuk membuat aplikasi peta yang sempurna di website.

Gimana sih memulainya :

  1. Daftar untuk key Google Maps API.
  2. Baca Maps API Concepts.
  3. Lihat beberapa Contoh Peta.
  4. Baca Maps API Reference.

Contoh Syntaks HTML (jangan lupa ubah key dan settingan lainnya) :

<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Strict//EN”"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd”><!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Strict//EN”
“http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd”>
<html xmlns=“http://www.w3.org/1999/xhtml”>
<head>
<meta http-equiv=“Content-Type” content=“text/html; charset=iso-8859-1″ />
<title>Bayu Kurniawan R Google Maps</title>
<script src=“http://maps.google.com/maps?file=api&v=2&key=ABQIAAAAbta1OAo0jfu19DOUPNVgsBS-Yhw0H7RwDq-hPQhHch723wUepBTSSnNF-1G3nDm-wpXKKMpVQHzIdg” type=“text/javascript”></script>
<script type=“text/javascript”>

//<![CDATA[

function load() {
if (GBrowserIsCompatible()) {
var map = new GMap2(document.getElementById("map"));
map.addControl(new GLargeMapControl());
map.addControl(new GMapTypeControl());
map.setCenter(new GLatLng(-6.211551, 106.883926), 13);
map.setMapType(G_SATELLITE_MAP);
}
}

//]]>
</script>
</head>
<body onload=“load()” onunload=“GUnload()”>
<div id=“map” style=“width: 800px; height: 600px“></div></body>
</html>

Hasilnya bisa dilihat di http://map.bkurniawan.com/

1 comment