RMAN ORA-19502&ORA-27072

最新推荐文章于 2025-06-27 09:42:42 发布

原创最新推荐文章于 2025-06-27 09:42:42 发布 · 8k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#disk #crm #磁盘 #file #database #测试

本文记录了一次使用RMAN进行数据库恢复时遇到的ORA-19502和ORA-27072错误，并详细介绍了如何通过释放磁盘空间解决问题的过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

测试库上用rman做恢复的时候遇到了ORA-19502和ORA-27072的错误。

RMAN> restore database;
......
channel ORA_DISK_2: ORA-19870: error while restoring backup piece
ORA-19502: write error on file "/app/ora10/oradata/orcl/TD_CRM01.dbf", 
block number 757120 (block size=8192)
ORA-27072: File I/O error
Additional information: 4
Additional information: 757120
Additional information: 69632

从错误信看是在写文件的时候遇到了错误，可能是磁盘空间不够了。

检查了一下磁盘空间，发现空间不够用。

$df -h
Filesystem            Size  Used  Avail  Use% Mounted on
/dev/sda5              500G 480G    20G   96% /
/dev/sda2             3.9G   73M   3.7G    2% /tmp
/dev/sda1              99M   22M    73M    23% /boot
tmpfs                 4.0G  1.1G   3.0G    26% /dev/shm

这时候有两种解决方案：

1.删除一些文件，释放磁盘空间

2.添加新的磁盘空间。

删除了一些文件，从新restore database，可以从出错的地方继续开始。

RMAN> restore database;
skipping datafile 28; already restored to file /app/ora10/oradata/orcl/TD_CRM_BAK.dbf
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00027 to /app/ora10/oradata/orcl/TD_CRM01.dbf
channel ORA_DISK_1: reading from backup piece /app/ora10/backup/ORCL779007699615j7n6tdmj
channel ORA_DISK_1: piece handle=/app/ora10/backup/ORCL779007699615j7n6tdmj tag=TAG20120327T070138
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:16:35
Finished restore at 27-MAR-12