Docstoc

ARKEIA FOR ORACLE'S RMAN

Document Sample
ARKEIA FOR ORACLE'S RMAN Powered By Docstoc
					ARKEIA
FOR
ORACLE’S RMAN




                Knox Software • Arkeia for Oracle’s RMAN • 1/15
Table of contents

Table of contents....................................................................................................... ........ 2
Introduction............................................................................................................... ........ 3
What is the Arkeia agent for Oracle RMAN?........................................................... ........ 3
How is Arkeia used?................................................................................................. ........ 3
Overview of Arkeia Oracle backup.......................................................................... ........ 4
Installation and preparation        ....................................................................................... ........ 7
Simplified Arkeia configuration............................................................................... ........ 8
Common Arkeia configuration................................................................................. ........ 8
Basic configuration for an Oracle backup                  ................................................................. ........ 8
Backup and restoration       .............................................................................................. ........ 10
Sample commented backup session.......................................................................... ........ 10
Backup example ....................................................................................................... ........ 11
Restoration example      .................................................................................................. ........ 12
Sample RMAN commands....................................................................................... ........ 13




                                                   Document version:
Title: Arkeia for Oracle RMAN                                                      Version: 2001-03-30 Internal rev. v3.0 B




                                                                                   Knox Software • Arkeia for Oracle’s RMAN • 2/15
1 • Introduction

  1.1 What is the Arkeia agent for Oracle RMAN?

     The Arkeia agent for Oracle RMAN is a software component used with the Arkeia
     backup system to provide comprehensive data storage management services to Oracle
     Database Servers, version 8.1.6 and greater. The Arkeia agent interacts with RMAN, the
     Oracle Recovery Manger, to allow the Oracle databases to be backed-up while they are
     being used. Oracle’s RMAN is available on the “8i” version of Oracle’s databases.

  1.2 How is Arkeia used?

     An Oracle backup or restoration is started by running the RMAN utility installed on
     the Oracle database server. During a backup, RMAN passes Oracle data and control
     information to the Arkeia agent, which, in turn, passes that information to Arkeia
     server, which saves the data on tape and maintains various control information. During
     the restoration operation, RMAN tells the Arkeia agent which data needs to be restored.
     The Arkeia agent then contacts the Arkeia server, which retrieves the requested data
     from tape. Finally, the data is sent back to RMAN, which writes it to disk as required.

     As part of an overall Oracle backup and restoration system, Arkeia provides:

       •Complete storage device and volume management services
       •Convenient tracking of the Oracle data on the storage volumes (tapes)
       •Management of Oracle backup data throughout a complete life cycle.




                                                         Knox Software • Arkeia for Oracle’s RMAN • 3/15
