Get the App
SLTechnology News&Howtos  ›  Database  › 

Why doesn't oracle back up the archives that have been backed up?

Shulou Source: shulou.com Published: 2022-05-31 15:41:07 09月30日 Update

This article mainly introduces "how oracle does not back up the archives that have been backed up". In daily operation, I believe many people have doubts about how oracle does not back up the archives that have been backed up. Xiaobian consulted all kinds of materials and sorted out simple and easy to use operation methods. I hope to help you answer the doubts about "how oracle does not back up the archives that have been backed up"! Next, please follow the small series to learn together!

When an Oracle database backs up archive logs, the archive log files of the last few days are usually saved and not deleted.

For example:

backup archivelog all;

delete noprompt archivelog all completed before 'sysdate-14'; Keep archive logs locally for 14 days.

When backed up again, the archive is backed up again and again.

Add a clause not backed up 1 times to avoid backing up archived logs.

The order reads as follows:

backup archivelog all not backed up 1 times; do not backup the archive that was last backed up

backup archivelog all not backed up 2 times; archive backup twice the third time is not backed up

At this point, the study of "how oracle does not back up the archives that have been backed up" is over, hoping to solve everyone's doubts. Theory and practice can better match to help everyone learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!

Tags: Backup log learning more help practical next commands clauses regular meetings data databases files articles methods theory knowledge articles websites materials Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Shulou Technology Docker Shulou Information macOS NVidia