oracle in backup mode and shutdown

[yls177]

Oracle was on backup mode during a online backup. However, one of the datafile filesystem was full. During the next offline backup, the database was shutdown with the backup mode still on. The next startup, Oracle failed to start and points to the one datafile which was full.

Please advise

[akhadar]

1.Mount the database and with the help of V$datafile find the datafile which is offline.
2.use Alter tablespace *** end backup.
3.use Recover database command.

[akhadar]

1.Mount the database and with the help of V$datafile find the datafile which is offline.
2.use Alter tablespace *** end backup.
3.use Recover database command.
Also it will be help ful if u mention the error message.

[jmodic]

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.