None of the datafiles will be offline. If the datafile is in backup mode, it is not offline.
Originally posted by akhadar
1.Mount the database and with the help of V$datafile find the datafile which is offline.
So you will have to find which datafiles are in backup mode by querying the V$BACKUP to see which files are in 'ACTIVE' backup state.
You will have to use "ALTER DATABASE DATAFILE xyz END BACKUP;"
2.use Alter tablespace *** end backup.
Absolutely no need for any recovery operation.
3.use Recover database command.
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?