Home > Storage > PowerFlex > White Papers > Dell APEX Block Storage for AWS: Backup and Recovery using DDVE and DD Boost Oracle RMAN Agent > Backup procedure
We evaluated backup of the Oracle 19c database using Dell APEX Block storage for AWS with DDVE to store the backups in an Amazon S3 object store.
The high-level steps for the backup process include:
sysadmin@ddvs# user add <user_name> password <password> role none |
sysadmin@ddve# ddboost user assign <user_name> sysadmin@ddve# ddboost user show |
sysadmin@ddve# ddboost storage-unit create <storage_unit_name> user <user_name> sysadmin#ddbe# ddboost storage-unit show |
sysadmin@ddve# mtree option set app-optimized-compression oracle1 mtree /data/col1/oracle_backup Changing this setting will cause dedup issues for the next backup. Please ensure that this system has enough space before applying this setting. Are you sure? (yes|no) [no]: yes
ok, proceeding.
app-optimized-compression for mtree "/data/col1/oracle_backup" set to "oracle1" |
sysadmin@ddve# mtree option show Name Option Value ------------------------ ------------------------- ----------------- /data/col1/backup app-optimized-compression global (none) /data/col1/backup randomio global (enabled) /data/col1/backup anchoring-algorithm global (variable) /data/col1/oracle_backup app-optimized-compression oracle1 /data/col1/oracle_backup randomio global (enabled) /data/col1/oracle_backup anchoring-algorithm global (variable) ------------------------ ------------------------- ----------------- |
[root@oraaz1 oracle]# chown oracle:oinstall ddrman198_linux_x86_64.tar [root@oraaz1 oracle]# chmod +x ddrman198_linux_x86_64.tar |
[oracle@oraaz1 ~]$ tar -xvf ddrman198_linux_x86_64.tar |
[oracle@oraaz1 ddrman]$ ./install.sh Do you want to install under the default installation directory /home/oracle/opt/dpsapps/rmanagent? (y or n) y The lib directory /home/oracle/opt/dpsapps/rmanagent/lib is created. The config directory /home/oracle/opt/dpsapps/rmanagent/config is created. The settings directory /home/oracle/opt/dpsapps/rmanagent/settings is created. .. The bin directory /home/oracle/opt/dpsapps/rmanagent/bin is created. The log directory /home/oracle/opt/dpsapps/rmanagent/logs is created. The tmp directory /home/oracle/opt/dpsapps/rmanagent/tmp is created. Installing the Oracle RMAN agent. Copying the lockbox libraries to /home/oracle/opt/dpsapps/rmanagent/lib/. Copying libddobk.so to /home/oracle/opt/dpsapps/rmanagent/lib/. Copying libDDBoost.so to /home/oracle/opt/dpsapps/rmanagent/lib/. Copying libzmq.so.5 to /home/oracle/opt/dpsapps/rmanagent/lib/. Copying ddutil to /home/oracle/opt/dpsapps/rmanagent/bin/. Copying the dependency libraries to /home/oracle/opt/dpsapps/rmanagent/lib/. .. .. .. Creating the lockbox. Successfully installed the Oracle RMAN agent. The Oracle RMAN agent library, libddobk.so, does not exist in /u01/app/oracle/product/19.0.0/db_1/lib. Do you want to update settings in /u01/app/oracle/product/19.0.0/db_1 directory so that RMAN scripts from previous installation can be reused? (y or n) y Updating settings in the /u01/app/oracle/product/19.0.0/db_1 directory. Settings are updated. Installation is completed. [oracle@oraaz1 ddrman]$ |
RMAN> CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'BLKSIZE=1048576, SBT_LIBRARY=/home/oracle/opt/dpsapps/rmanagent/lib/libddobk.so, ENV=(STORAGE_UNIT=oracle_backup, BACKUP_HOST=10.63.xx.xx, RMAN_AGENT_HOME=/home/oracle/opt/dpsapps/rmanagent)';2> 3> 4> 5> 6>
using target database control file instead of recovery catalog new RMAN configuration parameters: CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'BLKSIZE=1048576,SBT_LIBRARY=/home/oracle/opt/dpsapps/rmanagent/lib/libddobk.so,ENV=(STORAGE_UNIT=oracle_backup,BACKUP_HOST=10.63.xx.xx,RMAN_AGENT_HOME=/home/oracle/opt/dpsapps/rmanagent)'; new RMAN configuration parameters are successfully stored
RMAN> |
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORADB1 are: .. CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'BLKSIZE=1048576,SBT_LIBRARY=/home/oracle/opt/dpsapps/rmanagent/lib/libddobk.so,ENV=(STORAGE_UNIT=oracle_backup,BACKUP_HOST=10.63.xx.xx,RMAN_AGENT_HOME=/home/oracle/opt/dpsapps/rmanagent)';
RMAN> |
# ./ddutil -C -a VERIFY_CREDENTIAL=TRUE |
RMAN> RUN { ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE' PARMS 'BLKSIZE=1048576, SBT_LIBRARY=/home/oracle/opt/dpsapps/rmanagent/lib/libddobk.so, ENV=(STORAGE_UNIT=oracle_backup, BACKUP_HOST=10.63.xx.xx, RMAN_AGENT_HOME=/home/oracle/opt/dpsapps/rmanagent/)'; BACKUP DATABASE FORMAT './%d/bk_%d_%I_%T_%U'; RELEASE CHANNEL CH1; }2> 3> 4> 5> 6> 7> 8>
allocated channel: CH1 channel CH1: SID=3512 device type=SBT_TAPE channel CH1: Data Domain Boost API
sent command to channel: CH1
Starting backup at 08-APR-22 channel CH1: starting full datafile backup set channel CH1: specifying datafile(s) in backup set input datafile file number=00005 name=+DATA/ORADB1/DATAFILE/slobdata.264.1099668103 input datafile file number=00002 name=+DATA/ORADB1/DATAFILE/daily_change_tbs.262.1101380557 input datafile file number=00004 name=+DATA/ORADB1/DATAFILE/undotbs1.259.1099665379 input datafile file number=00003 name=+DATA/ORADB1/DATAFILE/sysaux.258.1099665365 input datafile file number=00001 name=+DATA/ORADB1/DATAFILE/system.257.1099665329 input datafile file number=00007 name=+DATA/ORADB1/DATAFILE/users.260.1099665381 channel CH1: starting piece 1 at 08-APR-22 channel CH1: finished piece 1 at 08-APR-22 piece handle=050qdn2d_1_1_1_1101454413 tag=TAG20220408T073333 comment=API Version 2.0,MMS Version 19.8.0.0 channel CH1: backup set complete, elapsed time: 03:16:15 Finished backup at 08-APR-22
Starting Control File and SPFILE Autobackup at 08-APR-22 piece handle=c-2444855773-20220408-00 comment=API Version 2.0,MMS Version 19.8.0.0 Finished Control File and SPFILE Autobackup at 08-APR-22
released channel: CH1
RMAN> |
RMAN> list backup;
List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 1 Full 2.25T SBT_TAPE 03:16:13 08-APR-22 BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20220408T073333 Handle: 050qdn2d_1_1_1_1101454413 Media: s:10.63.xx.xx:/oracle_backup List of Datafiles in backup set 1 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- --------- ----------- ------ ---- 1 Full 69904479 08-APR-22 NO +DATA/ORADB1/DATAFILE/system.257.1099665329 2 Full 69904479 08-APR-22 NO +DATA/ORADB1/DATAFILE/daily_change_tbs.262.1101380557 3 Full 69904479 08-APR-22 NO +DATA/ORADB1/DATAFILE/sysaux.258.1099665365 4 Full 69904479 08-APR-22 NO +DATA/ORADB1/DATAFILE/undotbs1.259.1099665379 5 Full 69904479 08-APR-22 NO +DATA/ORADB1/DATAFILE/slobdata.264.1099668103
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 2 Full 11.00M SBT_TAPE 00:00:00 08-APR-22 BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20220408T104949 Handle: c-2444855773-20220408-00 Media: s:10.63.xx.xx:/oracle_backup SPFILE Included: Modification time: 08-APR-22 SPFILE db_unique_name: ORADB1 Control File Included: Ckp SCN: 69912119 Ckp time: 08-APR-22 RMAN> |
RMAN> RUN { ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE' PARMS 'BLKSIZE=1048576, SBT_LIBRARY=/home/oracle/opt/dpsapps/rmanagent/lib/libddobk.so, ENV=(STORAGE_UNIT=oracle_backup, BACKUP_HOST=10.63.xx.xx, RMAN_AGENT_HOME=/home/oracle/opt/dpsapps/rmanagent/)'; BACKUP INCREMENTAL LEVEL 0 DATABASE PLUS ARCHIVELOG FORMAT './%d/bk_%d_%I_%T_%U'; RELEASE CHANNEL CH1; } |
RMAN> RUN { ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE' PARMS 'BLKSIZE=1048576, SBT_LIBRARY=/home/oracle/opt/dpsapps/rmanagent/lib/libddobk.so, ENV=(STORAGE_UNIT=oracle_backup, BACKUP_HOST=10.63.xx.xx, RMAN_AGENT_HOME=/home/oracle/opt/dpsapps/rmanagent/)'; BACKUP INCREMENTAL LEVEL 1 DATABASE PLUS ARCHIVELOG FORMAT './%d/bk_%d_%I_%T_%U'; RELEASE CHANNEL CH1; } |
RMAN> list backup;
List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 2 Incr 0 1.10T SBT_TAPE 01:49:06 14-APR-22 BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20220414T064008 Handle: 030qte68_1_1 Media: s:10.63.xx.xx:/oracle_backup List of Datafiles in backup set 2 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- --------- ----------- ------ ---- 1 0 Incr 2738059 14-APR-22 NO +DATA/ORADB1/DATAFILE/system.257.1101904521 2 0 Incr 2738059 14-APR-22 NO +DATA/ORADB1/DATAFILE/daily_change_tbs.263.1101916583 3 0 Incr 2738059 14-APR-22 NO +DATA/ORADB1/DATAFILE/sysaux.258.1101904555 4 0 Incr 2738059 14-APR-22 NO +DATA/ORADB1/DATAFILE/undotbs1.259.1101904571 5 0 Incr 2738059 14-APR-22 NO +DATA/ORADB1/DATAFILE/slobdata.270.1101906489 7 0 Incr 2738059 14-APR-22 NO +DATA/ORADB1/DATAFILE/users.264.1101904571 .. .. BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 6 Incr 1 91.81G SBT_TAPE 00:27:10 14-APR-22 BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20220414T162509 Handle: 070qugf5_1_1 Media: s:10.63.xx.xx:/oracle_backup List of Datafiles in backup set 6 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- --------- ----------- ------ ---- 1 1 Incr 2871490 14-APR-22 NO +DATA/ORADB1/DATAFILE/system.257.1101904521 2 1 Incr 2871490 14-APR-22 NO +DATA/ORADB1/DATAFILE/daily_change_tbs.263.1101916583 3 1 Incr 2871490 14-APR-22 NO +DATA/ORADB1/DATAFILE/sysaux.258.1101904555 4 1 Incr 2871490 14-APR-22 NO +DATA/ORADB1/DATAFILE/undotbs1.259.1101904571 5 1 Incr 2871490 14-APR-22 NO +DATA/ORADB1/DATAFILE/slobdata.270.1101906489 7 1 Incr 2871490 14-APR-22 NO +DATA/ORADB1/DATAFILE/users.264.1101904571 |