SEP sesam Extension for Oracle 8i/9i/10g/11g on Linux, Unix and Windows

(C)SEP AG

Copyright 1999-2011 by SEP AG. 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.

Introduction

The SEP sesam online module for Oracle/RMAN provides a Media Management Library (MML) for saving data from Oracle databases to a SEP sesam Server. The API of MML is specified by Oracle to give the Recovery Manager (RMAN) access to a backup application. SEP sesam will manage the whole backup media handling like loading the correct tapes, whereas RMAN decides which data has to be saved or recovered. This document provides information about the Sesam specific parts of Oracle backups. It’s not an Oracle/RMAN administration guide. Please read the documentation of RMAN to get familiar with Oracle’s backup and recovery concepts and tools.

System Requirements

• Oracle 8i/9i/10g/11g on Linux, AIX, Solaris and Windows
• SEP sesam Version >= 3.4 (incl. DB-Online-Module for Oracle 8/9/10/11)
• Standard SEP sesam Backup Client installed
• File system backups should work with this SEP sesam Client
• An already installed oracle server with a running Oracle application and running database
• For Oracle online backups, the database has to run in Archive Log mode

Please consult the Oracle administration guide. For installation we assume the following environment. Please adjust the paths and variables according to your needs.

• SEP sesam Client for Linux/Windows:

http://download.sep.de/extensions/databases/oracle/

Check and set up Oracle database archivelog mode

• Start sqlplus from the console with Oracle database admin credentials:

• Check the archivelog mode for online backup:

If the database log mode show ARCHIVELOG then a Oracle RMAN online backup is possible. If not the archivelog mode has to be switched on. For that the database has to be shutdown, first:

• Shutdown the database MYDB:

• Start the database and set it to Mount status:

• Switch on archivelog mode:

• Bring the database online:

Again, you can check the archivelog mode using the appropriate SQL command above.

Installation on Linux or Unix

• First verify that the standard SEP sesam Backup Client is already installed
• File system backup should work with this SEP sesam Client
• Login as oracle user
• Create a new directory sob in $ORACLE HOME
• Unpack the file <OS> sob x.x.x.x.tgz there (or sesam-oracle-client<version>.tar.gz for Linux based systems)
• Create a symbolic link in $ORACLE HOME/lib to the unpacked library file libobk.so. If file already exists, rename it first.

Starting with Oracle 9i the Oracle kernel commonly must not be re-linked any more.

Installation on Windows

• verify that the standard Sesam Backup Client is already installed
• rename an already existing file ”orasbt.dll” in <ORACLE HOME>\bin directory.
• copy the Sesam file ”orasbt.dll” there.

The database has to be restarted to activate the new DLL.

Complete function test by sbttest program

By using the Oracle program sbttest you can test complete functionality of libobk.so, without interfering with running databases. libobk.so is only available since Oracle version 10g under Windows. For this following environment variables have to be set:

• SESAM SERVER=<Name of SEP sesam Server>
• SESAM JOB=<Jobname of Oracle backup> Name of an already configured task on SEP sesam Server with task type Oracle
• SESAM POOL=<Media pool name> Name of a already configured media pool on SEP sesam Server

If the test fails, you will find the SEP sesam specific trace messages in sbttest.log.

Configuration

RMAN backup

This chapter only explains the SEP sesam specific parts of Oracle RMAN. It’s not a RMAN administration guide. It’s absolutely necessary to consult the Oracle RMAN documentation for setting up a correct backup strategy. The following example script performs a full database backup:

The script is doing the following:

1. Login to target database (database to be saved)

2. Open a backup channel (For parallel backups more channels can be allocated)

• SEP sesam specific parameters

• (*) = mandatory parameters
• format identifier. The format specifier must result in a unique id. Oracle and SEP sesam using this id to identify the correct saveset during restore. Oracle guarantees that the combination of %d%u is unique.

3. include 100 files in one saveset

4. Release the backup channel

When this script is executed with rman cmdfile ora full.rman, the following appears:

SEP sbc Oracle client Extension

The archive <OS> sob 3.0.x.x.tgz file contains the SEP module sbc Oracle client. This module is a shell script, which may be called from SEP sesam as a SEP sesam Command Event. Please take a look into SEP sesam Administration documentation for further information about SEP sesam command events. This wrapper script creates a RMAN script with the given arguments and executes RMAN with the generated script.

