Oracle Database Backup

Catalogic DPX offers a comprehensive, application-aware backup and recovery solution for Oracle Database environments, ensuring the protection and availability of critical database information. Due to the complexity of Oracle databases, the information in this section is for an Oracle database administrator to use. Also, because of the breadth of functionality surrounding Oracle databases, this section provides some examples of the functions that can be performed and some commands that can be used; it is not meant to be a complete and comprehensive Oracle database administrators guide. An Oracle database administrator brings their knowledge and experience to elaborate further on this documentation. Refer to the Oracle® Database Backup and Recovery User’s Guide at Oracle Documentation.

Note. For DPX file-level support, refer to the discussion on Media Manager in the Oracle Database Backup and Recovery User’s Guide at Oracle Documentation.

Prerequisites for Oracle Database Backup

Before running an Oracle Database backup, the following conditions must be met.

• Install DPX Client on the machine where the Oracle Database is running.

• Configure DPX Client to have access to the Oracle Database.

• During backup and restore Oracle must be running in ARCHIVELOG mode.

• The Oracle archive destination variable must be set to a specific location, not the default. The following example shows a setting for a specific location on UNIX or Linux:

  SQL> alter system set log_archive_dest_1='location=/db/DB1_arc';

  SQL> archive log list;

  SQL> alter system switch logfile;

• On each Oracle node, after Catalogic DPX has been installed, OracleConfig must be run.

• TNS Listener process must be running for all operations.

• iSCSI Initiator must be installed for all operations that require Instant Access, including RMAN cataloging.

• The Catalogic DPX Block Data Protection for Oracle requires the installation of the JDBC Driver. You will be prompted if the driver is not installed during the configuration of DPX Client for Oracle.

• If you expect to do database cloning, the source database must use server parameter file during backup.

• Oracle raw volumes, RAC (Real Application Clusters) and ASM (Automated Storage Management) configurations are not supported.

• Clusters are not supported for Oracle with the Catalogic DPX Block Data Protection.

• The Catalogic DPX Block Data Protection for Oracle is not supported for Windows client nodes running ReFS file systems.

Restrictions. Support for backup and recovery of Oracle Databases to a NetApp Clustered Data ONTAP destination is limited.

See also. For the latest system compatibility details regarding supported hardware, file systems, applications, operating systems, and service packs, see DPX 4.12 Compatibility Guide.