The RMAN restore database until command will retrieve all data files from the most recent backup set or image copy.
RMAN will automatically determine from the until clause which backup set contains the required
data files. If you omit the until clause of the restore database command, RMAN will retrieve data files from the
latest available backup set or image copy. In some situations, that may be the behavior you desire.
We recommend you use the until clause to ensure that RMAN restores from the correct backup set or image copy. When you
issue the restore database until command, RMAN will determine how to extract the data files from any of the
- Full database backup
- Incremental level 0 backup
- Image copy backup generated by the backup as copy command
You cannot perform an incomplete database recovery on a subset of your database's online data files. When
performing incomplete database recovery, all of the checkpoint SCNs for all online data files must be synchronized
before you can open your database with the alter database open resetlogs command. You can view the data file
header SCNs and the status of each data file via this SQL query: