2017-06-30 DBA日记，ora-19511及RMAN-06207的诊断和处理

 
 

  
  问题:
 
 
 
 

  
  今天备份工程师向我反馈，在将数据库备份从磁盘备份到虚拟带库时，出现如下错误：
 
 
 
 

  
  错误1：
 
 
 
 

  
  RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due
 
 
 
 

  
  RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status
 
 
 
 

  
  RMAN-06210: List of Mismatched objects
 
 
 
 

  
  RMAN-06211: ==========================
 
 
 
 

  
  RMAN-06212:   Object Type   Filename/Handle
 
 
 
 

  
  RMAN-06213: --------------- ---------------------------------------------------
 
 
 
 

  
  RMAN-06214: Datafile Copy   +DATADG/XX/datafile/system.400.941188195
 
 
 
 

  
  错误2：
 
 
 
 

  
  ORA-19511: Error received from media manager layer, error text:
 
 
 
 

  
     VxBSASendData: Failed with error:
 
 
 
 


 
 
 
 

  
  分析：
 
 
 
 

  
  2.1 具体描述：
 
 
 
 

  
  0）执行备份到本地磁盘的脚本时，不会出现错误2，但会出现错误1。执行备份到虚拟带
 
 
 
 

  
       库脚本时，错误1和2都出现。
 
 
 
 

  
  1）在执完备份后， 备份脚本会自动执行delete obsolete; 然后在这个命令执行过程中，	 
 
 
 
 

  
        就出现错误1。
 
 
 
 

  
  2） 在执行备份过程中，会出现错误2，会提示某条备份通道中断了，然后会重新建立通
 
 
 
 

  
         道再继执行。
 
 
 
 

  
  2.2 数据收集
 
 
 
 

  
  0） GOOGLE百度收集一些案例。
 
 
 
 

  
  1） ORACLE官方技术支持库收集一些案例。"
  
  Rman duplicate to Alternate server from tape Fails with ORA-19511 (文档 ID 2144340.1)"
 
 
 
 

  
  2.3 分析
 
 
 
 

  
  评估收集的案例是否对现在运行状态构成影晌。经评估，不会。
 
 
 
 

  
  结论：
 
 
 
 

  
   3.1 针对错误1，执行如下命令修正：
 
 
 
 

  
  rman target /
 
 
 
 

  
  crosscheck datafilecopy 'DATADG/XX/datafile/system.400.941188195';
 
 
 
 

  
  delete obsolete;
 
 
 
 

  
  3.2 针对错误oracle给出的解决方案：
 
 
 
 

  
  将send命令后的参数集成在allocate channel中，按如下方式修正代码:
 
 
 
 

  
  ALLOCATE AUXILIARY CHANNEL CH1 TYPE 'SBT_TAPE';
 
 
 
 

  
  SEND 'NSR_ENV=(NSR_SERVER=NetworkerServer.domain.com, NSR_CLIENT=sourceServer.domain.com)';
 
 
 
 


 
 
 
 

  
  to:
 
 
 
 

  
  ALLOCATE AUXILIARY CHANNEL CH1 TYPE 'SBT_TAPE' PARMS 'ENV=(NSR_SERVER=NetworkerServer.domain.com,NSR_CLIENT=sourceServer.domain.com)';
 
 
 
 

  
  结果：	
 
 
 
 

  
  错误1消除，错误2待观察。
 
 
 
 

  
  错误2有oracle提供的方法，无法解决，后经详细查发现，数据库主机无法正确反向解释nbu的主机，导致还原时检查失败，无法正确反向解释nbu的主机的原因是，数据库主机配置了DNS解释，但DNS解释出错，所以转为hosts文件解释即可，
 
 
 
 

  
  在/etc/netsvc.conf添加了以下2行内容
 
 
 
 

  
  hosts=local,nis,bind
 
 
 
 

  
  alias =files,nis
 
 
 
 


 
 
 
 


 
 
 
 

  
  附录一：Rman duplicate to Alternate server from tape Fails with ORA-19511 (文档 ID 2144340.1)	
 
 
 
 


 
 
 
 

  
  In this Document
 
 
 
 

  
  Symptoms
 
 
 
 

  
  Cause
 
 
 
 

  
  Solution
 
 
 
 

  
   	Applies to:
 
 
 
 

  
  References
 
 
 
 


 
 
 
 

  
  APPLIES TO:
 
 
 
 


 
 
 
 

  
  Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
 
 
 
 

  
  Information in this document applies to any platform.
 
 
 
 

  
  SYMPTOMS
 
 
 
 


 
 
 
 

  
   Rman duplicate being performed to Alternate server using tape backup.
 
 
 
 


 
 
 
 

  
   Rman backup taken by NSR_Client on Source database.
 
 
 
 


 
 
 
 

  
   Rman duplicate failed with below errors
 
 
 
 


 
 
 
 
 
 
 
 
 


 
 
 
 

  
  RMAN-08016: channel CH1: starting datafile backup set restore
 
 
 
 

  
  RMAN-08021: channel CH1: restoring control file
 
 
 
 

  
  RMAN-08003: channel CH1: reading from backup piece c-3200000030-20160716-0
 
 
 
 

  
  RMAN-08615: channel CH1: ORA-19870: error while restoring backup piece c-3200000030-20160716-01
 
 
 
 

  
  ORA-19507: failed to retrieve sequential file, handle="c-3200000030-20160716-0", parms=""
 
 
 
 

  
  ORA-27029: skgfrtrv: sbtrestore returned error
 
 
 
 

  
  ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
 
 
 
 

  
  Could not locate the backup piece 'c-3200000030-20160716-01' on the NetWorker server 'test.abc.com' for the client 'clienta.abc.com'. Notify the backup administator. (2:9:0)
 
 
 
 


 
 
 
 
 
 
 
 
 


 
 
 
 
 
 
 
 
 


 
 
 
 

  
  Syntax  used for Duplicate
 
 
 
 


 
 
 
 
 
 
 
 
 


 
 
 
 

  
  RUN
 
 
 
 

  
  {
 
 
 
 

  
  ALLOCATE AUXILIARY CHANNEL CH1 TYPE 'SBT_TAPE';
 
 
 
 


 
 
 
 

  
  SEND 'NSR_ENV=(NSR_SERVER=test.abc.com, NSR_CLIENT=clienta.abc.com)';
 
 
 
 


 
 
 
 

  
  set until time "to_date(to_char(sysdate-1,'yyyy/mm/dd') || ' 23:45:00','yyyy/mm/dd hh24:mi:ss')";
 
 
 
 


 
 
 
 

  
  CAUSE
 
 
 
 


 
 
 
 

  
  NSR_CLIENT  ---> Name of the NetWorker client resource used to perform the backup
 
 
 
 


 
 
 
 

  
  NSR_SERVER --->Hostname of the NetWorker backup server used to perform the Oracle backup
 
 
 
 


 
 
 
 

  
  Here source is the original production database and target is the auxiliary instance.
 
 
 
 


 
 
 
 

  
  According to Network support, the  client (NSR_Client of Source  where backup was taken) information which was set in the allocate channel command was being lost  for the auxiliary instance when the auxiliary database was stopped/started during duplicate process, and the  information of auxiliary server  NSR_Client was being used afterwards. As the target database was never backed up to Networker using the NSR_Client of auxiliary server, there were no backups to be found.
 
 
 
 


 
 
 
 

  
  The information in the SEND command does not persist through a restart of the database. The PARMS keyword appears to cause the client information to persist through the entire duplicate operation.
 
 
 
 


 
 
 
 
 
 
 
 
 


 
 
 
 

  
  SOLUTION
 
 
 
 


 
 
 
 

  
  In this Document
 
 
 
 


 
 
 
 
 
 
 
 
 


 
 
 
 

  
  The issue was resolved by Change SEND command to PARMS
 
 
 
 


 
 
 
 

  
  ALLOCATE AUXILIARY CHANNEL CH1 TYPE 'SBT_TAPE';
 
 
 
 

  
  SEND 'NSR_ENV=(NSR_SERVER=NetworkerServer.domain.com, NSR_CLIENT=sourceServer.domain.com)';
 
 
 
 


 
 
 
 

  
  to:
 
 
 
 

  
  ALLOCATE AUXILIARY CHANNEL CH1 TYPE 'SBT_TAPE' PARMS 'ENV=(NSR_SERVER=NetworkerServer.domain.com,NSR_CLIENT=sourceServer.domain.com)';
 
 
 
 


 
 
 
 
 
 
 
 
 


 
 
 
 
 
 
 
 
 


 
 
 
 

  
   	References
 
 
 
 

  
  Created from SR 3-12359927521
 
 
 
 


 
 
 
 

  
  APPLIES TO:
 
 
 
 


 
 
 
 

  
  Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
 
 
 
 

  
  1-914CU