rasti.hil@hilandco.com +41 79 367-9677

Thursday, 10 June 2010

Backup your Oracle database in the Cloud

Recently I'm messing around with Amazon Web Services . So now I'll describe how to backup your database to the Cloud e.g Amazon Simple Storage Service (Amazon S3).

1) Create an Amazon S3 account. Also I want to notice that you may want to check the pricing .
2) Download the OSB Cloud Module.
3) Unzip it
[oracle@ec2 ~] unzip osbws_installer.zip
4) install
[oracle@ec2 ~] java -jar osbws_install.jar -AWSID *** -AWSKey *** -otnUser *** -otnPass *** -walletDir $ORACLE_HOME/dbs/osbws_wallet -libDir $ORACLE_HOME/lib/
Oracle Secure Backup Database Web-Service Install Tool
OTN userid is valid.
AWS credentials are valid.
S3 user already registered.
Registration ID: ***
S3 Logging Bucket: ***
Validating log bucket location ...
Validating license file ...
Create credential oracle.security.client.connect_string1OSB web-services wallet created in directory /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/osbws_wallet.OSB web-services initialization file /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/osbwsXE.ora created.
Downloading OSB Web Services Software Library.
Downloaded 13940776 bytes in 4 seconds. Transfer rate was 3485194 bytes/second.Download complete.
Extracted file /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libosbws11.so
here are detailed description of parameters
5) Configure RMAN to use OSB Cloud Module, log into to RMAN and run:
RMAN> configure channel device type SBT parms 'SBT_LIBRARY=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libosbws11.so ENV=(OSB_WS_PFILE=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/osbwsXE.ora)';
6) OK your almost done, do some encryption:
RMAN> set encryption on for all tablespaces algorithm 'AES128' identified by *** only;
7) do the backup:
RMAN> backup device type sbt tag 'janos_2010_06_10' as compressed backupset database include current controlfile;
It's done, using the OSB Cloud Module is very simply and fast forward. If disaster comes and you need to recover, the backup comes just as if it were on tape.
Here is an image how it looks like on S3:

No comments: