Wednesday, October 10, 2012

oracle s3 cloud module installation and check

DOWNLOAD LINK:
http://www.oracle.com/technetwork/products/secure-backup/secure-backup-s3-484709.html

INSTALLATION:
what you downloaded is the installer jar file
run below command as oracle user
/u01/app/oracle/database/product/11.2.0/jdk/bin/java  -jar osbws_install.jar -AWSID xxxxxxxxxxxxxxxxx  -AWSKey xxxxxxxxxxxxxxxxxxxxxxxxxxxxx  -otnUser test@yahoo.co.in  -otnPass test -walletDir /u01/app/oracle/database/product/11.2.0/dbs/osbws_wallet  -libDir /u01/app/oracle/database/product/11.2.0/lib

You must have s3 account to get AWSID and AWSKey
You must have oracle OTN account to do installation.
Java version need be 1.5 at the time of this post

JAVA VERION CHECK:
java -version

OSB LIB VERSION CHECK:
sbttest -libname /u01/app/oracle/database/product/11.2.0/lib/libosbws12.so
libosbws12.so  is the new version.
sbttest -libname /u01/app/oracle/database/product/11.2.0/lib/libosbws11.so
libosbws11.so is the old version.

E.X.
sbttest output -libname /u01/app/oracle/database/product/11.2.0/lib/libosbws12.so > output.log

CONFIGURATION FILE:
/u01/app/oracle/database/product/11.2.0/dbs/osbwsORCL.ora

RMAN COMMAND TO CALL OSB LIB:
1. restore control file
rman target /
    SET DBID=12345678
    STARTUP NOMOUNT;
    run {
    ALLOCATE CHANNEL CH1 DEVICE TYPE  SBT_TAPE parms='SBT_LIBRARY=libosbws12.so,SBT_PARMS=(OSB_WS_PFILE=/u01/app/oracle/database/product/11.2.0/dbs/osbwsORCL.ora)'  FORMAT '%d_%I_%T_%U.backup';
    RESTORE until time "to_date('15-JUL-2012 14:00:00','DD-MON-YYYY HH24:MI:SS')" CONTROLFILE FROM AUTOBACKUP ;
    RELEASE CHANNEL CH1 ;
    }

run {
    ALLOCATE CHANNEL CH1 DEVICE TYPE  SBT_TAPE parms='SBT_LIBRARY=libosbws12.so,SBT_PARMS=(OSB_WS_PFILE=/u01/app/oracle/database/product/11.2.0/dbs/osbwsORCL.ora)'  FORMAT '%d_%I_%T_%U.backup';
    RESTORE until time 'sysdate- 11' CONTROLFILE FROM AUTOBACKUP ;
    RELEASE CHANNEL CH1 ;
    }

run {
    ALLOCATE CHANNEL CH1 DEVICE TYPE  SBT_TAPE parms='SBT_LIBRARY=libosbws12.so,SBT_PARMS=(OSB_WS_PFILE=/u01/app/oracle/database/product/11.2.0/dbs/osbwsORCL.ora)'  FORMAT '%d_%I_%T_%U.backup';
    RESTORE CONTROLFILE FROM AUTOBACKUP ;
    RELEASE CHANNEL CH1 ;
    }

2. restore database
rman target /
run {
set until time "to_date('15-JUL-2012 14:00:00','DD-MON-YYYY HH24:MI:SS')";
        ALLOCATE CHANNEL CH1 DEVICE TYPE  SBT_TAPE parms='SBT_LIBRARY=libosbws12.so,SBT_PARMS=(OSB_WS_PFILE=/u01/app/oracle/database/product/11.2.0/dbs/osbwsORCL.ora)' FORMAT '%d_%I_%T_%U.backup' ;
        ALLOCATE CHANNEL CH2 DEVICE TYPE  SBT_TAPE parms='SBT_LIBRARY=libosbws12.so,SBT_PARMS=(OSB_WS_PFILE=/u01/app/oracle/database/product/11.2.0/dbs/osbwsORCL.ora)' FORMAT '%d_%I_%T_%U.backup' ;
        ALLOCATE CHANNEL CH3 DEVICE TYPE  SBT_TAPE parms='SBT_LIBRARY=libosbws12.so,SBT_PARMS=(OSB_WS_PFILE=/u01/app/oracle/database/product/11.2.0/dbs/osbwsORCL.ora)' FORMAT '%d_%I_%T_%U.backup' ;
        ALLOCATE CHANNEL CH4 DEVICE TYPE  SBT_TAPE parms='SBT_LIBRARY=libosbws12.so,SBT_PARMS=(OSB_WS_PFILE=/u01/app/oracle/database/product/11.2.0/dbs/osbwsORCL.ora)' FORMAT '%d_%I_%T_%U.backup' ;
        RESTORE DATABASE  ;
        RECOVER DATABASE ;
        RELEASE CHANNEL CH1;
        RELEASE CHANNEL CH2;
        RELEASE CHANNEL CH3;
        RELEASE CHANNEL CH4;
        }

3. simple shell script to run rman
after database is mounted.

#!/bin/sh

source /home/oracle/.bash_profile

rman target / << EOF
run {
set until time "to_date('15-JUL-2012 14:00:00','DD-MON-YYYY HH24:MI:SS')";
        ALLOCATE CHANNEL CH1 DEVICE TYPE  SBT_TAPE parms='SBT_LIBRARY=libosbws12.so,SBT_PARMS=(OSB_WS_PFILE=/u01/app/oracle/database/product/11.2.0/dbs/osbwsORCL.ora)' FORMAT '%d_%I_%T_%U.backup' ;
        ALLOCATE CHANNEL CH2 DEVICE TYPE  SBT_TAPE parms='SBT_LIBRARY=libosbws12.so,SBT_PARMS=(OSB_WS_PFILE=/u01/app/oracle/database/product/11.2.0/dbs/osbwsORCL.ora)' FORMAT '%d_%I_%T_%U.backup' ;
        ALLOCATE CHANNEL CH3 DEVICE TYPE  SBT_TAPE parms='SBT_LIBRARY=libosbws12.so,SBT_PARMS=(OSB_WS_PFILE=/u01/app/oracle/database/product/11.2.0/dbs/osbwsORCL.ora)' FORMAT '%d_%I_%T_%U.backup' ;
        ALLOCATE CHANNEL CH4 DEVICE TYPE  SBT_TAPE parms='SBT_LIBRARY=libosbws12.so,SBT_PARMS=(OSB_WS_PFILE=/u01/app/oracle/database/product/11.2.0/dbs/osbwsORCL.ora)' FORMAT '%d_%I_%T_%U.backup' ;
        RESTORE DATABASE  ;
        RECOVER DATABASE ;
        RELEASE CHANNEL CH1;
        RELEASE CHANNEL CH2;
        RELEASE CHANNEL CH3;
        RELEASE CHANNEL CH4;
        }
exit
EOF


reference:
http://www.oracle.com/technetwork/products/secure-backup/secure-backup-s3-484709.html
http://www.oracle.com/technetwork/topics/cloud/osbws-readme-083624.html
https://jira.primaticsfinancial.com/jira/login.jsp?permissionViolation=true&os_destination=%2Fbrowse%2FEMSS-5817

No comments:

Post a Comment