Setting up a schedule on the IBM Storage Protect server

Define a schedule on the IBM® Storage Protect server to automatically run online backups of Oracle server databases.

Before you begin

Ensure that your system meets the minimum hardware, software, and operating system requirements. For more information, see Data Protection for Oracle installation

On a Solaris SPARC operating system or on a 64-bit version of HP-UX Itanium operating system, use the latest compatible version of the IBM Storage Protect BA client along with the latest versions of Data Protection for Oracle and IBM Storage Protect API.

Procedure

To set up a schedule on the IBM Storage Protect server:

Define the following schedule on the IBM Storage Protect server. You can enter the command on the IBM Storage Protect server console or on an administrative client. The administrative client does not have to be running on the same system as the IBM Storage Protect server.

  define schedule PolicyA1 daily_orcbkup description="08Daily Online DB Backup"
  action=command objects="/usr/tivoli/tsm/client/oracle/sched/schedbkdb.scr"
  starttime=21:00 duration=15 durunits=minutes period=1 perunits=day
  dayofweek=any

define schedule PolicyA1 daily_orcbkup description="07Daily Online DB Backup"
action=command objects="C:\Program Files\Tivoli\TSM\AgentOBA64\sched
\orcsched.cmd"
starttime=21:00 duration=15 durunits=minutes period=1 perunits=day
dayofweek=any

The following message must display before you proceed to the next step:

  ANR2500I Schedule daily_orcbkup defined in policy domain PolicyA1.

Issue the following command to associate the Data Protection for Oracle node to the backup schedule defined in step 1:
```
  define association PolicyA1 daily_orcbkup NodeA1
```
The following message must display before you proceed to Setting up a schedule on the client machine NodeA1:
```
  ANR2510I Node NodeA1 associated with schedule orc_dailybkup 
           in policy domain PolicyA1.
```

Results

A backup schedule is now defined on the IBM Storage Protect server.
The backup schedule runs the scheduler backup script schedbkdb.scr. The backup scripts run the command script mysched.scr, which runs the RMAN backup script bkdb.scr in the /home/oracle/sched directory.
The backup schedule runs the command file orcsched.cmd, in the C:\Program Files\Tivoli\TSM\AgentOBA64\sched\ or c:\progra~1\tivoli\tsm\agentoba64\sched\ directory.
The backup runs daily around 9:00 PM.
The backup schedule can start on any day of the week.
You can run the IBM Storage Protect query schedule and query association commands to confirm that the schedule and node association are set correctly.