Amazon recently added Oracle database hosting capabilities to its RDS service
offering. You can rent an Oracle database related infrastructure in a
pay-as-you-go fashion now. We are going to explore if corporations should be
utilizing Amazon AWS Oracle Database related services (EC2, RDS ), how it
should be used, where possible savings and potential trouble points are. With
services like Amazon AWS it doesn't matter where your hardware and software
physically is - it could be in a room next to you or in some other country.
It is much easier and cheaper to procure and get new servers up and running.
What's Really New?
You swipe your credit card and get an Oracle database server up and running
in half an hour. Sounds like magic, especially if you compare it to the weeks
and months it normally takes to have an Oracle database server operational in
an average enterprise ... (more)
A recent BlackBerry outage is the nightmare for both RIM and its
users. Nature and mass popularity of Blackberry service make this
particular outage highly visible. There are many other in-house outages we
never hear about. Companies prefer to keep silent about them, if they can.
The only insight we get into the poor state of DR procedures is in some
public cases like this one, or from limited personal experience. In my Oracle
database infrastructure consulting career I have seen several serious
production outages and was part of a few data recovery efforts.
Backups and DR proc... (more)
Oracle RMAN (Recovery Manager) catalog database contains backup metadata
for all enterprise wide Oracle databases. Each database backed up through
RMAN needs connection to a central backup repository database. RMAN catalog
is purged and maintained by removing obsolete backup records, crosschecking
with existing media etc. If central repository grows too big then backup
performance will suffer since it will take too long for RMAN to locate
Amazon Web Services gives us the ability to quickly and easily create either
brand new RMAN catalog database or move an existing c... (more)
Amazon Web Services EC2 Cloud is full scale public data center offering
services that are in many aspects far ahead of ancient practices present in
regular IT environments. Fast provisioning and virtually unlimited scale make
old fashioned server procurement and installations look like what they are -
past century's practices. This article will not deal with usual objections to
cloud computing revolving around change management difficulties ( how to
incorporate new environment into the existing IT infrastructure ), security,
reliability, performance etc. since we think that all t... (more)
Sqoop makes it very easy to transfer data between Oracle and Hadoop using a
single command. The reason why we would want to import data from an Oracle
database into Hadoop/Hive is that we might want to join Hive tables with
Oracle lookup tables, or other data residing in Oracle database.
Data originating from an Oracle database can help better understand and
analyze raw, more granular data contained in Hive/HDFS.
Sqoop uses JDBC driver to connect to an Oracle database. If you have a
table results in your Oracle database and want data from it to be imported
to Hadoop HDFS ( Hadoop... (more)