Shulou(Shulou.com)05/31 Report--

This article will explain in detail what to do about backup failure caused by deleting archive logs in the database. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

To be clear, there are two situations in which the backup fails because the archive log is deleted.

The first situation is that the backup fails to report an error after the archive log rm is deleted because of insufficient disk space.

The second situation is the flashback of the backup script after actively deleting the archive log under RMAN (under the windows system of course).

Here comes the main point, and the solution is presented. Haha.

For situation one:

There is also a lot of detail on the Internet.

Check the archive log

RMAN > crosscheck archivelog all

Delete invalid archive logs

RMAN > delete expired archivelog all

Delete obsolete backups; (but do not perform)

RMAN > delete obsolete

Cause analysis:

The archivelog file of the database is deleted manually, but the control file still records the backup information of the archive log. When rman does the archive backup, it still needs to back up the file that has been unintentionally deleted, but the file has been physically deleted, and an error will be reported if it cannot be found on the disk. Through rman crosscheck archivelog all, you can also see that the file has expired, so delete the archive file from the control file before backup, and then the backup will be successful.

For situation two:

Because there is not enough space, or the log is too large, manually delete archivelog all under RMAN, and then execute the backup script in the windows environment.

After executing the statement in case one, it still doesn't work.

Try to use the statement backup library directly under rman, and then execute the backup script, which works.

RMAN > backup database

If the preparation of the library is successful, it is OK to execute the backup script written before.

After thinking about it, it is also possible that after the execution of the statement in case 1, you need to wait for more than 10 minutes before executing the backup script.

If you want to work right away, execute the backup script after rman executes the backup statement.

If you have plenty of time, you can wait a while to execute the backup script.

This is the end of the article on "what to do if the backup fails due to the deletion of archived logs in the database". I hope the above content can be helpful to you, so that you can learn more knowledge. If you think the article is good, please share it for more people to see.

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.