RMAN => 12cR2 New Feature "recover database until available redo"

After you restore your database, it is sometimes possible to lost your archivelogs to recover but even so you want to recover as far as possible and open your database with resetlogs.

Before 12cR2, if you face such a case like that, you need to switch SQL*Plus and run the below command:

recover database using backup controlfile until cancel;

Then, you should say “CANCEL” and open with resetlogs option.

or

you need to identifiy missing archivelog and give the "restore" command with until sequence/until time option.

After 12cR2, you dont need that extra step, you can directly say to oracle with RMAN to recover database  as far as possible and cancel it automatically.

The below screenshot is from classic output if I delete the sequence 5 manually.

And this is new behaviour with 12cR2, it could recover the database until sequence 5 without issue.