RMAN backup reports RMAN-06059 Error

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: