When LIST, REPORT and SHOW do not provide all the information you need on RMAN activities, there are a number of useful V$ views that can provide more details. Now a day several Graphical backup reporter tools is available you can use any one to check all the backup related information.
|V$PROCESS||Identifies currently active processes.|
|V$SESSION||Identifies currently active sessions. Use this view to determine which database server sessions correspond to which RMAN allocated channels.|
|V$SESSION_LONGOPS||Provides progress reports on RMAN backup and restore jobs.|
|V$SESSION_WAIT||Lists the events or resources for which sessions are waiting.|
|V$BACKUP_SYNC_IO||Displays rows when the I/O is synchronous to the process (or thread on some platforms) performing the backup.|
|V$BACKUP_ASYNC_IO||Displays rows when the I/O is asynchronous to the process (or thread on some platforms) performing the backup.
Note: Where asynchronous I/O is not supported by the host operating system, it may be implemented using slave I/O processes.
To Monitor job Progress:
Before starting the job, create a script file (called, for this example, longops) containing the following SQL statement:
SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK, ROUND(SOFAR/TOTALWORK*100,2) “%_COMPLETE” FROM V$SESSION_LONGOPS WHERE OPNAME LIKE ‘RMAN%’ AND OPNAME NOT LIKE ‘%aggregate%’ AND TOTALWORK != 0 AND SOFAR <> TOTALWORK;
Monitor backup and restore performance by querying V$BACKUP_SYNC_IO and V$BACKUP_ASYNC_IO.