2 • Overview of Arkeia Oracle backup

     You need five major components to backup an Oracle database online:

       •The Arkeia backup server
       •The Arkeia administrator GUI
       •The Arkeia client agent
       •The Arkeia command line interface
       •The Arkeia for Oracle RMAN

     The Arkeia server component manages the storage devices and volumes (tape drives,
     libraries and tapes), maintains the index and control information required to track the
     Oracle data.

     The demonstration software, which can be freely downloaded from Knox Software web
     site (http://www.arkeia.com) requires that the Arkeia backup server, along with the
     storage device, (tape drive, etc.), must be installed on the same machine as the Oracle
     database.

     A network-enabled version is available. For more information on this version, please
     contact the Arkeia sales department at sales@Arkeia.com for additional information.

     The Arkeia administrator GUI is used to configure and manage the Arkeia backup
     server. With the GUI, it is possible to configure the storage devices, storage volumes and
     other options. It can also be used to monitor Oracle backup and restoration operations
     that are in progress.

     The Arkeia GUI is able to manage network connections. This allows a user to manage
     and monitor, both locally and remotely, the backup of an Oracle database.

     The Arkeia client and the Arkeia command line interface act as intermediaries between
     Arkeia for Oracle RMAN and the Arkeia backup server.

     The Arkeia agent communicates directly with Oracle’s RMAN to ease the transfer of
     data between the Oracle database and Arkeia during the backup and restoration opera-
     tions.

     The Arkeia server is used to configure and manage the storage devices and storage
     volumes connected to the Oracle Server. During a backup, the Arkeia server stores the
     Oracle data on storage volumes that are mounted in the devices. During a restoration,
     the Arkeia server retrieves the requested data from the appropriate storage volumes and
     passes it back to Oracle via the Arkeia command line, client, Arkeia agent and, ulti-
     mately, Oracle’s RMAN.

     Once the Oracle and Arkeia software have been loaded on to the machine and have
     been properly configured, Oracle RMAN can be used to launch backup and restoration
     actions. (Please refer to the documentation of Oracle’s recovery manager for specific
     instructions on how to use RMAN.)



                                                      Knox Software • Arkeia for Oracle’s RMAN • 4/15
    The following graphics will help you understand the global architecture of an Arkeia
    backup server.
               Oracle Server


  Database                         Recovery
                                    catalog


   Server                            RMAN


Oracle MM API




          Arkeia Oracle Agent




               Arkeia Backup                                                Tape
                  Server                                                    Drive

     Step 1:
     The Arkeia Server is warned, by the Arkeia Oracle Agent,
     that RMAN is going to launch a backup operation.




                                                   Knox Software • Arkeia for Oracle’s RMAN • 5/15
            Oracle Server


  Database                   Recovery
                              catalog


   Server                     RMAN


Oracle MM API



                                        Step 2:
                                        Through the Arkeia
        Arkeia Oracle Agent             Command Line and
                                        the Arkeia Client, the
                                        Arkeia Oracle Agent
                                        transfers the database
                                        information to the
         Arkeia Command
                                        Arkeia Backup Server.
               Line



             Arkeia Client




            Arkeia Backup                                      Tape
               Server                                          Drive




                                          Knox Software • Arkeia for Oracle’s RMAN • 6/15
3 • Installation and preparation

     Arkeia is designed using a client/server architecture and contains three main compo-
     nents: client, server and user interface. In order to run an Oracle backup, two additional
     components are required: the Arkeia command line interface and the Arkeia agent for
     Oracle RMAN.

     The installation order is:

       •Client
       •Server
       •GUI
       •Arkeia command line
       •Arkeia for oracle RMAN

     Please respect the installation order given above. Do not attempt to execute an Oracle
     backup unless a standard Arkeia backup has been successfully performed beforehand.

     Before an Oracle backup can be performed, the standard components of Arkeia must be
     installed, configured and tested. These components can be obtained from the CD-
     ROM or from our web site. Additionally, installation and configuration instructions are
     also available on the CD-ROM and on the web site.

     Note: all components are available on the Arkeia CD. However, the latest release of the
     software is available on the Knox Software web site, at the following address:

     www.arkeia.com/download.html


     The following commands allow the “root” user to easily install and configure the stan-
     dard Arkeia components:

     rpm   -Uvh   arkeia-client-<version>.i386.rpm
     rpm   -Uvh   arkeia-server -<version>.i386.rpm
     rpm   -Uvh   arkeia-gui -<version>.i386.rpm
     rpm   -Uvh   arkeia-arkc-<version>.i386.rpm


     Once these components have been installed on the Oracle backup server, please refer to
     the Arkeia User Guide to validate the installation of the software. Once this validation
     has been performed, proceed with the installation of the Arkeia client for Oracle
     RMAN, by entering the following command:

     rpm -Uvh arkeia-obk-<version>.i386.rpm


     To proceed with the Arkeia agent configuration, please read the README file located in:
     $knox/arkobk/README




                                                       Knox Software • Arkeia for Oracle’s RMAN • 7/15
4 • Simplified Arkeia configuration

  4.1 Common Arkeia configuration

     Start the Arkeia GUI by entering the command: ARKEIA         &


     The default login name is “root” with no password.

        Create a Pool

       •Click on the “ Tapes” menu and then on the “Pools Management” option.
       •Create a Tape Pool named, for instance, “Oracle Pool”.
       •Double click on the Oracle Pool to open it.

        Create tapes

       •Click on the “New” button to create some tapes.
       •Complete the various entry fields like in the same way you completed them during your ini-
        tial test of Arkeia.

        Create a tape drive

       •From the “Server Administration” screen, select the “Devices” menu and then the “Drives
        management” option.
       •Click on the “New” button to create a new drive.
       •Fill the entry fields as you did during your initial Arkeia testing.

        Create a drivepack

       •From the “Server Administration” screen, select the “Devices” menu, then the “Drivepacks”
        option.
       •Click on the “New” button to create a new drivepack.
       •Select the drive created above and click on the “OK” (checkmark) button to complete your
        drivepack.

     For more information on the installation and on the configuration of Arkeia, please
     refer to the Arkeia User Manual. You can find this manual on the World-Wide-Web at
     the following address: http://www.arkeia.com/manuals.html.

  4.2 Basic configuration for an Oracle backup

     At the current time, the “arkobk.param” file must be configured manually.

     Edit the file $KNOX/arkc/arkobk.param and, if needed, modify the following parame-
     ters:




                                                        Knox Software • Arkeia for Oracle’s RMAN • 8/15
                      List of arkobk parameters

   ARKOBK PARAMETER                                     SUGGESTED VALUE

 NODE                               Enter hostname between the “ ”
 LOGIN                              Enter “root” between the “ ”
 PASSWORD                           Enter the Arkeia root password between “ ”. The default pass-
                                    word is blank.
 DRIVEPACK                          Enter the drivepack name between the “ ”
 POOL                               Enter the pool name between the “ ”
 COMPRESSION                        Enter “ON” for client side software compression. Default value
                                    is “OFF”
 EMAIL                              Enter “YES” to enable the email feature.


The RMAN interface initiates all operations between the Oracle database and the
Arkeia RMAN Manager. These commands allow you to overwrite the default settings
that were previously entered in the $KNOX/arkobk.param file.

The Arkeia configuration for an Oracle backup is now complete. It is strongly advised
to configure an RMAN script at this point.




                                                  Knox Software • Arkeia for Oracle’s RMAN • 9/15
5 • Backup and restoration

     Oracle provides extensive documentation on the theory, the configuration and the usage
     of RMAN, the recovery manager, for both backup and restoration operations. Please
     refer to the Oracle documentation for additional information regarding the detailed
     usage of RMAN.

     Backup and restoration operations are initiated by the Oracle Recovery Manager.
     Backup operations can be started in several ways:

       •Interactively, using RMAN
       •Scheduled, via the “cron” UNIX daemon
       •Scheduled, via Oracle

  5.1 Sample commented backup session

     Below is a sample backup session that does the following:

       •Lines 2 and 3 allocate two separate channels, t1 and t2, to logical device sbt_tape.
        This allows Oracle’s RMAN and Arkeia for Oracle RMAN to perform a backup with two
        parallel data streams.

       •On lines 4 and 5, the Oracle database is told to send the data to the logical device called
        sbt_tape and to send vendor specific parameters to the Arkeia RMAN Manager:


        4742: set pool DAT_ECRIX
        4742: set drivepack DAT_ECRIX

        The POOL and DRIVEPACK values must have been previously defined using the Arkeia
        GUI. If these values are not defined, then the backup will end with an error. The Arkeia for
        RMAN software uses this information to establish proper communication between RMAN,
        the Arkeia client and the Arkeia backup server.

       •On line 6, the actual backup is started. By default, this is a full backup.
        The “%u” parameter is used to provide a unique identifier to Arkeia, so that the Oracle data
        can later be retrieved.

       •On lines 7 and 8, the previously allocated channels (t1 and t2) are released.

     Sample session:

     RMAN> run {
     2> allocate channel t1 type 'sbt_tape';
     3> allocate channel t2 type 'sbt_tape';
     4> send device type 'sbt_tape' '4742: set pool DAT_ECRIX';
     5> send device type 'sbt_tape' '4742: set drivepack DAT_ECRIX';
     6> backup database format '/oracle/backup/ORC2/%u';
     7> release channel t1;
     8> release channel t2;
     9> }




                                                         Knox Software • Arkeia for Oracle’s RMAN • 10/15
5.2 Backup example

   The following is an RMAN backup session. It uses two channels to backup the database
   ORC2.


   [oracle@saiph bin]$ ./rman nocatalog target sys/change_on_install@ORC2
   Recovery Manager: Release 8.1.5.0.0 - Production
   RMAN-06005: connected to target database: ORC2 (DBID=1082417414)
   RMAN-06009: using target database controlfile instead of recovery cat-
   alog
   RMAN> @/home/oracle/backup_database_using_2_drives.nk
   RMAN> run {
   2> allocate channel t1 type 'sbt_tape';
   3> allocate channel t2 type 'sbt_tape';
   4> send device type 'sbt_tape' '4742: set pool DAT_ECRIX';
   5> send device type 'sbt_tape' '4742: set drivepack DAT_ECRIX';
   6> backup database format '/oracle/backup/ORC2/%u';
   7> release channel t1;
   8> release channel t2;
   9> }
   RMAN-03022: compiling command: allocate
   RMAN-03023: executing command: allocate
   RMAN-08030: allocated channel: t1
   RMAN-08500: channel t1: sid=9 devtype=SBT_TAPE
   RMAN-08526: channel t1: Arkeia by Knox software
   (http://www.Arkeia.com)
   RMAN-03022: compiling command: allocate
   RMAN-03023: executing command: allocate
   RMAN-08030: allocated channel: t2
   RMAN-08500: channel t2: sid=8 devtype=SBT_TAPE
   RMAN-08526: channel t2: Arkeia by Knox software
   (http://www.Arkeia.com)
   RMAN-03022: compiling command: send
   RMAN-06421: sent command to channel: t1
   RMAN-06421: sent command to channel: t2
   RMAN-03022: compiling command: send
   RMAN-06421: sent command to channel: t1
   RMAN-06421: sent command to channel: t2
   RMAN-03022: compiling command: backup
   RMAN-03023: executing command: backup
   RMAN-08008: channel t1: starting full datafile backupset
   RMAN-08502: set_count=17 set_stamp=391109069 creation_time=01-MAR-00
   RMAN-08010: channel t1: specifying datafile(s) in backupset
   RMAN-08522:   input   datafile  fno=00003   name=/oracle/oradata/ORC2/
   rbs01.dbf
   RMAN-08522:   input   datafile  fno=00004   name=/oracle/oradata/ORC2/
   temp01.dbf
   RMAN-08522:   input   datafile  fno=00005   name=/oracle/oradata/ORC2/
   users01.dbf
   RMAN-08522:   input   datafile  fno=00006   name=/oracle/oradata/ORC2/
   indx01.dbf
   RMAN-08008: channel t2: starting full datafile backupset
   RMAN-08502: set_count=18 set_stamp=391109069 creation_time=01-MAR-00
   RMAN-08010: channel t2: specifying datafile(s) in backupset
   RMAN-08522:   input   datafile  fno=00001   name=/oracle/oradata/ORC2/
   system01.dbf
   RMAN-08011: including current controlfile in backupset
   RMAN-08522:   input   datafile  fno=00002   name=/oracle/oradata/ORC2/
   oemrep01.dbf
   RMAN-08013: channel t1: piece 1 created
   RMAN-08503: piece handle=/oracle/backup/ORC2/0hbkvmed comment=API Ver-
   sion 2.0,MMS
   Version 1.1.1.1
   RMAN-08525: backup set complete, elapsed time: 00:00:57
   RMAN-08013: channel t2: piece 1 created
   RMAN-08503: piece handle=/oracle/backup/ORC2/0ibkvmed comment=API Ver-
   sion 2.0,MMS




                                                 Knox Software • Arkeia for Oracle’s RMAN • 11/15
   Version 1.1.1.1
   RMAN-08525: backup set complete, elapsed time: 00:03:33
   RMAN-03022: compiling command: release
   RMAN-03023: executing command: release
   RMAN-08031: released channel: t1
   RMAN-03022: compiling command: release
   RMAN-03023: executing command: release

   RMAN-08031: released channel: t2
   RMAN>
   RMAN> **end-of-file**
   RMAN>


5.3 Restoration example

   The following command will start the restoration of the ORC2 database using RMAN:

   [oracle@saiph bin]$ ./rman nocatalog target sys/change_on_install@ORC2
   Recovery Manager: Release 8.1.5.0.0 - Production
   RMAN-06005: connected to target database: ORC2 (DBID=1082417414)
   RMAN-06009: using target database controlfile instead of recovery cat-
   alog
   RMAN> @/home/oracle/restore_database_using_2_drives.nk
   RMAN> run {
   2> allocate channel t1 type 'sbt_tape';
   3> restore database;
   4> recover database;
   5> release channel t1;
   6> }
   RMAN-03022: compiling command: allocate
   RMAN-03023: executing command: allocate
   RMAN-08030: allocated channel: t1
   RMAN-08500: channel t1: sid=10 devtype=SBT_TAPE
   RMAN-08526: channel t1: Arkeia by Knox software
   (http://www.Arkeia.com)
   RMAN-03022: compiling command: restore
   RMAN-03022: compiling command: IRESTORE
   RMAN-03023: executing command: IRESTORE
   RMAN-08016: channel t1: starting datafile backupset restore
   RMAN-08502: set_count=15 set_stamp=391111894 creation_time=01-MAR-00
   RMAN-08089: channel t1: specifying datafile(s) to restore from backup
   set
   RMAN-08523: restoring datafile 00003 to /oracle/oradata/ORC2/rbs01.dbf
   RMAN-08523:   restoring   datafile  00004   to   /oracle/oradata/ORC2/
   temp01.dbf
   RMAN-08523:   restoring   datafile  00005   to   /oracle/oradata/ORC2/
   users01.dbf
   RMAN-08523:   restoring   datafile  00006   to   /oracle/oradata/ORC2/
   indx01.dbf
   RMAN-08023: channel t1: restored backup piece 1
   RMAN-08511: piece handle=/oracle/backup/ORC2/0fbkvp6m params=NULL
   RMAN-08024: channel t1: restore complete
   RMAN-08016: channel t1: starting datafile backupset restore
   RMAN-08502: set_count=16 set_stamp=391111894 creation_time=01-MAR-00
   RMAN-08089: channel t1: specifying datafile(s) to restore from backup
   set
   RMAN-08523:   restoring   datafile  00001   to   /oracle/oradata/ORC2/
   system01.dbf

   RMAN-08523:   restoring   datafile  00002   to   /oracle/oradata/ORC2/
   oemrep01.dbf
   RMAN-08023: channel t1: restored backup piece 1
   RMAN-08511: piece handle=/oracle/backup/ORC2/0gbkvp6m params=NULL
   RMAN-08024: channel t1: restore complete
   RMAN-03022: compiling command: recover
   RMAN-03022: compiling command: recover(1)
   RMAN-03022: compiling command: recover(2)




                                                Knox Software • Arkeia for Oracle’s RMAN • 12/15
   RMAN-03022: compiling command: recover(3)
   RMAN-03023: executing command: recover(3)
   RMAN-08054: starting media recovery
   RMAN-08055: media recovery complete
   RMAN-03022: compiling command: recover(4)
   RMAN-03022: compiling command: release
   RMAN-03023: executing command: release
   RMAN-08031: released channel: t1
   RMAN> **end-of-file**


5.4 Sample RMAN commands

       Example 1:

   This script is supposed to perform a total backup. However, it will fail because it speci-
   fies an invalid parameter on the last send device command. The Knox specific parame-
   ter: set retention 545544:W is invalid. This exceeds the maximum retention period
   in weeks that Arkeia is designed to manage.

   Therefore this backup will end with an error.

   run {
   allocate channel t1 type 'sbt_tape';
   send device type 'sbt_tape' '4742: set pool ECRIX';
   send device type 'sbt_tape' '4742: set drivepack ECRIX';
   send device type 'sbt_tape' '4742: set retention 454544:W';
   backup database;
   release channel t1;
   }


       Example 2:

   The database is backed up using two parallel streams of data: each stream is sent to a dif-
   ferent physical device.

   Please note the use of the “send    channel”    command instead of the “send           device”
   command.

   run {
   allocate channel t1 type 'sbt_tape';
   allocate channel t2 type 'sbt_tape';
   send channel t1 '4742: set pool ECRIX';
   send channel t1 '4742: set drivepack ECRIX';
   send channel t1 '4742: set retention 3:M';
   send channel t2 '4742: set pool FILE';
   send channel t2 '4742: set drivepack FILE';
   send channel t2 '4742: set retention 2:W';
   backup database;
   release channel t1;
   release channel t2;
   }




                                                     Knox Software • Arkeia for Oracle’s RMAN • 13/15
   Example 3:

The database is backed up using two parallel processing streams of data: both streams of
data are sent to the same storage device.

run {
allocate channel t1 type 'sbt_tape';
allocate channel t2 type 'sbt_tape';
send device type 'sbt_tape' '4742: set pool FILE';
send device type 'sbt_tape' '4742: set drivepack FILE';
send device type 'sbt_tape' '4742: set retention 2:W';
backup database;
release channel t1;
release channel t2;
}


   Example 4:

The same database is backed up twice during the execution of the RMAN script.

run {
allocate channel t1 type 'sbt_tape';
send device type 'sbt_tape' '4742: set          pool ECRIX';
send device type 'sbt_tape' '4742: set          drivepack ECRIX';
send device type 'sbt_tape' '4742: set          retention 2:W';
backup database;
release channel t1;
allocate channel t1 type 'sbt_tape';
send device type 'sbt_tape' '4742: set          pool ECRIX';
send device type 'sbt_tape' '4742: set          drivepack ECRIX';
send device type 'sbt_tape' '4742: set          retention 2:W';
backup database;
release channel t1;
}


   Example 5:

Arkeia’s software compression is turned on, with the command “set              compression
on”.


run {
allocate channel t1 type 'sbt_tape';
send device type 'sbt_tape' '4742: set pool ECRIX';
send device type 'sbt_tape' '4742: set drivepack ECRIX';
send device type 'sbt_tape' '4742: set compression on';
backup database;
release channel t1;
}


   Example 6:

The database is restored and then recovered.

run {
allocate channel t1 type 'sbt_tape';
restore database;
recover database;
release channel t1;
}




                                                Knox Software • Arkeia for Oracle’s RMAN • 14/15
Knox Software • Arkeia for Oracle’s RMAN • 15/15

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:38
posted:1/10/2012
language:English
pages:15