TSM+RAC备份arch报错ORA-12154
RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-12001: could not open channel c1...显示全部
查看其它 2 个回答lscomeon的回答
备份archivelog的脚本不对呗
- [此评论已删除]
- 求教脚本？RAC+TSM+ARCH归档备份，脚本在节点一定时执行备份所有节点的归档日志，谢谢！！！！！！
- 来分析分析你的脚本比较好，总得知道原因吧
- #!/bin/ksh dsmadmc -id=********* -password=********* ASSIGN DEFMGMTCLASS ORA_DM STANDARD ORARAC_MGMT dsmadmc -id=********* -password=********* activate policy ORA_DM STANDARD dt=`date +%Y%m%d` export ORACLE_SID=********* rman target / >/home/oracle/log/arch_$dt.log << EOF run{ CONFIGURE BACKUP OPTIMIZATION ON; CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE DEFAULT DEVICE TYPE TO 'sbt_tape'; CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 900 DAYS; configure controlfile autobackup format for device type 'sbt_tape' to 'controlfile_spfile_archdb_%F'; allocate channel c1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' connect "*********"; allocate channel c2 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' connect "*********"; sql "alter system archive log current"; backup format 'rman_racdb_arch_%U_%T.bak' archivelog all delete input; release channel c1; release channel c2; } exit; EOF 以上是备份脚本，请大侠指教。
- 结合你的备份脚本和报错信息来看，由于allocate channel使用了connect，报错信息ORA-12154: TNS:could not resolve the connect identifier specified和这个有关系，这样可以查下连接不上的错误，也可以直接把connect去掉， allocate channel c1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' ; allocate channel c2 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'"; 不知道什么环境，为什么要用connect呢？
- ASM+RAC环境，我要用TSM备份每一个节点的归档日志，connect是连接节点的意思
- 要么去掉，要么连接串改对，应该就可以了
- 谢谢，已弄好了。