Backup Exec Simplified Disaster Recovery (SDR) does not support the restore of an Oracle database; therefore the restore has to be done in two steps.

A full SDR enabled server backup and a full Oracle database backup using the Backup Exec Agent for Oracle is required.
 

1. Use Backup Exec Simplified Disaster Recovery (SDR) to restore the complete server. The SDR restore will restore the Oracle Application but not the Oracle Database files.
    
2. Restoring Oracle
   a) Preparation
       - Make sure no DB files exist (have been restored) in the location specified prior to the crash
       - From the SQL*Plus prompt type “shutdown immediate”
       - startup NOMOUNT
       - Type RMAN and set DBID ### (the Database ID (DBID) is found in the restore window). In
          the restore view the DBID is on the far-right side.

b) Oracle restore job
    - Select Oracle Server for Restore
    - Select "Control File" form Restore window
    - Select “Restore to Original Server” option
    - Enter SCN number or time of control file (The SCN number is mentioned in the screen shot above)
    - Submit the restore job

c) Oracle recovery
     - Once the restore job is completed a similar error will be seen in the job log.
       RMAN-03002: failure of recover command at 11/26/2021 01:27:23
       RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 5 and starting
       SCN of 1512391

Open SQL*Plus and type command, “Alter database open resetlogs”

The Oracle Database application should now function from the last full backup that was done.