ra_helpdevice

(Oracle and Microsoft SQL Server only) This command returns information about the primary database log devices from the RASD log device repository.

Note: This command is available only for Oracle and Microsoft SQL Server.

Syntax

ra_helpdevice [device]

Parameters

device – The device ID of the primary database log device.

Examples

Example 1 –
```
ra_helpdevice
```
This command returns information about all primary database log devices recorded in the log device repository.
Example 2 –
```
ra_helpdevice 1
```
This command returns information about the primary database log device ID “1” in the log device repository.

Usage

The ra_helpdevice command returns the following information for each primary database log device recorded in the RASD:
- Device ID – the log device ID defined by the primary data server.
  
  Note: For Oracle, the ID is the value of the Oracle Redo Log Group that this file belongs.
- Database name – the name of the primary database associated with the log device.
- Device name – the logical name of the log device defined by the primary data server.
- Server device path – the path to a multiplexed version of the log device.
- Disk mirror path – the path to the log device (at the standby site).
- Disk device status – the current status of the server device path (ACCESSIBLE, NOT_VALID, or OPEN).
The log device ID, primary database name, log device name, and server log device path are values returned by the primary data server when Replication Agent is initialized with the pdb_xlog init command, or when the log device repository is updated with the ra_updatedevices command.
The disk mirror path is the current value recorded in the RASD. To find each log device, Replication Agent uses the disk mirror path recorded in its RASD.

For each log device recorded in the RASD, you can set or change the disk device path with the ra_devicepath command.

If you do not specify a disk device path using ra_devicepath, the value recorded for the disk mirror path is DEFAULT, and Replication Agent uses the value recorded for the server device path to find the log device.
The disk device status is updated by the Log Reader component each time you invoke the ra_helpdevice command.
If ra_helpdevice is invoked with no option, it returns information for all log devices recorded in the RASD log device repository.
If ra_helpdevice is invoked with the device option, it returns information only for the specified log device.
The ra_helpdevice command is valid when the Replication Agent instance is in the Admin, Replicating, or Replication Down state.