ITPub博客

首页 > Linux操作系统 > Linux操作系统 > TSM+ORACLE 备份迁移主机遇到的若干问题及处理过程

TSM+ORACLE 备份迁移主机遇到的若干问题及处理过程

原创 Linux操作系统 作者:mike_salon 时间:2009-05-08 12:30:15 0 删除 编辑

1. 执行备份
nmsdb1:/oracle]$/oracle/scripts/backuparch.sh

Recovery Manager: Release 9.2.0.8.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: NMS (DBID=2513551267)
connected to recovery catalog database

RMAN>
allocated channel: ORA_MAINT_SBT_TAPE_1
channel ORA_MAINT_SBT_TAPE_1: sid=55 devtype=SBT_TAPE
channel ORA_MAINT_SBT_TAPE_1: Tivoli Data Protection for Oracle: version 5.2.0.0

RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of crosscheck command on ORA_MAINT_SBT_TAPE_1 channel at 05/08/2009 10:51:06
ORA-27191: sbtinfo2 returned error
Additional information: 2

RMAN>

 


2.查看TDPO环境,发现tdpo密码失效
nmsdb1[/usr/tivoli/tsm/client/oracle/bin64]#./tdpoconf show

ANU0102E Invalid command: SHOW


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

TDPOCONF SHOWENVironment
[-TDPO_OPTfile=filename] (default: $install_dir/tdpo.opt)
[-OUTFile=filename]

TDPOCONF PASSWord
[-TDPO_OPTfile=filename] (default: $install_dir/tdpo.opt)

TDPOCONF HELP


nmsdb1[/usr/tivoli/tsm/client/oracle/bin64]#./tdpoconf showenv


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


DATA PROTECTION FOR ORACLE INFORMATION
 Version:              5
 Release:              2
 Level:                0
 Sublevel:             0
 Platform.:             64bit TDP Oracle AIX

TSM SERVER INFORMATION
 Server Name:          TDPO
 Server Address:       10.17.7.142
 Communication Method: TCP/IP

SESSION INFORMATION
 Owner Name:          
 Node Name:            nms_serv
 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

ANS0282E (RC168)  Password file is not available.

3. 修改NMS_SERV node 密码
nmsdb1[/usr/tivoli/tsm/client/oracle/bin64]#dsmadmc
IBM Tivoli Storage Manager
Command Line Administrative Interface - Version 5, Release 3, Level 0.0
(c) Copyright by IBM Corporation and other(s) 1990, 2004. All Rights Reserved.

Enter your user id:  admin

Enter your password: 

Session established with server TSM: AIX-RS/6000
  Server Version 5, Release 3, Level 4.0
  Server date/time: 05/08/09   11:02:37  Last access: 05/07/09   22:56:11


tsm: TSM>q node

Node Name                     Platform     Policy Domain      Days Since     Days Since     Locked?
                                           Name               Last Acce-       Password    
                                                                      ss            Set    
-------------------------     --------     --------------     ----------     ----------     -------
CLIENT                        (?)          STANDARD                  669            669       No  
NMS_SERV                      TDP Ora-     STANDARD                    3            669       No  
                               cle AIX                                                            
NMS_SERV1                     AIX          FSBA                       17             17       No  
OSSDB1                        AIX          FSBA                        2              2       No  
OSS_SERV                      TDP Ora-     STANDARD                   <1              2       No  
                               cle AIX                                                            
OSS_SERV2                     AIX          FSBA                       17             17       No  

tsm: TSM>update node nms_serv admin;
ANR2144E UPDATE NODE: Invalid password - Illegal character ';' in password.
ANS8001I Return code 3.

tsm: TSM>update node nms_serv admin
ANR2063I Node NMS_SERV updated.

tsm: TSM>quit

ANS8002I Highest return code was 3.


4. 修改tdpo 密码
nmsdb1[/usr/tivoli/tsm/client/oracle/bin64]#./tdpoconf password


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


***************************************************************
*       IBM Tivoli Storage Manager for Databases Utility             *
*  Password file initialization/update program                *
*     ROOT privilege needed to update value                   *
***************************************************************

Please enter current password:

Please enter new password:

Please reenter new password for verification:

ANU0260I Password successfully changed.

5. 查看TDPO 环境,现在ok了

nmsdb1[/usr/tivoli/tsm/client/oracle/bin64]#./tdpoconf showenv


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


DATA PROTECTION FOR ORACLE INFORMATION
 Version:              5
 Release:              2
 Level:                0
 Sublevel:             0
 Platform.:             64bit TDP Oracle AIX

TSM SERVER INFORMATION
 Server Name:          TDPO
 Server Address:       10.17.7.142
 Server Type:          AIX-RS/6000
 Server Port:          1500
 Communication Method: TCP/IP

SESSION INFORMATION
 Owner Name:          
 Node Name:            nms_serv
 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

nmsdb1[/usr/tivoli/tsm/client/oracle/bin64]#

 

6.再次执行备份测试,报另外的错误
nmsdb1:/oracle]$/oracle/scripts/backuparch.sh

Recovery Manager: Release 9.2.0.8.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: NMS (DBID=2513551267)
connected to recovery catalog database

RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on ORA_MAINT_SBT_TAPE_1 channel at 05/08/2009 10:59:47
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
IBM AIX RISC System/6000 Error: 106: Reserved errno was encountered
Additional information: 7011
ORA-19511: Error received from media manager layer, error text:
   SBT error = 7011, errno = 106, sbtopen: system error

RMAN>

 

7. 发现时tdpoerror.log 没有oracle写权限,修改权限
nmsdb1[/usr/tivoli/tsm/client/oracle/bin64]#ls -l
total 4000
-rw-r--r--   1 root     system           48 May 08 10:57 TDPO.nms_serv
-rwxrw-rw-   1 bin      bin              47 Feb 24 2003  agent.lic
-rw-r--r--   1 root     system           16 May 08 10:46 dsm.opt
drwxr-xr-x   2 root     system          256 May 08 10:44 en_US
-rwxr-xr-x   1 bin      bin          730483 Feb 24 2003  libobk64.a
-rwxrwxr-x   1 root     system          428 May 08 10:46 tdpo.opt
-rwxr-xr-x   1 bin      bin             691 Feb 24 2003  tdpo.opt.smp64
-rwxr-xr-x   1 bin      bin          621511 Feb 24 2003  tdpoconf
-rw-r--r--   1 root     system          177 May 08 10:56 tdpoerror.log
-rwxr-xr-x   1 bin      bin          667033 Feb 24 2003  tdposync
nmsdb1[/usr/tivoli/tsm/client/oracle/bin64]#chmod 777 tdpoerror.log
nmsdb1[/usr/tivoli/tsm/client/oracle/bin64]#

8.再次测试,ok!

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22698/viewspace-594506/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-12-09

  • 博文量
    10
  • 访问量
    41253