Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › rman 往带库备份出现ORA-19513 ORA-27206

wengtf

11 积分	0 好友	14 主题

发消息

rman 往带库备份出现ORA-19513 ORA-27206

1^#

发表于 2012-7-19 09:21:15 | 查看: 11813| 回复: 6

OS: Windows 2008 X64 Enterprise Server
DB: Oracle 11.2.0.1
VERITAS Client: Client for Oracle Version 7.0

allocated channel: ch00
channel ch00: SID=23 device type=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.0 (20100104)

allocated channel: ch01
channel ch01: SID=976 device type=SBT_TAPE
channel ch01: Veritas NetBackup for Oracle - Release 7.0 (20100104)

Starting backup at 2012-07-19:08:55:08
channel ch00: starting incremental level 0 datafile backup set
channel ch00: specifying datafile(s) in backup set
input datafile file number=00005 name=D:\APP\ADMINISTRATOR\ORADATA\ORCL\JITE1.DBF
input datafile file number=00007 name=D:\APP\ADMINISTRATOR\ORADATA\ORCL\PDPS.DBF
input datafile file number=00003 name=D:\APP\ADMINISTRATOR\ORADATA\ORCL\UNDOTBS01.DBF
input datafile file number=00004 name=D:\APP\ADMINISTRATOR\ORADATA\ORCL\USERS01.DBF
channel ch00: starting piece 1 at 2012-07-19:08:55:09
channel ch01: starting incremental level 0 datafile backup set
channel ch01: specifying datafile(s) in backup set
input datafile file number=00006 name=D:\APP\ADMINISTRATOR\ORADATA\ORCL\GYS.DBF
input datafile file number=00002 name=D:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSAUX01.DBF
input datafile file number=00001 name=D:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTEM01.DBF
channel ch01: starting piece 1 at 2012-07-19:08:55:09
RMAN-03009: failure of backup command on ch00 channel at 07/19/2012 09:00:55
ORA-19513: failed to identify sequential file
ORA-27206: requested file not found in media management catalog
continuing other job steps, job failed will not be re-run
channel ch00: starting incremental level 0 datafile backup set
channel ch00: specifying datafile(s) in backup set
including current control file in backup set
channel ch00: starting piece 1 at 2012-07-19:09:00:56
RMAN-03009: failure of backup command on ch01 channel at 07/19/2012 09:01:42
ORA-19513: failed to identify sequential file
ORA-27206: requested file not found in media management catalog
continuing other job steps, job failed will not be re-run
channel ch01: starting incremental level 0 datafile backup set
channel ch01: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ch01: starting piece 1 at 2012-07-19:09:01:42
RMAN-03009: failure of backup command on ch00 channel at 07/19/2012 09:03:27
ORA-19513: failed to identify sequential file
ORA-27206: requested file not found in media management catalog
continuing other job steps, job failed will not be re-run
released channel: ch00
released channel: ch01
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch01 channel at 07/19/2012 09:04:32
ORA-19513: failed to identify sequential file
ORA-27206: requested file not found in media management catalog

RMAN>

Recovery Manager complete.

脚本如下：

RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
BACKUP
   %BACKUP_TYPE%
   FORMAT 'bk_u%%u_s%%s_p%%p_t%%t'
   DATABASE;
sql 'alter system archive log current';
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
# Backup all archive logs
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
BACKUP
   FILESPERSET 20
   FORMAT 'arch-s%%s-p%%p'
   ARCHIVELOG LIKE 'D:\archive_log\ARCHIVE%' DELETE INPUT;
RELEASE CHANNEL ch00;
# Backup controlfile
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
BACKUP
   FORMAT 'cntrl_s%%s_p%%p_t%%t'
   CURRENT CONTROLFILE;
RELEASE CHANNEL ch00;
}

注：上述脚本可以再本地备份成功,这个库只有10G，磁带也有空余！
nbu 管理界面，备份任务正常结束，无错误提示；
数据库服务器上用list backup of database；看不到备份到带库结果；
--参照过若干贴无果 - -，mos 上只有一个贴，就是建议更改policy里面，将IP地址改成主机，依旧无果！！请刘大拨云见日！

