Why doesn't oracle back up the archives that have been backed up?
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!