Data Domain Backup Solution

Introduction

The processes for installing, configuring, integrating, and validating a Data Domain DD6300 system for data protection of databases are based on the specific operating system and DBMS being installed. However, the general concept and flow are similar.

For details about implementing data protection, see your DBMS vendor documentation and DD6300 Appliance on Dell EMC Online Support.

For details about installing and configuring the DD Boost agents for your environment, see the Dell EMC Database Application Agent Installation and Administration Guide.

To set up the Data Domain environment, follow the procedures in this section to accomplish these tasks:

1. Install the Data Domain agent.

2. Configure the Data Domain agent.
3. Create scripts for DD Boost operations.

Installing the Data Domain agent

Installing the Data Domain agent involves these steps:

1. Installing the database application agent software on the Linux host

2. Creating a storage unit by using the DD Boost storage-unit command

Installing the database application agent software on Linux host

To install the database application agent software on a Linux VM, follow these steps:

3. Download the appropriate database application agent software package, and then copy or move the agent software to the required database host.

You can obtain the software package at https://support.emc.com/downloads/23107?siteLocale=en_US.

4. On a Linux platform, uncompress and extract the downloaded file by using the gunzip and tar utilities.
5. On a Red Hat Enterprise Linux platform, ensure that you have downloaded and installed the compat-libstdc++-33 package.
6. Use RPM to install the DD Boost software.
7. Log in to Data Domain system as the sysadmin user and verify that the Data Domain file system is enabled:

# filesys status

8. Create the users that are required to enable Data Domain access for the database servers:

# user add <username> password <password>

Creating a storage unit

Create one or more storage units on each Data Domain system to use with the database application agent. Each storage unit name on a single Data Domain system must be unique.

Provide the storage unit name when you configure the operations with the database application agent.

Note: Storage unit names are case-sensitive.

To create a storage unit:

1. Run the ddboost storage-unit command:

sysadmin@DD6300# ddboost storage-unit create slob_unit_7 user db_backup

2. To enable application-optimized compression (if applicable), run the mtree command:

sysadmin@DD6300# mtree option set app-optimized-compression oracle1 mtree /data/col1/slob_unit_7

Note: Enable application-optimized compression each time you create a storage unit.

Configuring the Data Domain agent

Configure the Data Domain agent as follows:

1. Run the following commands on the DBMS nodes:

[root@dbhost1 ~]#  cd /opt/dpsapps/dbappagent/bin/

[root@dbhost1 bin]# ./ddbmadmin -L -a LOCKBOX_PATH=/opt/dpsapps/common/lockbox -a LOCKBOX_OWNER_GID=54321

[root@dbhost1 bin]# ./ddbmadmin -G -a LOCKBOX_PATH=/opt/dpsapps/common/lockbox -a LOCKBOX_REMOTE_HOST=c7-tp-vm1 -a VIRTUAL_HOST=yes

[root@dbhost1 bin]# ./ddbmadmin –L

2. If applicable, edit the DD Boost agent configuration file with information about the new storage unit.
3. If applicable, update the DD Boost agent configuration by running the ddbmadmin -P -z command, referencing the DD Boost agent configuration file:

[root@dbhost1 bin]# ./ddbmadmin -P -z <config file>

4. Repeat the preceding steps for the other DBMS nodes in the environment that you want to protect.

Creating scripts for DD Boost operations

If your DBMS environment requires script integration (as with Oracle), you can use templates in the agent download that are specific to your environment. You can then customize the scripts accordingly. For further guidance, see the Dell EMC Database Application Agent Installation and Administration Guide.