Configuration with default settings

Edit online

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.

About this task

Use the instructions to configure Data Protection for Oracle. Change the listed installation paths and library extensions according to the operating system you are using.

See Configuring Data Protection for Oracle for detailed instructions on how to customize Data Protection for Oracle for your environment and processing needs.

Procedure

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
Copy the tdpo.opt.smp file to tdpo.opt.
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>
```
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.
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 Storage 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 Storage 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 Storage 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.
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 Storage 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 Storage Protect options in the client options file.
Register the node to the IBM Storage 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.
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/bin64 and /usr/tivoli/tsm/client/api/bin64 directories.
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.
Run the tdpoconf showenvironment command to view and confirm your configuration.

For more information about this command, see showenvironment command.
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.
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.