Backup Oracle database to Active tier

Thank you for your feedback!

We tested the backup of Oracle 19c database on PowerFlex HCI system running on on-premises with DDVE. The DD system uses PowerFlex storage as an active tier to store Oracle database backup data.

The high-level steps for the backup process are as follows:

Configure storage-unit for Oracle database backup on DD system
Install the Oracle RMAN agent on Database server
Configure RMAN for the environment
Backup the Oracle database

Step 1: Create a storage unit from the PowerFlex storage on a DDVE VM.

Prerequisites: Ensure that the file system is enabled and running and the DD Boost protocol and distributed-segment-processing option must be enabled.

Perform the following steps to create a storage unit from the PowerFlex storage on a DDVE VM:

a) Run the following command to create a non-default user with administrative role:

sysadmin@ddvs# user add <user_name> password <password> role admin

b) Run the following command to make the user as DD Boost user and verify the user details:

sysadmin@ddve# ddboost user assign <user_name>

sysadmin@ddve# ddboost user show

c) On a DD system, run the following command to create a storage unit and verify the storage unit details:

sysadmin@ddve# ddboost storage-unit create <storage_unit_name> user <user_name>

sysadmin#ddbe# ddboost storage-unit show

d) For Oracle RMAN agent operations, ensure that you have enabled the Oracle optimized deduplication feature at the MTree level in the Data Domain system by running the following command:

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"

e) Verify that the MTrees with the value of oracle1 have the Oracle optimized deduplication enabled:

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)

------------------------ ------------------------- -----------------

Step 2: Install the Oracle RMAN agent on the database server

Perform the following steps to install the Oracle RMAN agent on the database server:

a) Ensure that no Oracle database backups are running. Stop the RMAN processes before installation of the Oracle RMAN agent.

b) Download the Oracle RMAN agent software package for the operating system from the Dell Support site.

c) Change the ownership of the tar file to Oracle user by running the following command:

[root@oradb2 oracle]# chown oracle:oinstall ddrman198_linux_x86_64.tar

[root@oradb2 oracle]# chmod +x ddrman198_linux_x86_64.tar

d) Uncompress the downloaded tar file using the Oracle user by running the following command:

[oracle@oradb2 ~]$ tar -xvf ddrman198_linux_x86_64.tar

e) As an Oracle user, run the install.sh script as follows:

[oracle@oradb2 ddrman]$ ./install.sh

Do you want to install under the default installation directory /home/oracle/opt/dpsapps/rmanagent? (y or n)

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)

Updating settings in the /u01/app/oracle/product/19.0.0/db_1 directory.

Settings are updated.

Installation is completed.

[oracle@oradb2 ddrman]$

f) Set the RMAN_AGENT_HOME environment variable to specify the installation directory for the Oracle RMAN agent. The default path is: /home/oracle1/opt/dpsapps/rmanagent

Step 3: Configure RMAN for the environment

Perform the following steps to configure the RMAN agent:

a) Configure the channel, DD hostname (IP address), storage unit, and DD library path in a Linux environment by running the following command:

RMAN> CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' TRACE 5

PARMS 'BLKSIZE=1048576,

SBT_LIBRARY=/home/oracle/opt/dpsapps/rmanagent/lib/libddobk.so,

ENV=(STORAGE_UNIT=oracle_backup,

BACKUP_HOST=192.168.105.175,

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' TRACE 5 PARMS 'BLKSIZE=1048576,SBT_LIBRARY=/home/oracle/opt/dpsapps/rmanagent/lib/libddobk.so,ENV=(STORAGE_UNIT=oracle_backup,BACKUP_HOST=192.168.105.175,RMAN_AGENT_HOME=/home/oracle/opt/dpsapps/rmanagent)';

new RMAN configuration parameters are successfully stored

RMAN>

b) Verify the RMAN configuration by running the following command:

RMAN> show all;

RMAN configuration parameters for database with db_unique_name ORADB1 are:

RMAN>

c) Register a DD system user by running the following commands, so that RMAN can connect to it for backup operations:

RMAN> RUN {

ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE' TRACE 5 PARMS

2> 'BLKSIZE=1048576,

SBT_LIBRARY=/home/oracle/opt/dpsapps/rmanagent/lib/libddobk.so,

3> 4> 5> ENV=(BACKUP_HOST=192.168.105.175,

6> RMAN_AGENT_HOME=/home/oracle/opt/dpsapps/rmanagent/)';

7> send 'set username sysadmin password Dellam123! servername 192.168.105.175 storageunit oracle_backup';

8> RELEASE CHANNEL CH1;

9> }

allocated channel: CH1

channel CH1: SID=874 device type=SBT_TAPE

channel CH1: Data Domain Boost API

sent command to channel: CH1

released channel: CH1

RMAN>

Step 4: Perform full or incremental level backup of the Oracle database

Perform the following steps to back up the Oracle database:

a) Perform Incremental level 0 Oracle database backup by running the following command:

