Listing Oracle RMAN channel configurations with schedulershow

Ops Center Protector Oracle Application Guide

Version
7.8.x
Audience
anonymous
Part Number
MK-99PRT003-10
schedulershow is a CLI tool that is used to aid the Oracle database administrator to configure Oracle RMAN to save and restore data using a datastore managed by Ops Center Protector. It provides the following functionality.
  • List the Oracle RMAN dataflows active on the current node
  • Create a sample RMAN channel definition for a dataflow operation

In order for a node to store or access any data in a Protector managed datastore using Oracle RMAN, the node has to be part of a dataflow and granted access using the access operation. Once the dataflow is compiled and distributed, it can be listed with schedulershow and Oracle RMAN can access it using an SBT channel.

Table. Command line options
Abbreviated Argument Full Argument Description
-h --help Display help.
-c ---config <trigger> Display RMAN channel configuration for a dataflow. The command provides a list of valid triggers when running the it without parameters..

Usage Example

List all Oracle RMAN dataflows active on this node

app/bin/schedulershow

Application DataFlow Source OperationName Storage Trigger

Oracle mysampledf1 myOracleNode Access myRepository 1f04eeec33b10190b79ea6d47a65f3943f5a9de0c1a5d1557afeb420ea604046

Oracle Demo2 myOracleNode Access myRepository 6e7b941d5e73ec5a3ce72b64e70c36c56e6d12f76a379d0982d130d1b505a895

Get the Oracle RMAN channel definition for a dataflow

app/bin/schedulershow -c 1f04eeec33b10190b79ea6d47a65f3943f5a9de0c1a5d1557afeb420ea604046

# Application = Oracle

# DataFlow=mysampledf1

# Source=myOracleNode

# OperationName=Access

# Storage=myRepository

# Trigger=1f04eeec33b10190b79ea6d47a65f3943f5a9de0c1a5d1557afeb420ea604046

DEVICE TYPE 'SBT_TAPE' PARMS

'SBT_LIBRARY=/opt/hitachi/protector/app/lib/libhsbt.so,SBT_PARMS=(TRIGGER=1f04eeec33b10190b79ea6d47a65f3943f5a9de0c1a5d1557afeb420ea604046)'