| 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: