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

Rman backup database plus plus archivelog error did not find the expected archive log how to solve, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

Use rman to back up the database plus plus archivelog backup archive log to report this error

RMAN-00571: =

RMAN-00569: = ERROR MESSAGE STACK FOLLOWS =

RMAN-00571: =

RMAN-03002: failure of backup plus archivelog command at 05/05/2014 01:00:04

RMAN-06059: expected archived log not found, loss of archived log compromises recoverability

ORA-19625: error identifying file / oracle/PRD/oraarch/PRDarch2_16336_840558852.dbf

ORA-27037: unable to obtain file status

IBM AIX RISC System/6000 Error: 2: No such file or directory

Additional information: 3

1. Reason: archive logs are cleared periodically with the rm command

two。 Principle (information from the Internet):

2.1 the relevant information of each archivelog is recorded in controlfile. When we delete or change these physical files under OS, the information of these archivelog is still recorded in controlfile. When we manually clear the files in the archive directory, these records are not erased by us from controlfile, that is, oracle does not know that these files no longer exist! At this time, we have to do manual cleaning. 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. Crosscheck backupset crosscheck backupset is to check the backup set and the actual file 1 backup set has two states A (Available,RMAN believes that this exists on the backup media) X (Expired, backup exists in the control file or recovery directory, but

Does not physically exist on the backup media)

The purpose of crosscheck is to check the directory of RMAN and the physical file, and if the physical file does not exist on the media, it will be marked as Expired. If the physical file

Exists and will maintain Available. If the backup set originally marked Expired exists again on the backup media (such as after recovering a damaged disk drive)

Crosscheck will mark the status back from Expired to Available.

3. Solution: add to the script

RMAN > crosscheck archivelog all

RMAN > delete expired archivelog all

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

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.