Case 1: Jobs run as follows:
-
Snap full job (data and log)
-
Streaming archive log only jobs
Restore/Revert can be performed from the snap job and control file/SP file restore can be done from the Streaming archive log jobs using autobackup/backup piece option.
Considerations:
If archive log only restore are submitted, then it also uses the snap job only and restore archive logs which were included in the snap job. To restore archive logs from Streaming RMAN archive log jobs, select the copy precedence as the Primary copy of archive log storage policy and submit the restore.
Case 2: Jobs run as follows:
-
Snap full job (data and log)
-
Streaming RMAN full job (data and log)
-
Streaming archive log only jobs
Restore/Revert can be performed from the snap job and control file/SP File restore can be done from Streaming RMAN jobs using autobackup/backup piece option.
Considerations:
-
Restore job will pick the latest job for the specified time (it could be either snap or traditional RMAN) and use that job for restore.
-
If both the snap full job and traditional RMAN full job run parallel and complete at the same time, then the restore always picks the snap job only if you do restore from the instance level. To use the traditional RMAN backup, submit the restore from backup history after browsing the traditional RMAN job.