tsm备份报错

环境:AIX 5.3        tsm 6.2        oracle11g问题描述:# lsbkdb_bprod.log   bklog_bprod.log  expirebprod.log# more bkdb*Recovery Manager: Release 11.2.0.1.0 - Production on T...显示全部
环境:AIX 5.3
        tsm 6.2
        oracle11g
问题描述:
# ls
bkdb_bprod.log   bklog_bprod.log  expirebprod.log
# more bkdb*
Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 14 23:00:00 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
connected to target database: BPROD (DBID=856828653)
connected to recovery catalog database
RMAN> run {
2> allocate channel ch1 type 'SBT_TAPE' parms  'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo_bprod.opt)';
3> allocate channel ch2 type 'SBT_TAPE' parms  'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo_bprod.opt)';
4> backup incremental level 0 format 'inc0_%d_%s_%p_%T' filesperset 20 database tag levelbackup0;
5> backup current controlfile format 'ctl_%d_%T_%s_%p';
6> sql 'alter system archive log current';
7> release channel ch1;
8> release channel ch2;
9> }
10>
11>
allocated channel: ch1
channel ch1: SID=255 device type=SBT_TAPE
channel ch1: Data Protection for Oracle: version 5.4.1.0
allocated channel: ch2
channel ch2: SID=319 device type=SBT_TAPE
channel ch2: Data Protection for Oracle: version 5.4.1.0
Starting backup at 14-JUN-11
channel ch1: starting incremental level 0 datafile backup set
channel ch1: specifying datafile(s) in backup set
input datafile file number=00005 name=/bi/app/oracle/oradata/bprod/BIEE.DBF
input datafile file number=00007 name=/bi/app/oracle/oradata/bprod/INFAREP.DBF
input datafile file number=00009 name=/bi/app/oracle/oradata/bprod/BIEE2.DBF
input datafile file number=00011 name=/bi/app/oracle/oradata/bprod/INFAREP1.DBF
input datafile file number=00004 name=/bi/app/oracle/oradata/bprod/users01.dbf
input datafile file number=00002 name=/bi/app/oracle/oradata/bprod/sysaux01.dbf
channel ch1: starting piece 1 at 14-JUN-11
channel ch2: starting incremental level 0 datafile backup set
channel ch2: specifying datafile(s) in backup set
input datafile file number=00006 name=/bi/app/oracle/oradata/bprod/INFADOMAIN.DBF
input datafile file number=00008 name=/bi/app/oracle/oradata/bprod/BIEE1.DBF
input datafile file number=00010 name=/bi/app/oracle/oradata/bprod/INFADOMAIN1.DBF
input datafile file number=00003 name=/bi/app/oracle/oradata/bprod/undotbs01.dbf
input datafile file number=00012 name=/bi/app/oracle/oradata/bprod/undotbs02.dbf
input datafile file number=00001 name=/bi/app/oracle/oradata/bprod/system01.dbf
channel ch2: starting piece 1 at 14-JUN-11
channel ch1: finished piece 1 at 14-JUN-11
piece handle=inc0_BPROD_3806_1_20110614 tag=LEVELBACKUP0 comment=API Version 2.0,MMS Version 5.4.1.0
channel ch1: backup set complete, elapsed time: 00:02:35
RMAN-03009: failure of backup command on ch2 channel at 06/14/2011 23:25:58
ORA-19502: write error on file "inc0_BPROD_3807_1_20110614", block number 1 (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 ch2 disabled, job failed on it will be run on another channel
channel ch1: starting incremental level 0 datafile backup set
channel ch1: specifying datafile(s) in backup set
input datafile file number=00006 name=/bi/app/oracle/oradata/bprod/INFADOMAIN.DBF
input datafile file number=00008 name=/bi/app/oracle/oradata/bprod/BIEE1.DBF
input datafile file number=00010 name=/bi/app/oracle/oradata/bprod/INFADOMAIN1.DBF
input datafile file number=00003 name=/bi/app/oracle/oradata/bprod/undotbs01.dbf
input datafile file number=00012 name=/bi/app/oracle/oradata/bprod/undotbs02.dbf
input datafile file number=00001 name=/bi/app/oracle/oradata/bprod/system01.dbf
channel ch1: starting piece 1 at 14-JUN-11
channel ch1: finished piece 1 at 14-JUN-11
piece handle=inc0_BPROD_3808_1_20110614 tag=LEVELBACKUP0 comment=API Version 2.0,MMS Version 5.4.1.0
channel ch1: backup set complete, elapsed time: 00:02:25
Finished backup at 14-JUN-11
Starting backup at 14-JUN-11
channel ch1: starting full datafile backup set
channel ch1: specifying datafile(s) in backup set
including current control file in backup set
channel ch1: starting piece 1 at 14-JUN-11
channel ch1: finished piece 1 at 14-JUN-11
piece handle=ctl_BPROD_20110614_3809_1 tag=TAG20110614T232827 comment=API Version 2.0,MMS Version 5.4.1.0
channel ch1: backup set complete, elapsed time: 00:00:03
Finished backup at 14-JUN-11
Starting Control File and SPFILE Autobackup at 14-JUN-11
piece handle=c-856828653-20110614-01 comment=API Version 2.0,MMS Version 5.4.1.0
Finished Control File and SPFILE Autobackup at 14-JUN-11
sql statement: alter system archive log current
released channel: ch1
released channel: ch2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of release command at 06/14/2011 23:28:44
RMAN-06012: channel: ch2 not allocated
Recovery Manager complete.


问题出在什么地方?如何解决?收起
参与16

查看其它 14 个回答anyport的回答

anyportanyport技术经理金欧利
tsm: TSM>q node CRMSERVER_ORA format=detailed

                     Node Name: CRMSERVER_ORA
                      Platform: TDP Oracle AIX
               Client OS Level: 5.3
                Client Version: Version 6, release 2, level 1.0
            Policy Domain Name: ORA_DOM
         Last Access Date/Time: 06/15/11   04:07:01
        Days Since Last Access: <1
        Password Set Date/Time: 01/07/11   14:52:49
       Days Since Password Set: 159
         Invalid Sign-on Count: 0
                       Locked?: No
                       Contact:
                   Compression: Client
       Archive Delete Allowed?: Yes
        Backup Delete Allowed?: Yes
        Registration Date/Time: 12/17/10   16:04:37
     Registering Administrator: ADMIN
Last Communication Method Used: Tcp/Ip
   Bytes Received Last Session: 2,287
       Bytes Sent Last Session: 2,705
      Duration of Last Session: 2.29
   Pct. Idle Wait Last Session: 3.45
  Pct. Comm. Wait Last Session: 70.49
more...   ( to continue, 'C' to cancel)

  Pct. Media Wait Last Session: 3.71
                     Optionset:
                           URL:
                     Node Type: Client
    Password Expiration Period: 0 Day(s)
             Keep Mount Point?: No
  Maximum Mount Points Allowed: 2
        Auto Filespace Rename : No
             Validate Protocol: No
                   TCP/IP Name: CRMSERVER
                TCP/IP Address: 172.16.0.53
            Globally Unique ID: e4.7a.52.1a.f0.99.11.df.b1.11.00.21.5e.8a.58.48
         Transaction Group Max: 0
               Data Write Path: ANY
                Data Read Path: ANY
            Session Initiation: ClientOrServer
            High-level Address:
             Low-level Address:
        Collocation Group Name:
              Proxynode Target:
               Proxynode Agent:
                   Node Groups:
                 Email Address:
                 Deduplication: ServerOnly
more...   ( to continue, 'C' to cancel)

                Client OS Name:
Client Processor Architecture:
         Client Target Version: (?)
互联网服务 · 2011-06-15
浏览1023

回答者

anyport
技术经理金欧利

anyport 最近回答过的问题

回答状态

  • 发布时间:2011-06-15
  • 关注会员:1 人
  • 回答浏览:1023
  • X社区推广