Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Handling expired archivelog and rman backups

2025-02-25 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report