Doing db recovery when few datafiles are corrupted

In case you are trying to bring up the database from an inconsistent backup and there are chances of corruption when you open database with resetlogs , you can use the following init parameter to open the DB.

_ALLOW_RESETLOGS_CORRUPTION=TRUE

Remove this parameter when your DB is up and recycle the DB gracefully.

You can use the following event to skip the scn by 1 or any number in case some of the archives are missing for particular scns.

alter session set events '10015 trace name adjust_scn level 1'; <= change the value of 1 to number of scns you want to skip.