nbu SERVER (<home>\veritas\netbackup\logs\dbclient）无日志

分享0

收藏0 回复只看该作者道具举报

wengtf

2^#

发表于 2012-7-19 09:39:03

不好意思较多无用内容：

@REM $Header: hot_database_backup.cmd,v 1.3 2005/11/28 19:01:53 $
@REM bcpyrght
@REM ***************************************************************************
@REM * $VRTScprght: Copyright 1993 - 2009 Symantec Corporation, All Rights Reserved $ *
@REM ***************************************************************************
@REM ecpyrght
@REM
@REM ---------------------------------------------------------------------------
@REM hot_database_backup.cmd
。。。省略备份注释内容
@setlocal ENABLEEXTENSIONS
@REM ---------------------------------------------------------------------------
@REM No need to echo the commands.
@REM ---------------------------------------------------------------------------
@echo off
@REM ---------------------------------------------------------------------------
@REM Put output in the same filename, different extension.
@REM ---------------------------------------------------------------------------
@set RMAN_LOG_FILE="%~dpn0.out"
@REM ---------------------------------------------------------------------------
@REM You may want to delete the output file so that backup information does
@REM not accumulate. If not, delete the following command.
@REM ---------------------------------------------------------------------------
@if exist %RMAN_LOG_FILE% del %RMAN_LOG_FILE%
@REM ---------------------------------------------------------------------------
@REM Replace H:\oracle\ora81, below, with the Oracle home path.
@REM ---------------------------------------------------------------------------
@set ORACLE_HOME=D:\app\Administrator\product\11.2.0\dbhome_1
@REM ---------------------------------------------------------------------------
@REM Replace ora81, below, with the Oracle SID.
@REM ---------------------------------------------------------------------------
@set ORACLE_SID=orcl
@REM ---------------------------------------------------------------------------
@REM Replace sys/manager, below, with the target connect string.
@REM ---------------------------------------------------------------------------
@set TARGET_CONNECT_STR=/
@REM ---------------------------------------------------------------------------
@REM Set the Oracle Recovery Manager.
@REM ---------------------------------------------------------------------------
@set RMAN=%ORACLE_HOME%\bin\rman.exe
@REM ---------------------------------------------------------------------------
@REM PROXY
@REM For a PROXY backup, uncomment the line below and replace the value.
@REM
@REM NB_ORA_PC_STREAMS - specifies the number of parallel backup streams
@REM to be started.
@REM ---------------------------------------------------------------------------
@REM @set NB_ORA_PC_STREAMS=3
@REM ---------------------------------------------------------------------------
@REM Log the start of this scripts.
@REM ---------------------------------------------------------------------------
@for /F "tokens=1*" %%p in ('date /T') do @set DATE=%%p %%q
@for /F %%p in ('time /T') do @set DATE=%DATE% %%p
@echo ==== started on %DATE% ==== >> %RMAN_LOG_FILE%
@echo Script name: %0 >> %RMAN_LOG_FILE%
省略部分注释内容.....
@set NLS_LANG=american
@set NLS_DATE_FORMAT=YYYY-MM-DD:hh24:mi:ss
@REM ---------------------------------------------------------------------------
@REM Print out environment variables set in this script.
@REM ---------------------------------------------------------------------------
@echo # >> %RMAN_LOG_FILE%
@echo RMAN : %RMAN% >> %RMAN_LOG_FILE%
@echo NLS_LANG : %NLS_LANG% >> %RMAN_LOG_FILE%
@echo ORACLE_HOME : %ORACLE_HOME% >> %RMAN_LOG_FILE%
@echo ORACLE_SID : %ORACLE_SID% >> %RMAN_LOG_FILE%
@echo NLS_DATE_FORMAT : %NLS_DATE_FORMAT% >> %RMAN_LOG_FILE%
@echo RMAN_LOG_FILE : %RMAN_LOG_FILE% >> %RMAN_LOG_FILE%
@REM ---------------------------------------------------------------------------
@REM PROXY
@REM For a PROXY backup, uncomment the line below.
@REM ---------------------------------------------------------------------------
@REM @echo NB_ORA_PC_STREAMS : %NB_ORA_PC_STREAMS% >> %RMAN_LOG_FILE%
@REM ---------------------------------------------------------------------------
@REM Print out environment variables set in bphdb.
@REM ---------------------------------------------------------------------------
@echo NB_ORA_SERV : %NB_ORA_SERV% >> %RMAN_LOG_FILE%
@echo NB_ORA_FULL : %NB_ORA_FULL% >> %RMAN_LOG_FILE%
@echo NB_ORA_INCR : %NB_ORA_INCR% >> %RMAN_LOG_FILE%
@echo NB_ORA_CINC : %NB_ORA_CINC% >> %RMAN_LOG_FILE%
@echo NB_ORA_CLASS : %NB_ORA_CLASS% >> %RMAN_LOG_FILE%
@REM ---------------------------------------------------------------------------
@REM We assume that the database is properly opened. If desired, this would
@REM be the place to verify that.
@REM ---------------------------------------------------------------------------
@REM ---------------------------------------------------------------------------
@REM If this script is executed from a NetBackup schedule, NetBackup
@REM sets an NB_ORA environment variable based on the schedule type.
@REM For example, when:
@REM schedule type is BACKUP_TYPE is
@REM ---------------- --------------
@REM Automatic Full INCREMENTAL LEVEL=0
@REM Automatic Differential Incremental INCREMENTAL LEVEL=1
@REM Automatic Cumulative Incremental INCREMENTAL LEVEL=1 CUMULATIVE
@REM
@REM For user initiated backups, BACKUP_TYPE defaults to incremental
@REM level 0 (Full). To change the default for a user initiated
@REM backup to incremental or incrementatl cumulative, uncomment
@REM one of the following two lines.
@REM @set BACKUP_TYPE="INCREMENTAL LEVEL=1"
@REM @set BACKUP_TYPE="INCREMENTAL LEVEL=1 CUMULATIVE"
@REM
@REM Note that we use incremental level 0 to specify full backups.
@REM That is because, although they are identical in content, only
@REM the incremental level 0 backup can have incremental backups of
@REM level > 0 applied to it.
@REM ---------------------------------------------------------------------------
@REM ---------------------------------------------------------------------------
@REM What kind of backup will we perform.
@REM ---------------------------------------------------------------------------
@if "%NB_ORA_FULL%" EQU "1" @set BACKUP_TYPE=INCREMENTAL Level=0
@if "%NB_ORA_INCR%" EQU "1" @set BACKUP_TYPE=INCREMENTAL Level=1
@if "%NB_ORA_CINC%" EQU "1" @set BACKUP_TYPE=INCREMENTAL Level=1 CUMULATIVE
@if NOT DEFINED BACKUP_TYPE @set BACKUP_TYPE=INCREMENTAL Level=0
@REM ---------------------------------------------------------------------------
@REM Call Recovery Manager to initiate the backup. This example does not use a
@REM Recovery Catalog. If you choose to use one, remove the option, nocatalog,
@REM from the rman command line below and add a
@REM 'rcvcat <userid>/<passwd>@<tns alias>' statement.
@REM
@REM ---------------------------------------------------------------------------
@REM PROXY
@REM For a PROXY backup, you must use a send command to specify
@REM the NB_ORA_PC_STREAMS environment variable. For example,
@REM echo ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
@REM echo SEND 'NB_ORA_PC_STREAMS=%%NB_ORA_PC_STREAMS%%';
@REM
@REM %BACKUP_TYPE% must also be removed and replaced with the PROXY parameter
@REM in the RMAN section associated with the data files. For example,
@REM echo BACKUP
@REM echo PROXY
@REM echo FORMAT 'bk_u%%u_s%%s_p%%p_t%%t'
@REM echo DATABASE;
@REM .
@REM .
@REM Note that the controlfiles and archivelogs are not backed up using proxy
@REM copy method. Rman will initiate non-proxy copy sessions to backup the
@REM controlfile and archivelogs.
@REM ---------------------------------------------------------------------------
@(
echo RUN {
echo ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
echo ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
echo BACKUP
echo %BACKUP_TYPE%
echo FORMAT 'd:\backup\bk_u%%u_s%%s_p%%p_t%%t'
echo DATABASE;
echo sql 'alter system archive log current';
echo RELEASE CHANNEL ch00;
echo RELEASE CHANNEL ch01;
echo # Backup all archive logs
echo ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
echo BACKUP
echo FILESPERSET 20
echo FORMAT 'arch-s%%s-p%%p'
echo ARCHIVELOG LIKE 'D:\archive_log\ARCHIVE%' DELETE INPUT;
echo RELEASE CHANNEL ch00;
echo # Backup controlfile
echo ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
echo BACKUP
echo FORMAT 'cntrl_s%%s_p%%p_t%%t'
echo CURRENT CONTROLFILE;
echo RELEASE CHANNEL ch00;
echo }
) | %RMAN% target %TARGET_CONNECT_STR% nocatalog msglog '%RMAN_LOG_FILE%' append
@set ERRLEVEL=%ERRORLEVEL%
@set LOGMSG=ended successfully
@if "%STATUS_FILE%" EQU "" goto end
@echo 0 > "%STATUS_FILE%"
@goto end
:err
@set LOGMSG=ended in error
@if "%STATUS_FILE%" EQU "" @goto end
@echo 1 > "%STATUS_FILE%"
:end
@REM ---------------------------------------------------------------------------
@REM Log the completion of this script.
@REM ---------------------------------------------------------------------------
@for /F "tokens=1*" %%p in ('date /T') do @set DATE=%%p %%q
@for /F %%p in ('time /T') do @set DATE=%DATE% %%p
@echo # >> %RMAN_LOG_FILE%
@echo %==== %LOGMSG% on %DATE% ==== >> %RMAN_LOG_FILE%
@endlocal
@REM End of Main Program -----------------------------------------------------

复制代码

回复只看该作者道具举报

lixz_2008

3^#

发表于 2012-7-20 09:53:17

回复 2# 的帖子

1.上传客户端的bpcd、bphdb，服务端的bptm、bprd日志
2.检查客户端与备份服务器的时间差
3.客户端上执行bpclntcmd -pn、bpclntcmd -hn [Hostname]、bpclntcmd -ip [IP]
4.该服务器是否是多网卡？

回复只看该作者道具举报

lixz_2008

4^#

发表于 2012-7-20 10:07:18

回复 3# 的帖子

备份到带库 FORMAT 'd:\backup\bk_u%%u_s%%s_p%%p_t%%t'?

回复只看该作者道具举报

wengtf

5^#

发表于 2012-7-21 08:34:31

回复 4# 的帖子

额，这个备份到本地是我自己做得一个测试！因为开始在群里面有人要求贴出连接的内容，所以把脚本放上来了，具体的备份脚本1楼为准，这么做只是不报错，但无法用 list backup of database 查出备份集！
另：我在服务器客户机上的..netbackup/logs/ 都没找到所需要的目录！

[ 本帖最后由 wengtf 于 2012-7-21 08:54 编辑 ]

回复只看该作者道具举报

Maclean Liu(刘相兵

6^#

发表于 2012-7-22 13:44:15

ODM FINDING:

RMAN backup to SBT_TAPE using Legato Networker fails:

channel t1: starting piece 1 at 11-04-08
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t1 channel at 04/08/2011 11:16:29
ORA-19513: failed to identify sequential file
ORA-27206: requested file not found in media management catalog

Changes
A new DNS alias was created on the Network for the Server or new
Cause
This error is raised whenever the Media Manager, Legato Networker in this case, is unable to write the file to tape.

The creation of new DNS alias can cause index corruption between TAPE and MNO interface inside Networker backup server.

Solution
Delete the host definition inside Networker and recreate it in order to flush bad index.
Also try using client hostname with domain extension instead of using client IP address in Netbackup Master Server while configuring backup policy for client

For further assistance please contact  your media manager vendor .

确认你的NBU 配置乃至 NBU SERVER的  host是否可以正常ping ,  该问题与ORACLE数据库关系不大，  一般问题存在于NBU SERVER 与 CLIENT之间的配置：

也可以参考这篇文章：
图文详解安装NetBackup 6.5备份恢复Oracle 10g rac 数据库(修订)  http://www.oracledatabase12g.com ... tabase-10g-rac.html

回复只看该作者道具举报

wengtf

7^#

发表于 2012-7-24 08:47:11

回复 6# 的帖子

刘大，policy的配置跟我生产库的的配置是一样的，host ping正常，备份的policy我已将client 的ip换成hostname，问题依旧，生产库备份正常！我再仔细想想！

回复只看该作者道具举报

返回列表

		自动登录	找回密码
密码			注册

rman 往带库备份 出现ORA-19513 ORA-27206

回复 2# 的帖子

回复 3# 的帖子

回复 4# 的帖子

回复 6# 的帖子

rman 往带库备份出现ORA-19513 ORA-27206