使用TSM 备份出现如下错误
RMAN-03009: failure of backup command on ch00 channel at 01/26/2015 19:33:59
ORA-19502: write error on file "db_HZWSJ_2177_1_01_26", block number 1 (block size=8192)
ORA-27030: sk**rt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
ANS0326E (RC41) This node has exceeded its maximum number of mount points.
channel ch00 disabled, job failed on it will be run on another channel
channel ch01: finished piece 1 at 26-JAN-15
经查资料:
RMAN-03009: failure of backup command on ch00 channel at 01/26/2015 19:33:59
ORA-19502: write error on file "db_HZWSJ_2177_1_01_26", block number 1 (block size=8192)
ORA-27030: sk**rt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
ANS0326E (RC41) This node has exceeded its maximum number of mount points.
channel ch00 disabled, job failed on it will be run on another channel
channel ch01: finished piece 1 at 26-JAN-15
经查资料:
RMAN backup of Oracle database may fail with ANS0326E (RC41)
Technote (troubleshooting)
Problem(Abstract)
RMAN backup may fail unexpectedly with message ANS0326E (RC41), indicating that the maximum number of mount points exceeded.
Symptom
RMAN may terminate a channel with error
ORA-19511: Error received from media manager layer, error text:
ANS0326E (RC41) This node has exceeded its maximum number of mount points.
RMAN-12018: channel t4 disabled, job failed on it will be run on another channel.
This might be logged on processing of the second or of a following backup piece by this RMAN channel, although setting of MAXNUMMP is the same as the number of RMAN channels.
Cause
The Tivoli Storage Manager Server and the client (in this case the Data Protection for Oracle) work asynchronously after ending a session.
In case of a Library Server / Library Client configuration it might take longer to release a mountpoint. So, a new session, requesting a new mountpoint, exceeds the maximum number of mountpoints, set for this node.
Diagnosing the problem
The 'Maximum Mount Points Allowed (MAXNUMMP)' value can be found on the Node definition on TSM Server via the 'query node {nodename} f=d' command.
Resolving the problem
Increase / up to double the setting for MAXNUMMP for the Oracle node, in case the above issue is faced. Use this command:
>UPDate NOde {nodename} MAXNUMMP={value}
This will have no long-term side-effects as the Tivoli Data Protection option (in the above case the number of allocated RMAN channel) will throttle the resource use to the expected level.
Problem(Abstract)
RMAN backup may fail unexpectedly with message ANS0326E (RC41), indicating that the maximum number of mount points exceeded.
Symptom
RMAN may terminate a channel with error
ORA-19511: Error received from media manager layer, error text:
ANS0326E (RC41) This node has exceeded its maximum number of mount points.
RMAN-12018: channel t4 disabled, job failed on it will be run on another channel.
This might be logged on processing of the second or of a following backup piece by this RMAN channel, although setting of MAXNUMMP is the same as the number of RMAN channels.
Cause
The Tivoli Storage Manager Server and the client (in this case the Data Protection for Oracle) work asynchronously after ending a session.
In case of a Library Server / Library Client configuration it might take longer to release a mountpoint. So, a new session, requesting a new mountpoint, exceeds the maximum number of mountpoints, set for this node.
Diagnosing the problem
The 'Maximum Mount Points Allowed (MAXNUMMP)' value can be found on the Node definition on TSM Server via the 'query node {nodename} f=d' command.
Resolving the problem
Increase / up to double the setting for MAXNUMMP for the Oracle node, in case the above issue is faced. Use this command:
>UPDate NOde {nodename} MAXNUMMP={value}
This will have no long-term side-effects as the Tivoli Data Protection option (in the above case the number of allocated RMAN channel) will throttle the resource use to the expected level.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26764973/viewspace-1419577/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26764973/viewspace-1419577/