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