An online backup requires all redolog files that were created during the backup to restore the data. The offline redolog files that were created during the backup should therefore be kept for as long as the online backup itself. In addition, offline redolog files should be backed up continuously, regardless of the backup cycle. For productive systems, it is recommended that the offline redolog files be backed up multiple times, for example on two different tapes, in order to ensure failure safety in the event of any errors on the backup media (e.g. tape read errors).
The files can be backed up on various media and are copied to the respective backup medium using either operating system tools, the Oracle Recovery Manager or third-party tools. The bulgaria telegram screening backup media (e.g. disks or tape drives) should be connected directly to the database server.
A full offline backup is the physical backup of all files required to restore a database in a "cold" state. This means that the database must be closed before the backup. This ensures that no changes are made to the database during this time. After an offline backup of the entire database, you have a consistent backup of the database.
However, during an offline backup, only individual tablespaces or data files can be backed up together with the control file. This partial backup of a database cannot be used for a consistent recovery of the entire database. For this, the offline redo log files between the individual partial backups are also required.
- Board index
- All times are UTC
- Delete cookies
- Contact us