RUN {

ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE' TRACE 5 PARMS

'BLKSIZE=1048576, SBT_LIBRARY=/home/oracle/opt/dpsapps/rmanagent/lib/libddobk.so,

ENV=(STORAGE_UNIT=oracle_backup, BACKUP_HOST=192.168.105.175, RMAN_AGENT_HOME=/home/oracle/opt/dpsapps/rmanagent/)';

send 'set username pfuser password Dellam123! servername 192.168.105.175 storageunit oracle_backup';

BACKUP INCREMENTAL LEVEL 0 DATABASE PLUS ARCHIVELOG FORMAT '%U_%p_%t';

RELEASE CHANNEL CH1;

}

b) Perform Incremental level 1 Oracle database backup by running the following command:

RUN {

ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE' TRACE 5 PARMS

'BLKSIZE=1048576, SBT_LIBRARY=/home/oracle/opt/dpsapps/rmanagent/lib/libddobk.so,

ENV=(STORAGE_UNIT=oracle_backup, BACKUP_HOST=192.168.105.175, RMAN_AGENT_HOME=/home/oracle/opt/dpsapps/rmanagent/)';

send 'set username pfuser password Dellam123! servername 192.168.105.175 storageunit oracle_backup';

BACKUP INCREMENTAL LEVEL 1 DATABASE PLUS ARCHIVELOG FORMAT '%U_%p_%t';

RELEASE CHANNEL CH1;

}

c) Verify the Incremental level of Oracle database backup by running the following command:

RMAN> list backup;

List of Backup Sets

===================

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

1 Full 1.10T SBT_TAPE 02:19:42 26-APR-22

BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20220426T104237

Handle: 010rtgsu_1_1_1_1103020958 Media: s:192.168.105.175:/oracle_backup

List of Datafiles in backup set 1

File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name

---- -- ---- ---------- --------- ----------- ------ ----

1 Full 8854148 26-APR-22 NO +DATA/ORADB19C2/DATAFILE/system.256.1098159747

2 Full 8854148 26-APR-22 NO +DATA/ORADB19C2/DATAFILE/sysaux.257.1098159751

3 Full 8854148 26-APR-22 NO +DATA/ORADB19C2/DATAFILE/undotbs1.258.1098159753

4 Full 8854148 26-APR-22 NO +DATA/ORADB19C2/DATAFILE/users.260.1098159823

5 Full 8854148 26-APR-22 NO +DATA/ORADB19C2/DATAFILE/daily_change_tbs.263.1098162981

6 Full 8854148 26-APR-22 NO +DATA/ORADB19C2/DATAFILE/slobdata.262.1098161549..

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

11 Incr 1 92.47G SBT_TAPE 00:31:07 26-MAY-22

BP Key: 11 Status: AVAILABLE Compressed: NO Tag: TAG20220526T230905

Handle: 0d0ugk8h_1_1 Media: s:192.168.105.175:/oracle_backup

List of Datafiles in backup set 11

File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name

---- -- ---- ---------- --------- ----------- ------ ----

1 1 Incr 12920078 26-MAY-22 NO +DATA/ORADB19C2/DATAFILE/system.256.1098159747

2 1 Incr 12920078 26-MAY-22 NO +DATA/ORADB19C2/DATAFILE/sysaux.257.1098159751

3 1 Incr 12920078 26-MAY-22 NO +DATA/ORADB19C2/DATAFILE/undotbs1.258.1098159753

4 1 Incr 12920078 26-MAY-22 NO +DATA/ORADB19C2/DATAFILE/users.260.1098159823

5 1 Incr 12920078 26-MAY-22 NO +DATA/ORADB19C2/DATAFILE/daily_change_tbs.263.1098162981

6 1 Incr 12920078 26-MAY-22 NO +DATA/ORADB19C2/DATAFILE/slobdata.262.1098161549

d) Check the Oracle database backup set stored in the active tier by running the following command. When the Location column is showing Active, it means that the PowerFlex volume image copies are stored in the active tier.

For example:

sysadmin@ddve# filesys report generate file-location path all

-------------------------------- ---------------------- ---------------------- ---------------------------

File Name Location(Unit Name) Size Placement Time

-------------------------------- ---------------------- ---------------------- ---------------------------

/data/col1/oracle_backup/070rv5lm_1_1_1_1103074998 Active 1.61 GiB Tue Apr 26 22:42:23 2022

/data/col1/oracle_backup/080rv5m6_1_1 Active 1.10 TiB Tue Apr 26 22:42:39 2022

/data/col1/oracle_backup/090rvdbb_1_1_1_1103082859 Active 8.00 MiB Wed Apr 27 00:53:24 2022

/data/col1/oracle_backup/c-1770267178-20220427-00 Active 11.00 MiB Wed Apr 27 00:53:26 2022

-----------------------------------------------------------------

sysadmin@ddve#

Your Browser is Out of Date