RMAN compress backup to Amazon cloud


RMAN Compress backup

  • Backup database without compress: 1016 MB (database is only default configure without data)
  • Backup database with compress: 346,7 MB (database is only default configure without data)
RMAN> backup as compressed backupset database;
RMAN> list backup;

List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Full    1.16G      SBT_TAPE    00:01:10     11-OCT-16
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20161011T110923
        Handle: 03ri39j3_1_1   Media: s3.amazonaws.com/oracle-data-peterbuc-1
  List of Datafiles in backup set 2
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1701618    11-OCT-16 /u01/app/oracle/oradata/webfly01/system01.dbf
  3       Full 1701618    11-OCT-16 /u01/app/oracle/oradata/webfly01/sysaux01.dbf
  4       Full 1701618    11-OCT-16 /u01/app/oracle/oradata/webfly01/undotbs01.dbf
  6       Full 1701618    11-OCT-16 /u01/app/oracle/oradata/webfly01/users01.dbf
BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7       Full    346.75M    SBT_TAPE    00:01:16     16-OCT-16
        BP Key: 7   Status: AVAILABLE  Compressed: YES  Tag: TAG20161016T154130
        Handle: 08rigvda_1_1   Media: s3.amazonaws.com/oracle-data-peterbuc-1
  List of Datafiles in backup set 7
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 2083215    16-OCT-16 /u01/app/oracle/oradata/webfly01/system01.dbf
  3       Full 2083215    16-OCT-16 /u01/app/oracle/oradata/webfly01/sysaux01.dbf
  4       Full 2083215    16-OCT-16 /u01/app/oracle/oradata/webfly01/undotbs01.dbf
  6       Full 2083215    16-OCT-16 /u01/app/oracle/oradata/webfly01/users01.dbf

Configure default device to STB_TAPE (Amazon cloud S3)

RMAN> configure default device type to 'sbt_tape';

new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
new RMAN configuration parameters are successfully stored

Posted in Databázy, RMAN on okt 18, 2016