Check here Demo:- How to Backing Up A Database From On-Premise To Object Storage Using RMAN
The Oracle Cloud provides for this purpose Object Storage, and we get 20GB for free forever. This storage is also being used when you want to make backups of the database, and use Datapump to export and import data.
You can optionally use compression when backing up Oracle databases to Oracle Database Backup Cloud Service. Compression conserves bandwidth by reducing the size of your backups before they’re sent to the cloud. You’ll specify compression when you perform a backup.
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
Check Backup is validated
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)’;
RESTORE DATABASE PREVIEW;
}2> 3> 4> 5> 6> 7>
allocated channel: c1
channel c1: SID=48 device type=SBT_TAPE
channel c1: Oracle Database Backup Service Library VER=19.0.0.1
Starting restore at 22-JUL-20
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
——- —- — ———- ———– ———— —————
8 Full 330.50M SBT_TAPE 00:04:06 22-JUL-20
BP Key: 8 Status: AVAILABLE Compressed: YES Tag: TAG20200722T193904
Handle: 09v5vemo_1_1 Media: objectstorage.ap-hyderaba..lecloud.com/n/axdazzzrombz/Rmanbackup
List of Datafiles in backup set 8
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
—- — —- ———- ——— ———– —— —-
1 Full 1504410 22-JUL-20 NO /u01/app/oracle/oradata/oradbwr/system01.dbf
3 Full 1504410 22-JUL-20 NO /u01/app/oracle/oradata/oradbwr/sysaux01.dbf
4 Full 1504410 22-JUL-20 NO /u01/app/oracle/oradata/oradbwr/undotbs01.dbf
7 Full 1504410 22-JUL-20 NO /u01/app/oracle/oradata/oradbwr/users01.dbf
List of Archived Log Copies for database with db_unique_name ORADBWR
=====================================================================
Key Thrd Seq S Low Time
——- —- ——- – ———
3 1 3 A 20-JUL-20
Name: /u01/app/oracle/fast_recovery_area/oradbwr/ORADBWR/archivelog/2020_07_22/o1_mf_1_3_hkjlhb7h_.arc
4 1 4 A 22-JUL-20
Name: /u01/app/oracle/fast_recovery_area/oradbwr/ORADBWR/archivelog/2020_07_22/o1_mf_1_4_hkjlhc3r_.arc
recovery will be done up to SCN 1504410
Media recovery start SCN is 1504410
Recovery must be done beyond SCN 1504410 to clear datafile fuzziness
validation succeeded for backup piece
Finished restore at 22-JUL-20
released channel: c1
RMAN>
Connect with me:-
Telegram App:https://t.me/oracledbwr
LinkedIn:https://www.linkedin.com/in/hariprasathdba
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page : https://www.facebook.com/dbahariprasath/?
Twitter : https://twitter.com/oracledbwr
