Checking the SBT Library Status

You can determine if an error condition exists in the media management software by querying the RA_SBT_LIBRARY view. You can also determine the PAUSE state of an SBT library.

To view the status of an SBT library:

1. With SQL*Plus or SQL Developer, connect to the Recovery Appliance metadata database as the Recovery Appliance administrator.

2. Run the following query:

   SELECT LIB_NAME, LAST_ERROR_TEXT, STATUS 
   FROM   RA_SBT_LIBRARY;
   
   LIB_NAME            LAST_ERROR_TEXT                                 STATUS 
   ------------------- ----------------------------------------------- ------ 
   OSBSBT                                                              READY  
   

   Table 9-3 lists the possible values for STATUS.

   Table 9-3 Values for the STATUS Column of RA_SBT_LIBRARY

   Value	Meaning
   READY	The SBT library was properly created and is ready to process tape I/O.
   PAUSE	The SBT library was paused with PAUSE_SBT_LIBRARY.
   ERROR	An error condition exists in the media management software. Tape backup operations cannot continue until you clear the error and call RESUME_SBT_LIBRARY. The last_error_text column describes the most recent error returned by the media management library. The error text also appears in the RA_SBT_TASK rows for the affected background SBT tasks.

See Also:

"RA_SBT_LIBRARY"