Optimize restore/recover

Oracle RDBMS Enterprise 11g

Hi,

We need to keep a test database copied from production once per week. We are performing this job restoring e recovering from the backups of the production database, that are done frequently. Since every week we do a level 0 or level 1 online backup. We don't have any restriction about the point in time of the recover, just to be weekly updated.

Aiming to minimize the archives application, that is a slower phase of the restore, and to take advantage of the level 1 backups done, I wrote a rman script with "set until scn XXX" (both for recover and restore), where XXX comes from this query: