TSM备份oracle报错!!!!急!!!!
客户前几天搬机房,现在tsm备份oracle报错(带库为ibm ts3100)
报错如下
-------------------------------------------------------
Starting backup at 07-DEC-13
channel c1: starting incremental level 0 datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00025 name=/oracle/DEV/sapdata2/sr3740_5/sr3740.data5
input datafile file number=00030 name=/oracle/DEV/sapdata2/sr3740_10/sr3740.data10
input datafile file number=00028 name=/oracle/DEV/sapdata2/sr3740_8/sr3740.data8
input datafile file number=00014 name=/oracle/DEV/sapdata3/sr3_11/sr3.data11
input datafile file number=00018 name=/oracle/DEV/sapdata3/sr3_15/sr3.data15
channel c1: starting piece 1 at 07-DEC-13
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on c1 channel at 12/07/2013 15:17:38
ORA-19502: write error on file "db_DEV_1112_3902559952_20131207", block number 943233 (block size=8192)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
ANS1315W (RC15) Unexpected retry request. The server found an error while writing the data.
-------------------------------------------------------------------------------------------------------------------------------
查看tsm上的path 和drive都正常
-----------------------------------------------------------------------
tsm: TSM>q path
Source Name Source Type Destination Destination On-Line
Name Type
----------- ----------- ----------- ----------- -------
TSM SERVER 3100LIB LIBRARY Yes
TSM SERVER DRIVE0 DRIVE Yes
SAPPRD1NOD- SERVER DRIVE0 DRIVE Yes
ESTA
tsm: TSM>q dr
Library Name Drive Name Device Type On-Line
------------ ------------ ----------- -------------------
3100LIB DRIVE0 LTO Yes
---------------------------------------------------------------------------------------------
当备份时候(执行脚本),q se和q mount都可以抓到磁带,但是一会儿就报错了(报错信息在上面已经贴出来)
同时,被写的磁带变为readonly状态
---------------------------------------------------------------------
tsm: TSM>q mount
ANR8330I LTO volume L00195L5 is mounted R/W in drive DRIVE0 (/dev/rmt0), status: IN USE.
ANR8334I 1 matches found.
tsm: TSM>q se
Sess Comm. Sess Wait Bytes Bytes Sess Platform Client Name
Number Method State Time Sent Recvd Type
------ ------ ------ ------ ------- ------- ------- -------- ------------------
74 Tcp/Ip Run 0 S 253.4 K 13.9 K Admin AIX ADMIN
79 Tcp/Ip IdleW 1 S 4.9 K 5.7 K Server AIX SAPPRD1NODESTA
82 Tcp/Ip IdleW 1 S 89.2 K 72.1 K Server AIX SAPPRD1NODESTA
194 Tcp/Ip Run 0 S 1.8 K 973.0 M Node TDP Ora- SAPDEVNODE
cle AIX
tsm: TSM>select volume_name,access from volumes
VOLUME_NAME: L00186L5
ACCESS: READWRITE
VOLUME_NAME: L00193L5
ACCESS: READWRITE
VOLUME_NAME: L00182L5
ACCESS: READWRITE
tsm: TSM>select volume_name,access from volumes
VOLUME_NAME: L00182L5
ACCESS: READWRITE
VOLUME_NAME: L00183L5
ACCESS: READWRITE
VOLUME_NAME: L00184L5
ACCESS: READONLY
还有一个问题,就是备份文件一切正常
---------------------------------
Directory--> 4,096 /install/ [Sent]
Normal File--> 156,854 /install/test.rpm [Sent]
Selective Backup processing of '/install/test.rpm' finished without failure.
Total number of objects inspected: 2
Total number of objects backed up: 2
Total number of objects updated: 0
Total number of objects rebound: 0
Total number of objects deleted: 0
Total number of objects expired: 0
Total number of objects failed: 0
Total number of bytes inspected: 157.17 KB
Total number of bytes transferred: 153.20 KB
Data transfer time: 230.39 sec
Network data transfer rate: 0.66 KB/sec
Aggregate data transfer rate: 0.65 KB/sec
Objects compressed by: 0%
Total data reduction ratio: 2.53%
Elapsed processing time: 00:03:53
------------------------------------------------------------------------
麻烦帮忙分析下 是什么原因造成的
客户迁移机房后,使用TSM进行Oracle备份时出现错误。具体错误信息为ORA-19502:在文件db_DEV_1112_3902559952_20131207第943233块写入时发生错误。同时,被写入的磁带变为只读状态。
1309

被折叠的 条评论
为什么被折叠?



