InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How Do I Go About Backing Up My Online Redo Logs? |
|
Answer» Online redo logs should never, ever be included in a backup, regardless of whether that backup is performed hot or cold. The reasons for this are two-fold. First, you physically cannot backup a hot online redo LOG, and second there is PRECISELY zero need to do so in the first place because an archive redo log is, by DEFINITION, a backup copy of a formerly on-line log. There is, however, a more PRACTICAL reason: backing up the online logs yourself INCREASES the risk that you will lose. Online redo logs should never, ever be included in a backup, regardless of whether that backup is performed hot or cold. The reasons for this are two-fold. First, you physically cannot backup a hot online redo log, and second there is precisely zero need to do so in the first place because an archive redo log is, by definition, a backup copy of a formerly on-line log. There is, however, a more practical reason: backing up the online logs yourself increases the risk that you will lose. |
|