- 论坛徽章:
- 0
|
回复 3# yoyosys
我错了, 排错一个备份问题的时候, 因为通过NBU GUI来 调RMAN脚本 会出问题, 以为是RMAN脚本的问题,所以直接copy出脚本在RMAN里用，后来发现这是不行的，直接用rman backup的时候，不能用变量的。
另外我这个错的最终原因是因为在于 oracle用户使用了bash. (AIX 6.1平台）。
看我的rman log.
oracle用户的默认bash是bash时，
…………………………………………………………………………………………………………………………………………………..
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12162: TNS:net service name is incorrectly specified
Recovery Manager: Release 10.2.0.1.0 - Production on Sat Jun 25 17:15:21 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
………………………………………………………………………………………………………………………………………………………….
通常，这种错误是由于错误设置 ORACLE_SID or ORACLE_HOME,但在我们的环境里，ORACLE_SID和 ORACLE_HOME设置没有问题。
root@p5201/#su - oracle
p5201:/opt/oracle # env
AUTHSTATE=files
SHELL=/usr/bin/bash
TERM=vt100
CRS_HOME=/opt/oracle/crs
UMASK=022
LOCPATH=/usr/lib/nls/loc
USER=oracle
ORACLE_SID=jetdb1
ODMDIR=/etc/objrepos
ORACLE_BASE=/opt/oracle
MAIL=/usr/spool/mail/oracle
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java6_64/jre/bin:/usr/java6_64/bin:/opt/VRTSperl/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java6_64/jre/bin:/usr/java6_64/bin:/usr/sbin:/usr/local/bin:/usr/openv/netbackup/bin:/usr/openv/netbackup/bin/admincmd:/opt/VRTSat/bin:/opt/VRTSaz/bin:/opt/VRTS/bin:/opt/VRTSvcs/bin:/opt/oracle/crs/bin:/opt/oracle/db/bin:/opt/oracle/crs/bin:/opt/oracle/db/bin:/usr/openv/netbackup/bin:/opt/VRTS/bin:/opt/VRTSvcs/bin:/opt/VRTSvcs/rac/bin:/usr/openv/netbackup/bin:/usr/lib/vxvm/bin:/usr/sbin:/sbin:/sbin/init.d:/opt/VRTS/bin:/opt/VRTSvcs/bin:/lib/svc/method:/usr/lib/vxvm/bin::/lib/svc/method:/usr/sfw/bin:/opt/VRTSsfmh/bin:/usr/openv/netbackup/bin/goodies:/usr/openv/netbackup/bin:/opt/VRTSat/bin:/usr/openv/netbackup/bin/admincmd:/usr/openv/volmgr/bin:/opt/oracle/bin
LOGIN=oracle
PWD=/opt/oracle
LANG=en_US
TZ=Asia/Shanghai
PS1=p5201 PWD #
SHLVL=1
HOME=/opt/oracle
LC__FASTMSG=true
MAILMSG=[YOU HAVE NEW MAIL]
LOGNAME=oracle
DISPLAY=172.29.1.44:1.0
ORACLE_HOME=/opt/oracle/db
_=/usr/bin/env
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
LD_LIBRARY_PATH=/opt/oracle/db/lib:/usr/lib
当将oracle用户的shell设成ksh(default shell) , 备份 ok .
．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．
root@p5201/var/tmp#tail -f rman1.log
Recovery Manager: Release 10.2.0.1.0 - Production on Sat Jun 25 17:47:29 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: JETDB (DBID=2076786250)
using target database control file instead of recovery catalog
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10>
allocated channel: ch00
channel ch00: sid=128 instance=jetdb1 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.1 (2011020322)
sent command to channel: ch00
Starting backup at 25-JUN-11
channel ch00: starting incremental level 0 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00004 name=/oradata/jetdb/users01.dbf
channel ch00: starting piece 1 at 25-JUN-11
channel ch00: finished piece 1 at 25-JUN-11
piece handle=df_22_1_754768060 tag=TAG20110625T174740 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:00:26
Finished backup at 25-JUN-11
sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT
released channel: ch00
RMAN>
Recovery Manager complete.
．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．．
很早之间就听我身边的资深同事说过不要在aix里设置默认shell为bash,说会导致很多莫名的原因，果不其然。大家引以为戒吧。
实在想用bash,可安装，但不要将默认shell( /etc/passwd里对应的shell)改为bash,可直接bash后使用bashell. |
|
免费注册
发表于 2011-06-24 17:15
发表于 2011-08-06 09:48