Oracle Constraints on Recovery Operations

The following Oracle constraints affect the recovery operations you can perform on a database:

When recovering data files and old control files, you must recover the entire database. You cannot perform a data file level recovery.
When performing a full database recovery and some tablespaces are already offline prior to the restore operation, they will not be recovered automatically. You must recover data files manually before putting them back online.
After you perform a point-in-time recovery or restore old control files, the redo logs can no longer recover data files restored from previous backups. Consequently, you must open the database with the resetlogs option. You must also run a full backup as soon as possible.