RMAN backup reports RMAN-06059 Error

Source: Internet
Author: User

RMAN backup reports RMAN-06059 Error

RMAN backup reported RMAN-06059 error:

RMAN-03002: backup plus archivelog command (on 00:08:52) failed
RMAN-06059: failed to find the expected archive log, loss of archive log will affect recoverability
ORA-19625: Error identifying file/orabackup/archivelog/12771_850586041.dbf
ORA-27037: Unable to get File status
NOTE: Due to the deletion of the previous archive file, RMAN is still looking for the archive file in the original location, so there is a problem.

Theoretical support:

Each archivelog information is recorded in the controlfile. When we delete these physical files or perform abnormal changes under the OS, the archivelog information is still recorded in the controlfile, after we manually clear the files under the archive directory, these records are not cleared from the controlfile, that is, Oracle does not know that these files do not exist!

Solution:

1. RMAN> crosscheck archivelog all; -- check the difference between the control file and the actual physical file

2. RMAN> delete expired archivelog all; -- synchronize Control File Information and actual physical file information

In this case, we need to manually clear it. If crosscheck is executed separately but delete is not executed, the backup still fails because the information of the control files is different from the actual information.

-------------------------------------- Recommended reading --------------------------------------

ORA-19571 for RMAN backup

RMAN: Configure an archive log deletion policy

Basic Oracle tutorial-copying a database through RMAN

Reference for RMAN backup policy formulation

RMAN backup learning notes

Oracle Database Backup encryption RMAN Encryption

ORA-19588 encountered during RMAN backup

-------------------------------------- Split line --------------------------------------

This article permanently updates the link address:

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.