The first attempt to back up an Oracle database to the AWS Cloud was typically backed up to a tape library or disk, and now it's easier to have a cloud. This is primarily backed up using AWS's S3 storage as an SBT device. As for what is AWS, what is S3, please refer to: http://www.amazonaws.cn/products/specific steps are as follows:
Prerequisites: You will have an AWS Accunt (AWS access key ID and AWS secret key) and you will need to have Oracle's OTN account and password
1, install CentOS 6.6 64-bit operating system (the specific process slightly)
2. Install Java 1.8 JDK (specific process)
3. Install Oracle 11G Database (Specific process)
4, download the OSB module, can go to http://download.oracle.com/otn/other/osbws_installer.zip find
5, decompression Osbws_installer.zip
[Email protected] ~]$ Unziposbws_installer.zip
. [Email protected] ~]$ Java-jarosbws_install.jar
Oracle Secure Backup Web Service installtool, build 2015-06-22
No arguments supplied
Usage:java-jar Osbws_install.jar
-awsid:aws Access Key ID
-awskey:aws Secret Access Key
-otnuser:otn Username
-walletdir:directory to store Wallet
-configfile:file name of config File
-libdir:directory to store Library
-libplatform:platform of library to download
-location:location to store backups
-proxyhost:http Proxy Host
-proxyport:http Proxy Port
-proxyid:http proxy userid, if needed
-proxypass:http proxy password, if needed
-newlogbucket:force creation of new log buckets
-reregister:force User Registration
When you see the output similar to the above, the downloaded Osbws_install is correct.
6. Edit a script file called: osbws.sh, then enter the following:
Java-jar Osbws_install.jar-awsid xxxxxxxxx \
-awskey//xxxxxxxxx \
-otnuser [email protected] \
-otnpass xxxx \
-walletdir$oracle_home/dbs/osbws_wallet \
-libdir $ORACLE _home/lib/
Explanation:-awsid is an access key ID for AWS For example: ABCDK234DDK39JDL
-awskey is the Secrect key for the acess key ID
-otnuser and-otnpass are your Oracle account password
7. Enter the following command:
[Email protected] ~]$ Mkdir$oracle_home/dbs/osbws_wallet
[Email protected] ~]$ chmod +x osbws.sh
[[email protected] ~]# ntpdate stdtime.gov.hk #切换root用户进行ntp网络时间同步, no sync will error
8, the line osbws.sh
[Email protected] ~]$./osbws.sh
Oracle Secure Backup Web Service Install Tool, build 2015-06-22
AWS credentials is valid.
Re-creating Logbucket
Created new log bucket.
Registration ID:0A43C1D0-2E98-43E2-ACA6-E4B532B408B4
S3 Logging bucket:oracle-log-test-abcx-1
Validating Log Bucket location ...
Validating license File ...
Oracle Secure Backup Web Service Wallet created in Directory/usr/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/osbws_ Wallet.
Oracle Secure Backup Web Service initialization File/usr/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/osbwsorcl.ora Created.
Downloading Oracle Secure Backup Web Service software Library from File Osbws_linux64.zip.
Downloaded 27151475 bytes in 2062 seconds. Transfer rate was 13167 bytes/second.
Download complete.
View $oracle_home/lib Directory
LS $ORACLE _home/lib/*osb*
Output such as:
/usr/oracle/app/oracle/product/11.2.0/dbhome_1/lib/libosbws11.so/usr/oracle/app/oracle/product/11.2.0/dbhome_1 /lib/libosbws.so
The AWS driver has been successfully installed.
Now to test the table space backup and restore operations, I first create a tablespace and a test user, and create a test table under that user. Then back up to AWS with OSB. The process is as follows:
A. CREATE TABLE spaces:
sql> Create Tablespace Up2s3
2 Logging
3 datafile '/usr/oracle/app/oracle/oradata/orcl/up2s3_01.dbf ' SIZE 5M
4 autoextend on;
Tablespace created.
2. Create user
Sql> create user tests3 identified by test;
User created.
Sql>grant Connect,resource to Tests3;
Grant succeeded.
sql> alter user tests3 default Tablespace up2s3;
User altered.
Sql> Conn Tests3/test;
Connected.
Sql> CREATE TABLE Test (ID varchar (20));
Table created.
sql> INSERT into Test (ID) VALUES (' abc ');
1 row created.
Sql> select * from test;
Id
--------------------
Abc
B. Use Rman to back up the up2s3 table space to the cloud and enter it in Rman:
Rman> Run {
2> Allocate channel DEV1 type
3> SBT parms= ' sbt_library=/usr/oracle/app/oracle/product/11.2.0/dbhome_1/lib/libosbws11.so,
4> sbt_parms= (Osb_ws_pfile=/usr/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/osbwsorcl.ora) ';
5> backup tablespace up2s3;
6>}
Output:
Allocated CHANNEL:DEV1
Channel DEV1:SID=32 Device Type=sbt_tape
Channel dev1:oracle Secure Backup Web Services Library
Starting backup at 21-jul-15
Channel dev1:starting full DataFile backup set
Channel dev1:specifying DataFile (s) in backup set
Input datafile file number=00005 name=/usr/oracle/app/oracle/oradata/orcl/up2s3_01.dbf
Channel dev1:starting piece 1 at 21-jul-15
Channel dev1:finished piece 1 at 21-jul-15
Piece handle=01qck3eb_1_1 tag=tag20150721t155035 comment=api version 2.0,mms version 2.0.0.0
Channel Dev1:backup set complete, elapsed time:00:00:25
Finished backup at 21-jul-15
Released Channel:dev1
Now you can try to see your just backup using the list backupset in Rman.
C, delete the Up2s3 table space, simulate the table space damage.
sql> alter tablespace UP2S3 offline;
Tablespace altered.
[email protected] ~]$ Su-
Password:
[Email protected] ~]# mv/usr/oracle/app/oracle/oradata/orcl/up2s3_01.dbf/root/
sql> alter tablespace UP2S3 online;
Alter Tablespace UP2S3 Online
*
ERROR at line 1:
Ora-01157:cannot identify/lock data file 5-see DBWR trace file
Ora-01110:data file 5: '/USR/ORACLE/APP/ORACLE/ORADATA/ORCL/UP2S3_01.DBF '
D, now to recover the Up2s3 table space via Rman
Rman> Run {
2> Allocate channel DEV1 type
3> SBT parms= ' sbt_library=/usr/oracle/app/oracle/product/11.2.0/dbhome_1/lib/libosbws11.so,
4> sbt_parms= (Osb_ws_pfile=/usr/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/osbwsorcl.ora) ';
5> restore Tablespace up2s3;
6> recover tablespace up2s3;
7>}
sql> alter tablespace UP2S3 online;
Tablespace altered.
Sql> Conn Tests3/test
Connected.
Sql> select * from test;
Id
--------------------
Abc
This article is from the "Technical Blog" blog, please be sure to keep this source http://raytech.blog.51cto.com/7602157/1676757
Oracle RMAN Backup to the AWS Cloud