Configuration with default settings

Use the Data Protection for Oracle quick configuration option to quickly configure with default settings and minimal configuration tasks. Setup time is minimized and you proceed quickly to a state where you can begin backing up your Oracle databases.

Before you begin

Install Data Protection for Oracle. For detailed installation instructions, see Data Protection for Oracle installation.

After Data Protection for Oracle is installed, make sure that the following link exists:

$ORACLE_HOME/lib/libobk.a -> /usr/lib/libobk64.a

1. Change to the /usr/tivoli/tsm/client/oracle/bin64 directory and copy the tdpo.opt.smp file to tdpo.opt. Edit the tdpo.opt file to include these options:

   dsmi_orc_config /usr/tivoli/tsm/client/oracle/bin64/dsm.opt
   dsmi_log <directory with write permissions>

   For more information about these options, see Available Data Protection for Oracle options.

2. Change to the C:\Program Files\Tivoli\TSM\AgentOBA directory and copy the tdpo.opt.smp file to tdpo.opt. Edit the tdpo.opt file to include these options:

   dsmi_orc_config C:\Program Files\Tivoli\TSM\AgentOBA\dsm.opt
   dsmi_log C:\Program Files\Tivoli\TSM\AgentOBA

   For more information about these options, see Available Data Protection for Oracle options.

3. In this directory, create a dsm.opt file. Edit the dsm.opt file to include the following server stanza:

   Servername tdpo

   For more information about this option and the dsm.opt file, see Define Tivoli Storage Manager options in the client options file.

4. In this directory, copy the dsm.smp file to dsm.opt. Edit the dsm.opt file to include these options:

   COMMMethod TCPip
   TCPServeraddress x.x.x.x
   PASSWORDAccess generate
   NODename hostname_oracle

   Replace x.x.x.x with the IP address of the Tivoli Storage Manager server to which Data Protection for Oracle backs up data.

   For more information about these options and the dsm.opt file, see Define Tivoli Storage Manager options in the client options file.

5. Change to the /usr/tivoli/tsm/client/api/bin64 directory and create a symbolic link to /usr/tivoli/tsm/client/ba/bin/dsm.sys. Edit the dsm.sys file to include another server stanza with the following options:

   SErvername tdpo
   COMMMethod TCPip
   TCPServeraddress x.x.x.x
   PASSWORDAccess generate
   passworddir /home/<oracle user>
   nodename TDPONodeName

   Replace x.x.x.x with the IP address of the Tivoli Storage Manager server to which Data Protection for Oracle backs up data. Replace <oracle user> with the Oracle user ID of the target Oracle database instance.

   For more information about the dsm.sys file, these options, and their relationship with Data Protection for Oracle, see Define Tivoli Storage Manager options in the client options file.

6. Register the node to the Tivoli Storage Manager server with the following command:

   REG NODE hostname_oracle password maxnummp=n

   

   REG NODE hostname_oracle password maxnummp=n

   Where hostname is the name of the system that Data Protection for Oracle is installed, password is the password for this node, and n is equal to the number of channels that you are planning to use.

7. Make sure that the <oracle user> has the following permissions:
   • Read and Write permission to the C:\Program Files\Tivoli\TSM\AgentOBA directory.
   • Read and Write permissions to tdpoerror.log and the directory where it is stored.
   • Read (r) permission to the /usr/tivoli/tsm/client/oracle/bin64 and /usr/tivoli/tsm/client/api/bin64 directories.
   • Read permission (r-) to the tdpo.opt, dsm.opt, and dsm.sys files in the /usr/tivoli/tsm/client/oracle/bin and /usr/tivoli/tsm/client/api/bin directories.
8. Change to the /usr/tivoli/tsm/client/oracle/bin64 directory and run the tdpoconf password command as the <oracle user> to generate the password file.

   For more information about this command, see password command.

9. Change to the C:\Program Files\Tivoli\TSM\AgentOBA directory and run the tdpoconf password command as the <oracle user> to generate the password file. Enter the password from Step 6 three times.

   For more information about this command, see password command.

10. Run the tdpoconf showenvironment command to view and confirm your configuration.

    For more information about this command, see showenvironment command.

11. As <oracle user>, run the RMAN backup script with the ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt) parameter specified. For example:

    run
    {
       allocate channel t1 type 'sbt_tape' parms 
                'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
       
       backup
          filesperset 5
          format 'df_%t_%s_%p'
          (database);
    
       }

    Note, the allocate channel entry is divided on two lines after the parms option to accommodate page formatting.

    For more information about RMAN backup scripts, see RMAN and Data Protection for Oracle.

12. As Oracle user, run the RMAN backup script with the ENV=(TDPO_OPTFILE=C:\Program Files\Tivoli\TSM\AgentOBA\tdpo.opt) parameter specified. For example:

    run
    {
       allocate channel t1 type 'sbt_tape' parms 
           'ENV=(TDPO_OPTFILE=C:\Program Files\Tivoli\TSM\AgentOBA\tdpo.opt)';
       
       backup
          filesperset 5
          format 'df_%t_%s_%p'
          (database);
    
      }

    Note, the allocate channel entry is divided on two lines after the parms option is specified to accommodate page formatting.

    For more information about RMAN backup scripts, see RMAN and Data Protection for Oracle.