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

Today, I will talk to you about what to do about ORACLE rman backup error reporting RMAN-03009&ORA-19587&ORA-27072. Many people may not know much about it. In order to make you understand better, the editor has summarized the following content for you. I hope you can get something according to this article.

Host: rhel 6.8

Database version: oracle 11.2.0.4 rac

During the recent Oracle database inspection, it was found that there was a problem with the rman backup of a prefecture and city. At the backup node, rac2 logged in to the database server with oracle, and executed the backup check command Times error:

RMAN > crosscheck backup

Using target database control file instead of recovery catalog

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: SID=179 instance=orcl2 device type=DISK

RMAN-00571: =

RMAN-00569: = ERROR MESSAGE STACK FOLLOWS =

RMAN-00571: =

RMAN-03009: failure of crosscheck command on ORA_DISK_1 channel at 08/21/2017 16:21:45

ORA-19587: error occurred reading 512 bytes at block number 1

ORA-27072: File I/O error

Linux-x86_64 Error: 5: Input/output error

Additional information: 4

Additional information: 1

Additional information:-1

ORA-27047: unable to read the header block of file

Linux-x86_64 Error: 5: Input/output error

Additional information: 3

Check the storage utilization of the node rac2 backup directory as follows, which shows that it is not caused by the full storage space:

Then, use oracle login node 1 to perform a backup check, but the command executes smoothly, as shown below, there are 50 expired backups:

Then, the expired backup deletion operation is performed on the node rac1, which is executed smoothly.

After the expired backup is deleted, the backup check command of node rac2 can be executed normally, as shown in the figure:

Rac2 can also initiate a backup normally at the backup node:

After reading the above, do you have any further understanding of what ORACLE rman backup error RMAN-03009&ORA-19587&ORA-27072 should do? If you want to know more knowledge or related content, 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.