DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Wednesday, January 10, 2018

OSB CLOUD BACKUP FOR AMAZON S3






OSB CLOUD BACKUP FOR AMAZON S3


Steps to implement OSB cloud module for Amazon S3:
============================================

Before Running the OSB Cloud Module for Amazon s3 Installer,verify the following pre-requirements.
1)The OSB Cloud Module for Amazon S3 installer requires Java 1.5 or higher to run.
2)Download the OSB Cloud Module for Amazon S3 installer (osbws_installer.zip) from OTN to the database server.
http://www.oracle.com/technetwork/products/secure-backup/secure-backup-s3-484709.html
3)Copy and unzip the OSB Cloud Module for Amazon S3 installer to /home/oracle.
4)Create a directory for the secure Oracle wallet. The Oracle wallet will be created by the installer and used to store your AWS S3 credentials.
($ORACLE_HOME/dbs/osbws_wallet)

Install Oracle Secure Backup Cloud Module for Amazon S3:
=================================================
$ mkdir -p $ORACLE_HOME/dbs/osbws_wallet

$ cd /home/oracle

unzip osbws_installer.zip



java -jar osbws_install.jar -AWSID ************* -AWSKey **************** -otnUser r*********** -otnPass ******* -walletDir $ORACLE_HOME/dbs/osbws_wallet
-libDir $ORACLE_HOME/lib


 


[-AWSID] and [-AWSKey] ====>(Mandatory)

Supply your AWS Access Key and Secret Key which serve the purpose of ID and Password to access Amazon S3. To obtain your AWS Access Key and Secret Key from the AWS website, navigate to Security Credentials, click on the Access Keys tab under Access Credentials to create or view your Access Key ID and Secret Access Key.









Please refer the screenshot.

 


 


[-otnUser] =====> (Mandatory)

Your OTN username which the installer uses to identify the customer.

[-otnPass] =====> (Mandatory)

Your OTN password.

[-walletDir] ====> (Mandatory)

Directory where you want the installer to create a secure wallet containing your AWS S3 credentials.

[-libDir] =====> (Optional)

Directory where you want the installer to download the OSB Cloud Module for Amazon S3 software library.

[-configFile]

The name of the initialization parameter file that will be created by the install tool. This parameter file will be referenced during your RMAN jobs for a particular database. If this parameter is not specified then the initialization parameter file will be created in a system-dependent default location and filename based on the ORACLE_SID. For example: $ORACLE_HOME/dbs/osbws<ORACLE_SID>.ora.
Fix Media Management Library Loading Error:
======================================


ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
Additional information: 2





The installer does not create the default media management library symbolic link for the OSB Cloud Module for Amazon S3 media management library. This results in the following RMAN error when attempting to allocate a channel of type sbt:

Manually create the following symbolic link for the default media management library before performing backups using the SBT.

$ ln -s $ORACLE_HOME/lib/libosbws12.so $ORACLE_HOME/lib/libobk.so


Modify Oracle Recovery Manager's Media Management Configuration:
==========================================================

run {
configure channel device type sbt parms="SBT_LIBRARY=/u01/app/oracle/product/11.2.0.3/db_1/lib/libosbws.so,
SBT_PARMS=(OSB_WS_PFILE=/u01/app/oracle/product/11.2.0.3/db_1/dbs/osbwsSANDBNEW.ora)";
}

 


 

Perform an Oracle Database Backup to the Cloud:
=========================================

testing the backup connection:

run
{
allocate channel ch1 type 'sbt_tape';
release channel ch1;
}

 


creating backup to flash recovery area (for testing):

RMAN> backup as compressed backupset datafile 4;


copying backup to amazon cloud(s3):


RMAN> run
{
allocate channel ch1 type 'sbt_tape';
backup recovery area;
release channel ch1;
}


 

verifying the backup information:

RMAN> list backup summary;

 




After moving oracle database backup to cloud:

the database backup has been copied from flash recovery area to cloud(S3).


 






1 comment:

Blogger said...

BlueHost is ultimately the best hosting company for any hosting services you need.