Oracle RMAN recovery script for EMC NetWorker

In this article I’ll share an Oracle RMAN script to do restore and recovery an Oracle database from tape library using EMC NetWorker. Apply this RMAN template to different recovery situations you might have. Before looking into the RMAN script see my notes below:

I know it has been a few years since you posted this, but perhaps you can help me. I have been at my current work site for a year and recently started checking backups and restore. We use Networker that calls an RMAN script. I have successfully restored from the last backup using
ALLOCATE CHANNEL T1 TYPE SBT SEND ‘NSR_ENV=(NSR_SERVER=”????”,NSR_CLIENT=”????”)’;
RESTORE CONTROLFILE FROM AUTOBACKUP;
and from other previous backups with
ALLOCATE CHANNEL T1 TYPE SBT SEND ‘NSR_ENV=(NSR_SERVER=”????”,NSR_CLIENT=”????”)’;
RESTORE CONTROLFILE FROM …
RESTORE DATABASE;
RECOVER DATABASE;
However, attempts to RESTORE with SET UNTIL results in Networker not finding the archivelogs.
I tried RESTORE ARCHIVELOG FROM SEQUENCE …
but still, Networker cannot find the archivelogs. Any archivelogs generated after the BACKUP CONTROLFILE was created are inaccessible. I have not found anybody using Networker and RMAN that has restored and rolled forward archivelogs until a specific time or SCN. Our Networker support suggested implementing an RMAN catalog but I do not want to do that.
Have you restored UNTIL TIME or SCN from Networker/RMAN without catalog?

Yes, it should definatelly work. First ensure not only your backup pieces available on the Networker but also that your control file of your DB still have the information about them. I recommend always extend the retention period of the backup metadata in the control file. I think by default its 7 days or so. Just do the following on your DB:
alter system set control_file_record_keep_time=30 scope=both;