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