CLOUD BACKUP

 

On-premise rman backup to object storage

Recovery Manager (RMAN) supports binary compression using one of the following compression levels: HIGH, MEDIUM, BASIC, and LOW. The recommended level for cloud backups is MEDIUM.

CONFIGURE COMPRESSION ALGORITHM ‘MEDIUM’;
CONFIGURE DEVICE TYPE sbt BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE COMPRESSION ALGORITHM ‘MEDIUM’ AS OF RELEASE ‘DEFAULT’ OPTIMIZE FOR LOAD TRUE;
CONFIGURE DEVICE TYPE ‘SBT_TAPE’ PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE ‘SBT_TAPE’ BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 4;

RMAN> run
{
allocate channel c1 TYPE ‘SBT_TAPE’ PARMS
‘SBT_LIBRARY=/u01/app/oracle/product/12.2.0.1/db_1/lib/libopc.so,
ENV=(OPC_PFILE=/u01/app/oracle/product/12.2.0.1/db_1/dbs/opcdbwr.ora)’;
backup current controlfile;
backup as compressed backupset full database;
sql ‘alter system archive log current’;
backup archivelog all;
}

allocated channel: c1
channel c1: SID=48 device type=SBT_TAPE
channel c1: Oracle Database Backup Service Library VER=19.0.0.1
Starting backup at 22-JUL-20
channel c1: starting compressed full datafile backup set
channel c1: specifying datafile(s) in backup set
including current control file in backup set
channel c1: starting piece 1 at 22-JUL-20
channel c1: finished piece 1 at 22-JUL-20
piece handle=08v5vemf_1_1 tag=TAG20200722T193855 comment=API Version 2.0,MMS Version 19.0.0.1
channel c1: backup set complete, elapsed time: 00:00:08
Finished backup at 22-JUL-20
Starting backup at 22-JUL-20
channel c1: starting compressed full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/oradbwr/system01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/oradbwr/sysaux01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/oradbwr/undotbs01.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/oradbwr/users01.dbf
channel c1: starting piece 1 at 22-JUL-20
channel c1: finished piece 1 at 22-JUL-20
piece handle=09v5vemo_1_1 tag=TAG20200722T193904 comment=API Version 2.0,MMS Version 19.0.0.1
channel c1: backup set complete, elapsed time: 00:05:45
Finished backup at 22-JUL-20

Starting Control File and SPFILE Autobackup at 22-JUL-20
piece handle=c-1473061046-20200722-00 comment=API Version 2.0,MMS Version 19.0.0.1
Finished Control File and SPFILE Autobackup at 22-JUL-20

sql statement: alter system archive log current

Starting backup at 22-JUL-20
current log archived
channel c1: starting compressed archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=1 STAMP=1046252355
input archived log thread=1 sequence=2 RECID=2 STAMP=1046301412
input archived log thread=1 sequence=3 RECID=3 STAMP=1046461507
input archived log thread=1 sequence=4 RECID=4 STAMP=1046461507
channel c1: starting piece 1 at 22-JUL-20
channel c1: finished piece 1 at 22-JUL-20
piece handle=0bv5vf23_1_1 tag=TAG20200722T194507 comment=API Version 2.0,MMS Version 19.0.0.1
channel c1: backup set complete, elapsed time: 00:01:53
Finished backup at 22-JUL-20

Starting Control File and SPFILE Autobackup at 22-JUL-20
piece handle=c-1473061046-20200722-01 comment=API Version 2.0,MMS Version 19.0.0.1
Finished Control File and SPFILE Autobackup at 22-JUL-20
released channel: c1