Usage: ./sbc_oracle_rman.sh -b|r <-l level> -T <TargetDBS> -R <Catalog> -S <SesamServer> \ -j <SesamJob> -m <Mediapool> -o <option> -p <Number of streams> <TableSpace> Arguments: -b: Backup operation. By default, this is a full, online, single channel backup -r: Restore operation. By default, this is a full online, single channel restore. HINTS: Before the restore the database must be set to the required state, e.g. "SHUTDOWN; STARTUP MOUNT;" After restore an "ALTER DATABASE OPEN RESETLOGS;" may be necessary. -l <copy|full|diff|incr|arch>: Backup level copy, full, diff, incr and Archivelog Backup level may be combined with archivelog backup, e.g. -l copy_arch -o {option}: The following options are supported: delete Delete archivelogs after backup delete_later Delete archivelogs when successfully backed up 3 times offline WARNING: This option will automatically SHUTDOWN the database before and STARTUP after the backup! controlfile Restore controlfile with rman catalog controlfile_DBID={DBID} Restore controlfile without rman catalog. Needs DBID recover Recover after restore until={YYYYMMDD-HH:MM:SS} Point-in-time recover with until time -T <Target database connect string>: Default: ORACLE_SID -R <Recovery catalog connect string>: Default: NoCatalog -C <SesamServer>: SEP sesam Server host name -S <TapeServer>: Tape Server host name -j <SesamJob>: SEP sesam Job name, under which the backup is running -v [0|1]: debug on (set -x) -m <pool name>: SEP sesam media pool to use for the backup -p <number> defines the number of backup channels <TableSpace> defines a single tablespace to backup or restore. If this is not given, a backup/restore of the whole database is done

Examples:

• Level 0 Backup of the SID orcl to the SEP sesam Server smsrv to the already configured task orax10_DB-orcl to mediapool VTD1 with Recovery Catalog RCVCAT

• Archive log backup of SID prod to Sesam Server backupsrv to the already configured task dbsrv_ora-prod to mediapool DAY with using Sesam drive 5 and without using a Oracle Recovery Catalog

• Full restore of the database prod with automatic recovery from Sesam Server smsrv and Sesam task orax10_DB-prod from mediapool DISK

1. At first shutdown the database with the oracle management tools

2. Mount the database

3. Restore the database

4. Open the new incarnation of the database

• Point-In-Time-Recovery to time February, the 2nd 2011 of database fanta with automatic recovery. Connect to the preconfigured SEP sesam task dbserver_ora-fanta in the SEP sesam GUI and using the Recovery Catalog RCAT

1. At first shutdown the database by oracle management tools

2. Mount the database

3. Restore the database

4. Open the new incarnation of the database

Create an Oracle task

In case of an Oracle backup the SEP sesam Server works as media manager. Oracle RMAN starts the backup and sends the data to the destination referenced to the given parameter of the SEP sesam environment.

Example with following values:

• Create task of the Oracle backup client orax10, define the taskename and set the appropriate Oracle database name (SID) as source:

Create a Sesam command event

It's useful to start the command sbc_oracle_rman.sh on the Oracle server remote by a Sesam schedule. To configure this, you have to create a schedule first:

After <OK>, right mouse click and select New command event.

In the dialog click the button <List> and the next window will be opened. To create e new command choose the button <New> and fill all fields with the appropriate values.

Name

Name of the command event

Client

Select the hostname of the Oracle server from list.

User

Enter the username, who should perform the command with his rights on the Oracle Server

Command

Enter the full qualified command, which should be executed on the Oracle Server

Then commit the command definition with the button <Save>. Then assign this command to the command event by button <UseIt>. The dialog below shows the complete definition. Commit the configuration with <OK>.

Set remote command permissions

As default the SEP sesam server has no rights to execute commands remote on a backup client (here the Oracle server). To give the appopriate permissions for needed command it is neccessary to copy the file sesam_cmdusers_allow from the template directory of the Sesam Client to the /etc driectory of the client (Oracle server). After that adapt the file with appropriate values. You have to set the user who has to execute the command and behind it separated by a blank the full qualified command.

Example:

Edit the file and enter the following line (referencing to the example above):

Further Links/Literature

For further reading on the topic we recommend the following books:

• Download SEP sesam Extension for Oracle
• SEP Oracle Whitepaper
• SEP sesam Oracle Administration Guide (PDF)
• Oracle8i Backup & Recovery
  by Rama Velpuri, Anand Adkoli, George Williams 1st Edition, November 2000 Osborne - McGraw-Hill, ISBN: 0072127171
• Oracle9i RMAN Backup & Recovery
  by Robert G. Freeman, Matthew Hart Configure and Use Oracle Recovery Manager Tutorial for Users, Intermediate and Advanced Level Osborne - McGraw-Hill, ISBN: 0-07-222662-5