LogXptStatus (Redo Transport Status)

The LogXptStatus monitorable property returns a table that contains the error status of redo transport services for each of the enabled configuration members.

This property pertains to the primary database, a physical standby database that ships redo data, or a far sync instance.

The table contains the following columns:

• PRIMARY_INSTANCE_NAME

  The value identifying the SID for the instance on the primary database.

• STANDBY_DATABASE_NAME

  The database unique name (DB_UNIQUE_NAME) of the standby database or far sync instance.

• ERROR

  The text of the redo transport error. If there is no error, the field is empty.

Each entry in the table indicates the status of redo transport services on one redo source to one redo destination.

The error status can be an empty string, which indicates there is no error.

In the following example, the STATUS from South_Sales is empty because there is no error for the South_Sales destination. The South_Report destination returned the ORA-01034 message.

DGMGRL> SHOW DATABASE 'North_Sales' 'LogXptStatus' ;
LOG TRANSPORT STATUS
PRIMARY_INSTANCE_NAME STANDBY_DATABASE_NAME               STATUS
         north_sales1          South_Sales
         north_sales1          South_Report    ORA-01034: ORACLE not available