We have three node RAC database. I want to know about the backup from which node it runs daily. We schedule the backup using cron. However, is there any view can provide the details of node name from which server the backup runs daily?.
You can try to adapt following scripts http://docs.oracle.com/cd/B19306_01/backup.102/b14191/advmaint.htm#i1008121 to use GV$SESSION/GV$PROCESS with INST_ID column instead of V$SESSION/V$PROCESS but you should run these scripts when RMAN backup is running.