我怀疑我的磁带空间没释放导致的。
报错如下:
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客户端检查了脚本:有释放脚本。
求各位大哥帮忙看看?
的却是在rman脚本里加入过期删除,
delete noprompt obsolete recovery window of 30 days;
delete noprompt expired backup;
然后在tsm上执行
expire inventory
q libv是否还有scratch的磁带,如果没有可能存储池空间不足了,报错里显示的。你需要做过期处理,你指定的数据是保留多久啊?你执行的命令是不是以rman默认的参数做过期呢?
expire inventory标记过期试试,如果还没有清理过期数据,是不是你的数据还没过期呢?
我之前用天数的比较多:
delete noprompt obsolete recovery window of 30 days;
delete noprompt expired backup;
收起ANS1329S (RC29) Server out of data storage space,没有备份空间了