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

Note: If you are using Linux as your operating system, this link is not required.

1. Depending on your operating system, change to one of the following directories:
   • AIX® 64-bit operating system: /usr/tivoli/tsm/client/oracle/bin64
   • Linux operating system:/opt/tivoli/tsm/client/oracle/bin64
   • Windows 64-bit Server system: C:\Program Files\Tivoli\TSM\AgentOBA64
2. Copy the tdpo.opt.smp file to tdpo.opt.
3. Edit the tdpo.opt file to include these options:

   For UNIX and Linux, these instructions use AIX 64-bit as the example operating system.

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

4. For Windows, these instructions use a 64-bit Windows Server system as the example operating system.

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

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

5. Create a dsm.opt file as follows: In the /usr/tivoli/tsm/client/oracle/bin64 directory, create a dsm.opt file, then edit the file to include the following server stanza:

   servername TSMOracle

   For more information about this option and the dsm.opt file, see Define IBM Spectrum Protect options in the client options file.

   In the C:\Program Files\Tivoli\TSM\AgentOBA64 directory, copy the dsm.smp file to dsm.opt. Edit the dsm.opt file to include these options:

   commethod TCPip
   tcpserveraddress x.x.x.x
   passwordaccess generate
   nodename hostname_oracle

   Replace x.x.x.x with the IP address of the IBM Spectrum Protect server to which Data Protection for Oracle backs up data.

   For more information about these options and the dsm.opt file, see Define IBM Spectrum Protect options in the client options file.

   Tip: For Oracle 12c Release 1 (12.1) and later releases, the Oracle home user that is specified on installation of the Oracle database must be granted sufficient permission to access the Windows registry. Otherwise, Data Protection for Oracle operations might fail.
6. Change to the /usr/tivoli/tsm/client/api/bin64 directory. Edit the dsm.sys file to include another server stanza with the following options:

   servername TSMOracle
   tcpserveraddress site.xyzinc.com
   tcpport 1500
   nodename NodeA1
   passwordaccess generate
   passworddir /home/oracle

   Replace site.xyzinc.com with the IP address of the IBM Spectrum Protect server to which Data Protection for Oracle backs up data. Replace /home/oracle with the Oracle database instance user's home directory.

   For more information about these options and the dsm.sys file, see Define IBM Spectrum Protect options in the client options file.

7. Register the node to the IBM Spectrum Protect server with the following command:

   REG nodename NodeA1 hostname_oracle password maxnummp=n

   

   REG nodename NodeA1 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.

8. Make sure that the <oracle user> has the following permissions:
   • Read and Write permissions to the following directories:
     • C:\Program Files\Tivoli\TSM\AgentOBA64 directory
     • tdpoerror.log and the directory where it is stored
   
   • Read (r) permission to /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
9. Run the tdpoconf password command as the <oracle user> to generate the password file.

   For more information about this command, see password command.

   Enter the password from Step 7 three times.
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\AgentOBA64\tdpo.opt) parameter specified. For example:

    run
    {
       allocate channel t1 type 'sbt_tape' parms 
           'ENV=(TDPO_OPTFILE=C:\Program Files\Tivoli\TSM\AgentOBA64\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.