Viewing RMAN Command History

You didn’t log your output to an OS file, and you now wonder whether there is a way to view
the RMAN command stack output.
you can get Solution:-


Use V$RMAN_OUTPUT to view the text messages that RMAN produces when performing
tasks. Run this query to view the historical RMAN command messages:
SQL> select
2 sid,
3 recid,
4 output
5 from v$rman_output
6 order by recid
7 /
The output looks like this:
SID RECID OUTPUT
------ ----- -----------------------------------------------------------------
154 31 Starting backup at 14-JAN-07
154 32 using target database control file instead of recovery catalog
154 33 allocated channel: ORA_DISK_1
154 34 channel ORA_DISK_1: sid=144 devtype=DISK
154 35 channel ORA_DISK_1: starting full datafile backupset
154 36 channel ORA_DISK_1: specifying datafile(s) in backupset
154 37 input datafile fno=00001 name=C:\ORACLE\10.2\ORADATA\ORCL\SYSTEM01.DBF
154 38 input datafile fno=00003 name=C:\ORACLE\10.2\ORADATA\ORCL\SYSAUX01.DBF
154 39 input datafile fno=00002 name=C:\ORACLE\10.2\ORADATA\ORCL\UNDOTBS01.DBF
154 40 input datafile fno=00005 name=C:\ORACLE\10.2\ORADATA\ORCL\TOOLS01.DBF
154 41 input datafile fno=00004 name=C:\ORACLE\10.2\ORADATA\ORCL\USERS01.DBF
154 42 channel ORA_DISK_1: starting piece 1 at 14-JAN-07
154 43 channel ORA_DISK_1: finished piece 1 at 14-JAN-07
154 44 piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\
BACKUPSET\2007_01_13\O1_MF_NNNDF_TAG20070113T160913_2TLSNTNZ_.BKP
154 45 channel ORA_DISK_1: backup set complete, elapsed time: 00:02:35
154 46 Finished backup at 14-JAN-07
You can also join V$RMAN_OUTPUT to V$RMAN_STATUS to get additional information.
This useful query shows the type of command RMAN is running, its current status, and its
associated output messages:
SQL> select
2 a.sid,
3 a.recid,
4 b.operation,
5 b.status,
6 a.output
7 from v$rman_output a,
8 v$rman_status b
9 where a.rman_status_recid = b.recid
10 and a.rman_status_stamp = b.stamp
11 order by a.recid
12 /