Detailed System Requirements
Abstract
This document details the backup and restore requirements for Oracle Database for IBM Storage Defender Copy Data Management 2.3.1.
Content
Important Brand Change Information
Quick Navigation
General
For Linux-based and AIX-based systems, the agent installation directory must be excluded for any anti-virus software scans. Add this path to the exclusion list for all anti-virus software that is installed on the application server. For Oracle, InterSystems Caché and IRIS, and SAP HANA:
/tmp/cdm_guestapps_<username>Where <username> is the username of the account used to register the application server in IBM Storage Defender Copy Data Management.
Configuration
Oracle Configuration
Storage Systems
IBM Storage Virtualize
Pure Storage
Dell PowerMax
Dell PowerFlex Manager
Note: Due to a known limitation in PowerFlex Manager version 4.6.x and 4.8.x, the standard user account with storage admin privileges is insufficient for performing remote snapshot operations. As a workaround, user must be granted super-user privileges.
Dell PowerStore Manager
Note: Only Virtual Applications Supported
Notes
- Standalone databases protected by IBM Storage Defender Copy Data Management can be recovered to the same or alternate standalone server installation. When you recover from standalone to RAC, if the source database uses Automatic Storage Management, then it is successfully recovered to all nodes in the destination cluster. If the source database uses non-ASM storage, the database is mounted only on the first node in the destination RAC.
- RAC databases protected by IBM Storage Defender Copy Data Management can be recovered to the same or another RAC installation or to a standalone ASM server. To recover a RAC database to a standalone server, the Grid Infrastructure must be installed on the destination server, and an ASM instance must be running.
- Oracle Flex ASM is not supported. Oracle ASM is not supported in virtual mode.
- RAC database recoveries are not server pool aware. IBM Storage Defender Copy Data Management can recover databases to a RAC, but not to a specific server pools.
- IBM Storage Defender Copy Data Management supports recovering databases from a source physical server to a destination-virtual server by provisioning disks as physical RDMs. Similarly, IBM Storage Defender Copy Data Management can recover databases from a source-virtual server that uses physical RDM to a destination physical server. However, source databases on VMDK virtual disks can be recovered only to another virtual server and not to a physical server.
- Oracle data must stay directly on one of the supported Storage Systems listed previously. VADP-based protection of virtual Oracle servers is not supported.
- On AIX LPAR/VIO servers, Oracle data must stay on disks attached to the server by using NPIV. Virtual SCSI disks are not supported.
- Masking and DevOps recoveries are not supported on virtual servers.
- For supported VMware vSphere versions, see in System Requirements: IBM Storage Defender Copy Data Management 2.3.1.
- Oracle servers registered as Virtual need VMware Tools installed and running.
- Data masking is not supported for Oracle in NetApp storage environments. Masking is not supported on source database on NFS (a copy of which cloned and masked) or source databases on replica copies. Instead of the default mirror copy, you must select a snapshot copy as a replication source.
- NetApp systems running in 7-Mode are not supported.
Oracle 19c standalone is now supported for AIX 7.3. More requirements:
Oracle database data and the flash recovery area (FRA) must stay on supported Storage Systems. IBM Storage Defender Copy Data Management can back up archived logs to a supported storage system if they are not already on one.During an Instant Database Restore, there might be failures if the new name specified for the restored database is similar to an existing database differing only by numerical suffix. For clustered instances of Oracle databases, the appliance always uses global database name in the UI.- On all supported storage systems, snapshot condense is run during every maintenance jobs.
- Supported platforms: IBM Power Systems and Intel based Systems running supported AIX and Linux OS.
For Dell PowerMax Storage:
Use separate Storage Groups (SG) for different databases for improved performance.IBM Storage Defender Copy Data Management supports one parent SG, and it can contain different child SG for different databases.Keep datafiles and log files in separate SG.When using Parent SG with child SGs, use separate child SGs for data and log.For Instant Disk Restore, Host on Dell PowerMax array must have at least one Masking View created for itself, even if the host is a part of a hostgroup having active Masking View.Oracle 19c RAC configuration is now supported on the DELL PowerMax storage system.Oracle 21c RAC configuration is not supported on the DELL PowerMax storage system.For remote replication feature, please create and map the host to the remote array and have at least 1 masking created using it. The portgroup used in the masking view created by the user will be used by the CDM restore job while creating masking view to map the restored volumes to the host on the remote array.- CDM does not support multiple DBs with same db_name (but different db_unique_name), as it relies on db_name to uniquely identify the Oracle home belonging to the database (instance).
- User should make sure that Oracle parameters (texts) do not exceed the recommended size by Oracle. e.g. CDM workflow may fail when the size of '_fix_control' parameter exceeds 255 characters.
- In Oracle RAC configuration, the cluster database restore will create only a single instance and the restored instance is not registered as a cluster resource.
When the Prepare scripts option is chosen, the files will be copied to the CDM appliance under
/data/log/ecxdeployer/<YYYY-MM-DD>/<random generated string>folder.Note: To run these scripts, they need to be copied from this folder of the CDM appliance to any preferred location on the Oracle Server.
In order to execute the scripts, follow these steps as an Oracle user:
a. Export the Oracle SID as the SID used during recovery.b. When executing an SQL script, login to SQLPlus usingsqlplus / as sysdba. You can then run the script:@<location in oracle server>/Step-<number>_<operation>.sqlc. When executing an RMAN script, login to RMAN usingrman target=/. You can then run the script as:@<location in oracle server>/Step-<number>_<operation>.rmanFor Dell PowerFlex Storage:
Ensure that the VMware ESXi hostnames registered in Dell PowerFlex Storage exactly match the hostnames configured on the VMware vSphere environment.Ensure that the Dell PowerFlex SDC component is installed and running on ESXi hosts where the application VMs are hosted.Applications that are registered as Physical for Dell PowerFlex need to follow the below steps. Since SDC setup is done as root user, binaries like drv_cfg are not accessible for non-root users which are used in Application registration.
namei -l $(readlink -f /opt/emc/scaleio/sdc/bin/drv_cfg) groups <username> groupadd powerflex usermod -aG powerflex <username> groups <username> chgrp -R powerflex /usr/bin/emc chgrp -R powerflex /usr/bin/emc/scaleio/ chmod -R g+rx /usr/bin/emc/scaleio/ chgrp -R powerflex /opt/emc/scaleio chmod -R g+rx /opt/emc/scaleio chmod g+rx $(readlink -f /opt/emc/scaleio/sdc/bin/drv_cfg) namei -l $(readlink -f /opt/emc/scaleio/sdc/bin/drv_cfg)
Oracle Support for VMware Virtual Machines
For Oracle servers running as VMware virtual machines, UUID must be enabled to run Oracle-based backup functions. To enable: power off the guest machine through the vSphere client, then select the guest and click Edit Settings. Select Options, then General under the Advanced section. Select Configuration Parameters..., then find the disk.EnableUUID parameter. If set to FALSE, change the value to TRUE. If the parameter is not available, add it by clicking Add Row, set the value to TRUE, then power on the guest.
Oracle support for VMware virtual machines requires Oracle data and logs to be stored on VMDK virtual disks or physical RDMs. Virtual RDM disks are not supported. The VMDKs must stay on a datastore created on LUNs from supported Storage Systems. Similarly, the physical RDMs must be backed by LUNs from supported Storage Systems.
Note: For Oracle RAC clustered nodes running vSphere 6.5 or later, if an existing shared SCSI controller is not found, IBM Storage Defender Copy Data Management automatically enables the "multi-writer" sharing option for each shared virtual disk.
Restore Jobs
If the xfsprogs package version on the destination server is between 3.2.0 and 4.1.9, the restore process might fail when you restore a database or file system from an XFS file system. To resolve the issue, upgrade xfsprogs to version 4.2.0 or later.
Revert Jobs
Restrictions:
Oracle revert jobs are only supported for backups using the IBM Storage Virtualize for snapshot provider, Dell PowerMax and Dell PowerFlex storage providers.
When you create a job, you need to set the default revert action for the job. This behavior is controlled through the Revert Database option during the job creation process:
Note – 'Make Permanent' option will be disabled when Revert is enabled.
Restrictions:
Software
Python version 3.x must be installed. It might be necessary to add your python3 binary file location to the system PATH or to create a symbolic link. For example, if your python3 is installed at /opt/freeware/bin, you need to create a link as follows:
ln -s /opt/freeware/bin/python3 /usr/bin/python3On AIX systems, it might be necessary to rerun any AIX inventory jobs.
RHEL 8.x or later: Ensure that the util-linux package is up to date by running:
yum update util-linuxDepending on your version or distribution, the package might be named util-linux.
RHEL 8.x or later: A required Perl module, Digest:MD5, is not installed by default. Install the module by running:
yum install perl-Digest-MD5Linux only: If data stays on LVM volumes, ensure that the LVM version is 2.03.02 or later. To check the LVM version and if necessary to update the package, run:
lvm version
yum update lvm2Connectivity
To mount clones or copies of Oracle data, IBM Storage Defender Copy Data Management automatically maps and unmaps LUNs to the Oracle servers. Each server must be preconfigured to connect to the relevant Storage Systems at that site.
Authentication and Privileges
Authentication
For key-based authentication, ensure that the public SSH key is placed in the appropriate authorized_keys file for the IBM Storage Defender Copy Data Management agent user.
/home/<username>/.ssh/authorized_keysPrivileges
The IBM Storage Defender Copy Data Management agent user needs the following privileges:
Privileges to run commands as root and other users by using sudo. IBM Storage Defender Copy Data Management requires these privileges for various tasks such as discovering storage layouts and mounting and unmounting disks.
sudoers configuration must allow the IBM Storage Defender Copy Data Management agent user to run commands without a password.!requiretty setting must be set.oinstall.SYSDBA privileges for database instances. IBM Storage Defender Copy Data Management needs to run database tasks like querying instance details, hot backup, RMAN cataloging, and starting and stopping instances during recovery.
dba.SYSASM privileges, if Automatic Storage Management (ASM) is installed. IBM Storage Defender Copy Data Management needs to run storage tasks like querying ASM disk information, and renaming, mounting, and unmounting diskgroups.
asmadmin.ulimit -a as both the oracle user and the IBM Storage Defender Copy Data Management agent user and ensure that their settings are identical.For examples on creating a new user with the necessary privileges, see Sample Configuration in Oracle requirements.
Discovery
Oracle Home Discovery for Symbolic Links
IBM Storage Defender Copy Data Management discovers Oracle installations and databases by looking through the files /etc/oraInst.loc and /etc/oratab, as well as the list of running Oracle processes. When you connect to a database instance to discover its properties, IBM Storage Defender Copy Data Management connects by setting the ORACLE_HOME environment variable based on the path that was auto discovered.
In some cases, when Oracle databases are used in combination with SAP software for instance, a symbolic link to the Oracle Home path might be created. This link path can then be used by the database administrator to connect to the database.
Consider the following example where the real Oracle Home path can be /u01/app/oracle/product/19c/dbhome_1, while the symbolic link that points to it is /oracle/PRODDB/19c.
$ ls -l /oracle/PRODB
lrwxrwxrwx. 1 oracle oinstall 19c -> /u01/app/oracle/product/19c/dbhome_1When IBM Storage Defender Copy Data Management connects to the instance by using the real, auto-discovered path, queries against the database can fail due to the ORACLE_HOME environment variable being incorrectly set. To override the auto-discovered path and force IBM Storage Defender Copy Data Management to use the correct symbolic link path, a configuration file must be defined on each Oracle server where symbolic links are in use.
Create or edit if it exists a file named /etc/guestapps_oraHomes.conf. Insert into this file these entries:
# Define one entry per line.
# Each entry must be in the form: <instanceName> = <oraHomePath>
# Lines beginning with the '#' character are ignored.
PRODDB = /oracle/PRODDB/19c
TESTDB = /oracle/TESTDB/19cTo ensure that the configuration file is readable by the agent user, run the following command:
chmod 644 /etc/guestapps_oraHomes.confDatabase Discovery
IBM Storage Defender Copy Data Management discovers Oracle installations and databases by looking through the files /etc/oraInst.loc and /etc/oratab, and the list of running Oracle processes. If the files are not present in their default location, the "locate" utility must be installed on the system so that IBM Storage Defender Copy Data Management can search for alternative locations of these files.
IBM Storage Defender Copy Data Management discovers databases and their storage layouts by connecting to running instances and querying the locations of their data files, log files, and other files. In order for IBM Storage Defender Copy Data Management to correctly discover databases during cataloging and copy operations, databases must be in "MOUNTED," "READ ONLY," or "READ/WRITE" mode. IBM Storage Defender Copy Data Management cannot discover or protect database instances that are shut down.
Databases must use a server parameter file (spfile). IBM Storage Defender Copy Data Management does not support copy operations for databases that use a text-based parameter file (pfile).
ASM Disk Discovery
When IBM Storage Defender Copy Data Management mounts snapshots or clones of ASM disks, it configures the disks to set the appropriate permissions required to make them discoverable by ASM:
asmadmin. IBM Storage Defender Copy Data Management automatically discovers the appropriate owner and group information on each server.IBM Storage Defender Copy Data Management creates aliases or symbolic links with names that follow a consistent pattern. Ensure that ASM is able to discover the disks mapped by IBM Storage Defender Copy Data Management and update the ASM_DISKSTRING parameter to add this pattern.
Linux: IBM Storage Defender Copy Data Management creates udev rules for each disk to set the appropriate ownership and permissions. The udev rules also create symbolic links of the form /dev/ecx-asmdisk/<diskId> that point to the appropriate device under /dev.
To ensure that the disks are discoverable by ASM, add the following pattern to your existing ASM_DISKSTRING: /dev/ecx-asmdisk/*
AIX: IBM Storage Defender Copy Data Management creates a device node (by using mknod) of the form /dev/ecx_asm<diskId> that points to the appropriate hdisk under /dev. IBM Storage Defender Copy Data Management also sets the appropriate ownership and permissions for this new device.
To ensure that the disks are discoverable by ASM, add the following pattern to your existing ASM_DISKSTRING: /dev/ecx_asm*
Notes:
/dev/*), you might not need to update it.Sample Configuration
The following commands are examples for creating and configuring an operating system user that IBM Storage Defender Copy Data Management uses to log in to the Oracle server. The command syntax might vary depending on your operating system type and version.
Create the user that is designated as the IBM Storage Defender Copy Data Management agent user:
useradd -m cdmagentIf you use password-based authentication, set a password:
passwd cdmagentIf you use key-based authentication, place the public key in /home/cdmagent/.ssh/authorized_keys, or the appropriate file depending on your sshd configuration, and ensure that the correct ownership and permissions are set:
chown -R cdmagent:cdmagent /home/cdmagent/.ssh
chmod 700 /home/cdmagent/.ssh
chmod 600 /home/cdmagent/.ssh/authorized_keysAdd the user to the Oracle installation and OSDBA group:
usermod -a -G oinstall,dba cdmagentIf ASM is in use, also add the user to the OSASM group:
usermod -a -G asmadmin cdmagentusermod command.Place the following lines at the end of your sudoers configuration file, typically /etc/sudoers. If the existing sudoers file is configured to import configuration from another directory (for example, /etc/sudoers.d), you can also place the lines in a new file in that directory:
Defaults:cdmagent !requiretty
Defaults:cdmagent env_keep+="ORACLE_HOME"
Defaults:cdmagent env_keep+="ORACLE_SID"
cdmagent ALL=(ALL) NOPASSWD:ALLRelated Information
Product Synonym
BM Storage Defender CDM
Was this topic helpful?
Document Information
Modified date:
05 July 2026
UID
ibm17275580