Cloud Computing &Oracle -3

GETTING STARTED WITH CLOUD BACKUP
-----------------------------------
Sign up for Amazon S3 Service
The first step in getting started with the Oracle Secure Backup Cloud module is to
sign up for Amazon S3. This can be done by visiting the Amazon S3 website
(http://aws.amazon.com/s3). Upon successful registration, users will be
provided a pair of access identifiers called the Access Key ID and the Secret Access Key.
These access identifiers can be retrieved from the Amazon S3 web site by hovering
the mouse over the “Your Web Services Account” button on the upper right hand
side corner of the page and then clicking on the “AWS Access Identifiers” link.

Register for an Oracle.com or Oracle Technology Network (OTN) Account
--------------------------------------------------------------------------
An Oracle.com or OTN account is required to install the Oracle Secure Backup
Cloud module. New accounts may be created by visiting the OTN website
(http://otn.oracle.com) and clicking on the “Sign In/Register for Account” link at
the top of the page.

Install the Oracle Secure Backup Cloud Module
----------------------------------------------
The next step is to download the Oracle Secure Backup Cloud module install tool
from OTN, and run it to install and configure Cloud backups. The install tool is
pre-packaged with the AMIs provided by Oracle to ease Oracle software
deployment on Amazon EC2. Therefore, if the database being backed up is
running on Amazon EC2, there is no need to download the install tool – it can be
found in the /home/oracle/scripts/osbws directory.
The install tool can be invoked as follows:

$java -jar osbws_install.jar -AWSID -AWSKey
-otnUser -otnPass -walletDir -configFile -libDir
-proxyHost wwwproxy.
smallcompany.com

Oracle Secure Backup Database Web-Service Install Tool
OTN userid is valid.
AWS credentials are valid.
Creating new registration for this S3 user.
Created new log bucket.
Registration ID: 0f0a8aac-dad0-6254-7d70-be4ac4f112c4
S3 Logging Bucket: oracle-log-jane-doe-1
Create credential oracle.security.client.connect_string1

OSB web-services wallet created in directory
/orclhome/dbs/osbws_wallet.
OSB web-services initialization file /orclhome/dbs/osbwst1.ora
created.

Downloading OSB Web Services Software Library.
Downloaded 13165919 bytes in 204 seconds.
Transfer rate was 64538 bytes/second.
Download complete.
Extracted file /orclhome/lib/libosbws11.so

As can be seen from the above sample output, the install tool automatically
performs all the required steps to install and configure the Cloud backup module –
including downloading the software, creating a wallet containing the user’s AWS
identifiers, and creating the Cloud backup configuration file.
More details on how to run the install tool and the description of all of its
arguments can be found in the install tool readme document.

Configure Recovery Manager (RMAN) Settings
---------------------------------------
This optional, but highly recommended, step stores the configuration information
for the Cloud Backup module in the RMAN repository so that it does not need to
be specified each time a backup is invoked.

RMAN> configure channel device type sbt parms
'SBT_LIBRARY=/orclhome/lib/libosbws11.so
ENV=(OSB_WS_PFILE=/orclhome/dbs/osbwst1.ora)';

using target database control file instead of recovery catalog
new RMAN configuration parameters:

CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS
'SBT_LIBRARY=/orclhome/lib/libosbws11.so
ENV=(OSB_WS_PFILE=/orclhome/dbs/osbwst1.ora)';

new RMAN configuration parameters are successfully stored

Once the above step is completed, the system is fully configured for Cloud
backups. Cloud Backups can now be performed using the same RMAN commands
you usually use.

Similarly, all Cloud backup operations will be catalogued by RMAN in the same
manner as local disk or tape backups are, thereby ensuring a completely transparent
and seamless restore/recovery process. In another words, when a restore/recover
operation is initiated, RMAN and Oracle Secure Backup Cloud module will
automtically restore the required data from the Cloud - without requiring any
special user intervention.

Oracle recommends the following to optimize the
------------------------------------------------
• Use multiple RMAN channels. Prior to Oracle Database 11g, each datafile
could only be backed up by one RMAN channel. Consequently, the
effective degree of parallelism is limited by the number datafiles in the
database. Oracle Database 11g however has intra-datafile parallelism
capability that allows multiple channels to backup a single file in parallel.

• Compress your backups and use the new Oracle Database 11g Fast
Compressed Backup feature. Compared to pre-11g backup compression,
Oracle Database 11g Fast Backup Compression is significantly faster and
more efficient (in terms of CPU overhead).
• Consider making full database backups once a week and perform
incremental backups during the weekdays. This will results in faster
backups and may help save significant amount of network bandwidth. Use
the RMAN Block Change Tracking feature to optimize the performance
of your daily incremental backups.