Originally posted by akhadar
1.Mount the database and with the help of V$datafile find the datafile which is offline.
None of the datafiles will be offline. If the datafile is in backup mode, it is not 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.
2.use Alter tablespace *** end backup.
You will have to use "ALTER DATABASE DATAFILE xyz END BACKUP;"
3.use Recover database command.
Absolutely no need for any recovery operation.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?