Get the App
SLTechnology News&Howtos  ›  Database  › 

Handling expired archivelog and rman backups

Shulou Source: shulou.com Published: 2022-06-01 04:44:27 10月03日 Update

When the archive log is manually deleted, the Rman backup detects that the log is missing and cannot proceed further.

So you need to perform the crosscheck process manually at this point, and then the Rman backup can return to normal.

[the order of execution is as follows: delete archivelog manually-- > crosscheck--- > delete expired can finally be checked with list copy]

The experiments are as follows:

1.Crosscheck log

RMAN > crosscheck archivelog all

2. Use the delete expired archivelog all command to delete all expired archive logs:

RMAN > delete expired archivelog all

3. Use list copy to view

RMAN > list copy

4. A brief introduction to the report obsolete command

Report out-of-date backups using the report obsolete command

RMAN > report obsolete

5. Use the delete obsolete command to delete an expired backup:

RMAN > delete obsolete

You can also delete the backup set manually and then synchronize it with the following command

Delete expired backup collections

RMAN > crosscheck backup

RMAN > delete expired backup

Tags: Backup command manual log report brief missing process sequence enter synchronize check detect test process Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno OPPO Reno Apple Linux Shulou Technology macOS