This content has been marked as final. Show 4 replies
if it is failed status is there any query to get that code from the database or we need to depend on the logs only.Rman backup log or oracle alert<sid>.log.
Only option is RMAN backup log file.
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