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

最新推荐文章于 2021-04-05 03:28:44 发布

ciliao73851

最新推荐文章于 2021-04-05 03:28:44 发布

阅读量477

点赞数

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

Recovery Manager: Release 9.2.0.8.0 - 64bit Production

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>

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

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

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22698/viewspace-594506/