IMPAX 6.5.1 Server Knowledge Base home > Oracle Server home

Checking the status of RMAN backup jobs

You can check the status of the RMAN backup jobs. The following columns are returned:

Column Description
session_key RMAN session identifier. Each backup job has its own unique session key.
command_id RMAN generated ID. The ID contains the date when the backup job is run.
status Backup job status. It can be one of:
  • RUNNING WITH WARNINGS

  • RUNNING WITH ERRORS

  • COMPLETED

  • COMPLETED WITH WARNINGS

  • COMPLETED WITH ERRORS

  • FAILED

time_taken_display Total time the backup job took to complete.

To check the status of RMAN backup jobs on Solaris

  1. Log in as the oracle user.

  2. Run the following commands:

    sqlplus / as sysdba

    select session_key, command_id, status, time_taken_display from v$rman_backup_job_details;

To check the status of RMAN backup jobs on Windows

  1. Log in as the AgfaService user.

  2. Open a command prompt.

  3. Run the following commands:

    sqlplus / as sysdba

    select session_key, command_id, status, time_taken_display from v$rman_backup_job_details;


Topic number: 120332

Applies to: IMPAX 6.5.1 Server Knowledge Base