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

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

0

积分

1

好友

2

主题
1#
发表于 2013-11-6 13:15:46 | 查看: 7435| 回复: 4
环境:
系统:aix6
数据库:oracle 11g
带库ts3100

利用rman备份到到带库,
rman提示错误如下:
channel t4: starting piece 1 at 05-NOV-13
RMAN-03009: failure of backup command on t1 channel at 11/05/2013 12:01:19
ORA-19502: write error on file "dbfull_830692872_13684_1", blockno 6657 (blocksi
ze=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
   ANS0352E (RC30)   The operation is not permitted due to server licenses value
s.
channel t1 disabled, job failed on it will be run on another channel
RMAN-03009: failure of backup command on t2 channel at 11/05/2013 12:01:20
ORA-19502: write error on file "dbfull_830692872_13685_1", blockno 8193 (blocksi
ze=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
   ANS0352E (RC30)   The operation is not permitted due to server licenses value
s.
channel t2 disabled, job failed on it will be run on another channel
RMAN-03009: failure of backup command on t3 channel at 11/05/2013 12:01:20
ORA-19502: write error on file "dbfull_830692872_13686_1", blockno 35841 (blocks
ize=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
   ANS0352E (RC30)   The operation is not permitted due to server licenses value
s.
channel t3 disabled, job failed on it will be run on another channel
released channel: t1
released channel: t2
released channel: t3
released channel: t4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t4 channel at 11/05/2013 12:01:20
ORA-19502: write error on file "dbfull_830692872_13687_1", blockno 13825 (blocks
ize=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
   ANS0352E (RC30)   The operation is not permitted due to server licenses value
s.

Recovery Manager complete.
#

个人认为:关键在于ORA-19511的错误
疑问:由于服务 licenses 值的问题这个操作不允许
是不是由于tsm的licenses问题呢?
由于不是本人建的tsm server,没有登录到tsm server的口令,所以无法确认。
大家能否根据错误提示,给些建议?
谢谢
2#
发表于 2013-11-6 13:31:23
报错信息很明确,licenses的问题
这个licenses 不可能是 TS3100 限制的;
应该是 TSM for Oracle 的 licenses 限制,具体的咨询TSM管理员哈;

回复 只看该作者 道具 举报

3#
发表于 2013-11-6 13:32:50
ORA-19502: write error on file "dbfull_830692872_13687_1", blockno 13825 (blocks
ize=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
   ANS0352E (RC30)   The operation is not permitted due to server licenses value
s.

rman 返回带库中的信息:The operation is not permitted due to server licenses value
很可能是是licenses问题,建议联系tsm

回复 只看该作者 道具 举报

4#
发表于 2013-11-6 21:02:06
本帖最后由 xiaoke0044 于 2013-11-6 21:09 编辑
Caleon 发表于 2013-11-6 13:31
报错信息很明确,licenses的问题
这个licenses 不可能是 TS3100 限制的;
应该是 TSM for Oracle 的 lic ...


IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 5, Release 4, Level 1.0
(C) Copyright IBM Corporation 1997, 2007. All rights reserved.


Data Protection for Oracle Information
Version:              5
Release:              4
Level:                1
Sublevel:             0
Platform:             64bit TDP Oracle AIX

Tivoli Storage Manager Server Information
Server Name:          SERVER1
Server Address:       100.100.100.100
Server Type:          Linux/x86_64
Server Port:          1500
Communication Method: TCP/IP

Session Information
Owner Name:
Node Name:            QINGBAO_ORA
Node Type:            TDP Oracle AIX
DSMI_DIR:             /usr/tivoli/tsm/client/api/bin64
DSMI_ORC_CONFIG:      /usr/tivoli/tsm/client/oracle/bin64/dsm.opt
TDPO_OPTFILE:         /usr/tivoli/tsm/client/oracle/bin64/tdpo.opt
Password Directory:   /usr/tivoli/tsm/client/oracle/bin64
Compression:          FALSE
License Information:  License file exists and contains valid license data.

说明tdpo的license是 valid 的。
感谢回答

回复 只看该作者 道具 举报

5#
发表于 2013-11-6 21:04:24
xifenfei 发表于 2013-11-6 13:32
ORA-19502: write error on file "dbfull_830692872_13687_1", blockno 13825 (blocks
ize=512)
ORA-27030: ...

tsm: SERVER1>q license

                                 Last License Audit: 11/05/2013 03:26:12
                    Number of TDP for Oracle in use: 4
           Number of TDP for Oracle in try buy mode: 0
             Number of TDP for MS SQL Server in use: 0
    Number of TDP for MS SQL Server in try buy mode: 0
               Number of TDP for MS Exchange in use: 0
      Number of TDP for MS Exchange in try buy mode: 0
               Number of TDP for Lotus Notes in use: 0
      Number of TDP for Lotus Notes in try buy mode: 0
              Number of TDP for Lotus Domino in use: 0
     Number of TDP for Lotus Domino in try buy mode: 0
                  Number of TDP for Informix in use: 0
         Number of TDP for Informix in try buy mode: 0
                   Number of TDP for SAP R/3 in use: 0
          Number of TDP for SAP R/3 in try buy mode: 0
                       Number of TDP for ESS in use: 0
              Number of TDP for ESS in try buy mode: 0
                   Number of TDP for ESS R/3 in use: 0
          Number of TDP for ESS R/3 in try buy mode: 0
             Number of TDP for EMC Symmetrix in use: 0
    Number of TDP for EMC Symmetrix in try buy mode: 0
more...   (<ENTER> to continue, 'C' to cancel)

         Number of TDP for EMC Symmetrix R/3 in use: 0
Number of TDP for EMC Symmetrix R/3 in try buy mode: 0
                       Number of TDP for WAS in use: 0
              Number of TDP for WAS in try buy mode: 0
     Is IBM System Storage Archive Manager in use ?: No
   Is IBM System Storage Archive Manager licensed ?: No
     Is Tivoli Storage Manager Basic Edition in use: Yes
   Is Tivoli Storage Manager Basic Edition licensed: No
  Is Tivoli Storage Manager Extended Edition in use: No
Is Tivoli Storage Manager Extended Edition licensed: No
                             Try-Buy Days Remaining: -1
                          Server License Compliance: FAILED
谢谢,是它的原因。

回复 只看该作者 道具 举报

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

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

GMT+8, 2024-5-19 11:57 , Processed in 0.048116 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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