Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

3

积分

0

好友

2

主题
1#
发表于 2014-7-2 09:10:36 | 查看: 4825| 回复: 0
刘大,您好:
  向您请教个问题,我的备份脚本非常简单,晚上执行的时候一直报错,空间不足,但是我白天sh执行脚本的时候又不报错误,
晚上执行的时候会产生很多日志,日志内容都是报空间不足,失败。
下面是任务列表:
* 1 * * * sh  /oradata/backup/rman_script/fullbackup.sh
下面是磁盘空间容量:
[oracle@node1 rman_log]$ df -h
文件系统              容量  已用 可用 已用% 挂载点
/dev/sda2              95G   12G   79G  13% /
/dev/sda1             289M   27M  248M  10% /boot
tmpfs                  16G  8.9G  7.2G  56% /dev/shm
/dev/sda5             826G  226G  559G  29% /oradata
/dev/sda6             697G  153G  509G  24% /oradata/backup

下面是报错内容:
RMAN-03009: failure of backup command on c1 channel at 07/02/2014 02:47:36
ORA-19502: write error on file "/oradata/backup/rman_db/full_GSTGATE_20140702_5377_1996030521.bak", block number 198528 (block size=8192)
ORA-27072: File I/O error
Linux-x86_64 Error: 28: No space left on device
Additional information: 4
Additional information: 198528
Additional information: -1
channel c1 disabled, job failed on it will be run on another channel
RMAN-03009: failure of backup command on c2 channel at 07/02/2014 02:48:11
ORA-19502: write error on file "/oradata/backup/rman_db/full_GSTGATE_20140702_5381_1996030521.bak", block number 193408 (block size=8192)
ORA-27072: File I/O error
Additional information: 4
Additional information: 193408
Additional information: 126976
channel c2 disabled, job failed on it will be run on another channel
released channel: c1
released channel: c2
released channel: c3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on c3 channel at 07/02/2014 02:48:19
ORA-19502: write error on file "/oradata/backup/rman_db/full_GSTGATE_20140702_5385_1996030521.bak", block number 139776 (block size=8192)
ORA-27072: File I/O error
Additional information: 4
Additional information: 139776
Additional information: 266240

实际上空间应该是够的,附件是详细的脚本及日志,我白天单独执行是ok的

full_20140702.tar

1.82 MB, 下载次数: 1101

fullbackup.txt

862 Bytes, 下载次数: 1018

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-6-15 13:30 , Processed in 0.055044 second(s), 24 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569