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

This article mainly introduces the example analysis of rman backup failure and crosscheck in oracle, which is very detailed and has certain reference value. Friends who are interested must finish it!

When the oracle archive log file delete is dropped or changed abnormally, the archivelog information is still recorded in the controlfile file. After we manually erase or change the files in the archive directory, these records are not erased from the controlfile, that is, the database does not know that these files no longer exist. At this time, it usually causes the failure of the rman backup, because the Rman backup will detect the missing logs. As a result, it is impossible to continue the implementation.

In order to restore a normal backup of RMAN, we usually manually execute two commonly used commands in the database.

The purpose of crosscheck archivelog all; is to check the difference between the control file and the actual physical file.

Delete expired archivelog all; is to synchronize the information of the control file with the information of the actual physical file.

If you execute crosscheck alone without delete, then the backup fails because the information that controls the file is still different from the actual information. Generally speaking, we can try to CROSSCHECK first, and then execute crosscheck archivelog all after delete expired archivelog all.

If the NBU backup is an invoked RMAN script, we need to do the same to restore the backup of the NBU.

The DB2 database solution to this problem:

1. All logs before a certain point in time were deleted manually, and it was found that the archived logs of NBU could not continue. Archiving logs cannot be done manually.

two。 Use the following command to resolve:

Db2 connect to test

Db2 prune logfile prior to "first active logfile"

After executing this command, all log files before this log file are deleted. At this point, perform another full backup and the system returns to normal.

The above is all the contents of the article "rman backup failure in oracle and sample Analysis of crosscheck". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.