Home > Database > Mysql Tutorial > ORA-19502,ORA-27072 错误解决

ORA-19502,ORA-27072 错误解决

WBOY
Release: 2016-06-07 16:49:10
Original
1906 people have browsed it

1.1.1. ORA-19502,ORA-27072 日期:2014-05-12 00:12 环境:测试机 【错误号】 $ oerr ora 19502 19502, 00000, write error on

1.1.1. ORA-19502,ORA-27072

日期:2014-05-12 00:12

环境:测试机

【错误号】

$ oerr ora 19502

19502, 00000, "write error on file\"%s\", block number %s (block size=%s)"

// *Cause: write error on output file

// *Action: check the file

$ oerr ora 27072

27072, 00000, "File I/O error"

// *Cause: read/write/readv/writev system call returned error, additional

//        information indicates starting block number of I/O

// *Action: check errno

【情景描述】

在RMAN中执行 backup database plus archivelog;命令进行数据库备份的时候,发生报错,备份失败。

【报错信息】

在RMAN中执行备份里命令时遇到的报错信息

input datafile file number=00004name=/U01/app/Oracle/oradata/testdb/users01.dbf

channel ORA_DISK_1: starting piece 1 at2014-05-11 23:56:38

RMAN-00571:===========================================================

RMAN-00569: =============== ERROR MESSAGESTACK FOLLOWS ===============

RMAN-00571:===========================================================

RMAN-03002: failure of backup plusarchivelog command at 05/11/2014 23:56:53

ORA-19502: write error on file"/U01/app/test/rman/fra/TESTDB/backupset/2014_05_11/o1_mf_nnndf_TAG20140511T235638_9pz7fpb5_.bkp",block number 46336 (block size=8192)

ORA-27072: File I/O error

Additional information: 4

Additional information: 46336

Additional information: 53248

查看alert.log日志:

没有生成报错信息。

【报错原因】

RMAN报错提示在生成备份集文件的时候遇到问题,文件I/O发生错误,所以怀疑是不是备份使用的空间满了,,所以查看备份路径的空间,发现空间不够创建备份集文件。

【解决方法】

删除无用/过期的备份集,释放空间,然后再次执行备份命令。

ORA-01172、ORA-01151错误处理

ORA-00600 [2662]错误解决

ORA-01078 和 LRM-00109 报错解决方法

ORA-00471 处理方法笔记

ORA-00314,redolog 损坏,或丢失处理方法

ORA-00257 归档日志过大导致无法存储的解决办法

本文永久更新链接地址:

linux

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template