| 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 is 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.
BACKUP ... PLUS ARCHIVELOGcommand, which causes RMAN to do the following: