|Maintain high database availability -|
When using an open database backup, the database is available for process access during the backup and the business transactions will not be interrupted because of the backup.
|More training required for the DBA -|
Because an open database backup is a complicated process (compared to the closed database backup), a DBA will need more training to handle the process.
|Can be done at a tablespace or datafile level -|
A DBA may choose to backup all the datafiles for a specific tablespace or just individual datafiles for a tablespace.
|More error-prone -|
An online database backup is more error-prone because of additional operator interaction. Thus, it's best to use tested scripts to automate the process.
|Allows recovery to point-in-time -
With an open database backup, the DBA may choose to recover the database to a certain point of time.