建议贴出详细信息:磁带空间没释放导致的。111111111111111111111111111111.png报错如下:channel ch1 disabled, job failed on it will be run on another channel RMAN-03009: failure of backup command on ch4 channel at 01/19/2016 03:36:46 ORA-19502: write error o...
显示全部建议贴出详细信息:
磁带空间没释放导致的。
111111111111111111111111111111.png
报错如下:
- channel ch1 disabled, job failed on it will be run on another channel RMAN-03009: failure of backup command on ch4 channel at 01/19/2016 03:36:46 ORA-19502: write error on file "VIP_VIP_db_egqrnt1u_1_1_20160119_2512_1", block number 1872129 (block size=8192) ORA-27030: skgfwrt: sbtwrite2 returned error ORA-19511: Error received from media manager layer, error text: ANS1312E (RC12) Server media mount not possible channel ch4 disabled, job failed on it will be run on another channel RMAN-03009: failure of backup command on ch5 channel at 01/19/2016 03:38:41 ORA-19502: write error on file "VIP_VIP_db_ehqrnt1u_1_1_20160119_2513_1", block number 917633 (block size=8192) ORA-27030: skgfwrt: sbtwrite2 returned error ORA-19511: Error received from media manager layer, error text: ANS1312E (RC12) Server media mount not possible channel ch5 disabled, job failed on it will be run on another channel RMAN-03009: failure of backup command on ch3 channel at 01/19/2016 03:46:17 ORA-19502: write error on file "VIP_VIP_db_efqrnt1u_1_1_20160119_2511_1", block number 1334401 (block size=8192) ORA-27030: skgfwrt: sbtwrite2 returned error ORA-19511: Error received from media manager layer, error text: ANS1329S (RC29) Server out of data storage space
如何让他释放呢?
oracle客户端检查了脚本:有释放脚本。
22222.png
2种方法: - 删除老的备份
查看备份策略 q schedule f=d;
修改策略,update schedule (policy domain name)(schedule name) objects=“ ”
删除部分早的数据,clean出新的空间。或者重启。 - 如果数据的合规要求 要求保留,不能删除,则扩容磁带容量。
收起