This content has been marked as final. Show 4 replies
You can use v$rman_ouput.
Note: The v$rman_output view is memory-based so it will not persist thru a database restart (i.e will not recorded in the controlfile). The view can hold 32768 rows.
If you want keep all data from v$rman_output you have 3 option:
1. Use RMAN CATALOG on different database.
2. Use a trigger on the V_$RMAN_OUTPUT view to keep track of all backup info on a separate table
3. Use a RMAN Catalog on same Database only to this purpose. (not recommended)
See this example:
Edited by: Levi Pereira on Nov 9, 2012 2:58 PM
This is worth a look :
In Unix/Linux you can :
This holds all the output from your backup
$ script rmanbackup.log $ rman target / RMAN> backup database; RMAN> exit $ script done, file is rmanbackup.log
Edited by: mseberg on Nov 9, 2012 11:53 AM