4 4 3:Oracle Requirements and Configuration

From SEPsesam
Jump to: navigation, search
Other languages:
Deutsch • ‎English

Copyright © SEP AG 1999-2021. All rights reserved.

Any form of reproduction of the contents or parts of this manual is allowed only with the express written permission from SEP AG. When compiling and designing user documentation SEP AG uses great diligence and attempts to deliver accurate and correct information. However, SEP AG cannot issue a guarantee for the contents of this manual.

Draft.png WORK IN PROGRESS
This page is a draft. Treat the information on this page with caution as it may be incomplete.


Docs latest icon.png Welcome to the latest SEP sesam documentation version 4.4.3/4.4.3 Beefalo V2. For previous documentation version(s), check Oracle archive.


Overview

The procedures and features explained herein provide only information about the SEP sesam-specific parts of Oracle configuration. For detailed information on Oracle-specific backup and recovery, see Oracle database documentation.

The SEP sesam backup module for Oracle integrates Oracle Recovery Manager (RMAN) with SEP sesam to efficiently back up and restore Oracle databases online. It supports Oracle single-instance configurations and multi-instance configurations – Real Application Clusters (RAC), Oracle Server configurations that use Automatic Storage Management (ASM) as well as Oracle Data Guard environment. ASM may also be used as a backup destination for RMAN backup to DISK. When using RMAN in a Data Guard environment, a recovery catalog is required to back up a physical standby database and store information about Oracle databases.

Oracle provides a Media Management Layer (MML) for saving Oracle databases to SEP sesam Server. The MML API gives the Recovery Manager (RMAN) access to the backup application. For Oracle, SEP sesam represents a media management utility. It handles media and devices and loads, unloads and labels media.

RMAN manages the target database (the database containing the control files, data files and optional archived redo logs that are being backed up or restored) and all Oracle server processes on the target database. In case of using ASM, keep in mind that this is a filesystem and volume manager that also need to be backed up regularly.

System requirements

Installation settings

The following are Oracle default installation settings. You can adjust the paths and variables according to your needs.

ORACLE SID=mydb
ORACLE BASE=/opt/oracle
ORACLE HOME=/opt/oracle/product/oracle
$ORACLE HOME/bin is in the search path
Information sign.png Note
The library file libobk.so (Linux) or orasbt (Windows) is installed in the <sesam_install>/bin/sesam directory as a part of the SEP sesam Client package.

Configuring Oracle

You have to configure the Oracle extension on the target Oracle server. Depending on your operating system (Linux/Unix or Windows), proceed to the relevant section below.

Linux/Unix configuration

  1. Login as Oracle user.
  2. Create a new directory sob in $ORACLE HOME.
  3. Create a symbolic link in $ORACLE HOME/lib to the library file libobk.so, which resides in <sesam_install>/bin/sesam. If the file already exists, you must rename it.
oracle@oraclesrv:/> cd $ORACLE_HOME
oracle@oraclesrv:/product/oracle> mkdir sob
oracle@oraclesrv:/product/oracle> ln -s /opt/sesam/bin/sesam/libobk.so sob/
oracle@oraclesrv:/product/oracle> ln -s /opt/sesam/bin/sesam/libobk.so lib/

Windows configuration

As of SEP sesam Jaglion, OpenSSL 1.1.1 is also used for Oracle orasbt.dll on Windows. The following procedure describes version-specific steps.

≥ SEP sesam Jaglion (5.0)

  1. Go to the <ORACLE HOME>\bin directory and rename the file orasbt.dll, if it exists.
  2. This step is only required for v. < Oracle 19c : Copy vcruntime140.dll from the <sesam_install>/bin/sesam directory to the <ORACLE HOME>\bin directory.

≤ SEP sesam Beefalo V2 (4.4.3.xx)

  1. Go to the <ORACLE HOME>\bin directory and rename the file orasbt.dll, if it exists.
  2. Copy the SEP sesam file orasbt.dll from the <sesam_install>/bin/sesam directory to the <ORACLE HOME>\bin directory.
  3. Encryption is enabled as of SEP sesam version 4.4.2. Copy msvcr90.dll, msvcr100.dll, cm_crypt.dll, libeay32.dll, ssleay32.dll and md5.dll from the <sesam_install>/bin/sesam directory to the <ORACLE HOME>\bin directory.

Add the Oracle client to SEP sesam environment

Configure a new client by adding it to the SEP sesam environment: Main selection -> Components -> Topology -> New client -> add your Oracle client. For details, see Configuring Clients.

Setting remote command permissions

By default, the SEP sesam Server has no rights to execute commands remotely on a SEP sesam Client, e.g., on an Oracle server. You have to specify a user in the sesam_cmdusers.allow file to run a command. For details on Windows-specific configuration of command events, see Creating a Command Event.

  1. To assign the proper permissions for executing commands, copy the file sesam_cmdusers_allow from the template directory on the SEP sesam Client to the /etc directory on the Oracle server.
  2. Example:

    cp /opt/sesam/skel/templates/sesam_cmdusers.allow /etc
    
  3. Edit the file to set the appropriate values. You will have to define the user that will execute the command, followed by the respective command.
  4. Example (referencing the example above):

    oracle /opt/oracle/product/10.2/db_1/sob/sbc_oracle_rman.sh
    


See also

Oracle BackupOracle RestoreOracle Duplicate Database