Oracle 9i Database -- DBA Fundamentals II (8)

User-Managed Backups

• The Open Database backup backed up datafiles, control files, and parameter files, password files.
• During direct load operations, setting the tablespace or table being backed up to a nonlogging mode facilitates faster transfer of data. This is the result of bypassing the buffer cache during direct load operations, which eliminates the recording of redo. However, this also means that data lost during this operation cannot be recovered, and thus it is recommended that the tablespace or table be backed up as soon as the direct load operation is concluded.