9.3. Monitoring RMAN Backup Status

RMAN produces output during the backup process. If you enable logging when you start RMAN, that output is suppressed. You can monitor RMAN operations by keeping an eye on the log file being generated, or you can use the V$ view V$RMAN_OUTPUT, as shown in this example:

SQL> select output from v$rman_output order by stamp;
OUTPUT
------------------------------------------------------------------Starting
backup at 12-NOV-05
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=138 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=154 devtype=DISK
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001
name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ROB10R2\SYSTEM01.DBF
input datafile fno=00004
name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ROB10R2\USERS01.DBF
channel ORA_DISK_1: starting piece 1 at 12-NOV-05
input datafile fno=00003
name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ROB10R2\SYSAUX01.DBF
channel ORA_DISK_2: specifying datafile(s) in backupset
channel ORA_DISK_2: starting compressed full datafile backupset
input datafile fno=00005name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ROB10R2\EXAMPLE01.DBF
input datafile fno=00002name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ROB10R2\UNDOTBS01.DBF
channel ORA_DISK_2: starting piece 1 at 12-NOV-05