Webfly Blog

Secure Oracle RMAN backup to Amazon cloud S3

Configure secure backup to Amazon cloud S3. Use database webfly01.

Create table EMP_TEST in tablespace user:

CREATE TABLE emp_test (
     emp_id NUMBER(6) NOT NULL,
     first_name VARCHAR2(30) NOT NULL,
     last_name VARCHAR2(30) NOT NULL,
     email VARCHAR2(30) NOT NULL,
     salary NUMBER(8,2),
     comm_pct NUMBER(2,2),
     mgr_id NUMBER(6))
tablespace USERS;
INSERT INTO emp_test VALUES (1,'Peter','Bucek','oracle@webfly.sk',11500,0.05,3);
INSERT INTO emp_test VALUES (2,'Yves','Smith','yves@webfly.sk',16500,0.02,3);
INSERT INTO emp_test VALUES (3,'Jo','Ma','jo@webfly.sk',15000,0.04,NULL)...

Oracle RMAN backup to Amazon cloud S3

After installation you can use to backup database cloud. The deposit is a replacement for tape and is available within a few hours. Of course, are determinants to backup to the cloud and depend on the size of the database, upload speed internet access and a defined geographic location. RESTORE speed is slower than from local storage, backup to the cloud is meant to replace the tape to improve our backup strategy. Amazon Web Services to use metered costs are very competitive, it does not require the licensed product and backup integrates directly with RMAN backup. This article provides a quick ...