- 论坛徽章:
- 0
|
我现已经用bpdbsbora bpdbsbora -backup -g oracle -t bkoracle.tpl 生成了脚本文件.并且将ORACLE脚本拷贝到了客户端。备份时也选择了刚才生成的脚本，但是还没有成功，以出现了”the backup failed to back up the requested files(6)“
错误。根据Troubleshooter进行了解决。还是不行。 
以下是我用模板生成的脚本 :
@setlocal ENABLEEXTENSIONS
@REM -----------------------------------------------------------------
@REM Backup script generated on 07/06/07 14:46:32
@REM Shell Script name: oracle
@REM Description: bkoracle
@REM
@REM VERITAS NetBackup for oracle on Windows
@REM $VRTScprght: Copyright 1993 - 2005 VERITAS Software Corporation, All Rights Reserved $
@REM -----------------------------------------------------------------
@set RMAN_LOG_FILE="C:\Program Files\VERITAS\NetBackup\temp\r15828.15824.log"
@REM -----------------------------------------------------------------
@REM Log the start 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 Script %0 > %RMAN_LOG_FILE%
@echo ==== started on %DATE% ==== >> %RMAN_LOG_FILE%
@set ORACLE_HOME=e:\oracle\product\10.2.0\db_1
@set ORACLE_SID=ORCL
@set TARGET_CONNECT_STR=sys/"WARNING: MustAddPassword"
@set RMAN=%ORACLE_HOME%\bin\rman.exe
@REM -----------------------------------------------------------------
@REM The NetBackup script generator determined that a NetBackup Policy
@REM configured for the standard Oracle backup would have been used
@REM when this script was generated.
@REM This script was generated for use with a Policy with the standard
@REM Oracle backup method (i.e. non-proxy).
@REM -----------------------------------------------------------------
@REM -----------------------------------------------------------------
@REM For NetBackup scheduled, or server initiated backups, NetBackup
@REM sets an NB_ORA environment variable based on the schedule type.
@REM The NB_ORA variable is then used to dynamically set BACKUP_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 For user initiated backups BACKUP_TYPE defaults to incremental
@REM level 0 (full). To change this default to incremental or
@REM incremental cumulative, replace INCREMENTAL LEVEL=0 with
@REM INCREMENTAL LEVEL=1 or INCREMENTAL LEVEL=1 CUMULATIVE in
@REM the line below that contains, "@if NOT DEFINED BACKUP_TYPE".
@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
@REM of level > 0 applied to it.
@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 rman commands for database ORCL.
@REM -----------------------------------------------------------------
@(
echo RUN {
echo ALLOCATE CHANNEL ch00
echo TYPE 'SBT_TAPE';
echo SEND 'NB_ORA_CLIENT=client,NB_ORA_POLICY=bkoracle,NB_ORA_SERV=wonder-wanggen,NB_ORA_SCHED=full';
echo BACKUP
echo %BACKUP_TYPE%
echo FORMAT 'bk_u%%u_s%%s_p%%p_t%%t'
echo TAG 'bkoracle'
echo DATABASE;
echo RELEASE CHANNEL ch00;
echo # Backup Archived Logs
echo # For an offline backup, remove the following sql statement
echo sql 'alter system archive log current';
echo ALLOCATE CHANNEL ch00
echo TYPE 'SBT_TAPE';
echo SEND 'NB_ORA_CLIENT=client,NB_ORA_POLICY=bkoracle,NB_ORA_SERV=wonder-wanggen,NB_ORA_SCHED=full';
echo BACKUP
echo FORMAT 'arch-s%%s-p%%p-t%%t'
echo ARCHIVELOG
echo ALL
echo DELETE INPUT;
echo RELEASE CHANNEL ch00;
echo # Control file backup
echo ALLOCATE CHANNEL ch00
echo TYPE 'SBT_TAPE';
echo SEND 'NB_ORA_CLIENT=client,NB_ORA_POLICY=bkoracle,NB_ORA_SERV=wonder-wanggen,NB_ORA_SCHED=full';
echo BACKUP
echo FORMAT 'bk_u%%u_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%
@REM -----------------------------------------------------------------
@REM When this script is started as part of a scheduled
@REM backup, STATUS_FILE is used to communicate status
@REM information to the NetBackup job monitor.
@REM -----------------------------------------------------------------
@if %ERRLEVEL% NEQ 0 @goto err
@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 Script %0 >> %RMAN_LOG_FILE%
@echo ==== %LOGMSG% on %DATE% ==== >> %RMAN_LOG_FILE%
@endlocal
|
|
免费注册
楼主: rocket123
发表于 2007-07-05 15:27
我是尽量让大家了解我的环境。但是我已经用模板里生成的RMAN命令在ORACLE的RMAN里执行过了，而且也可以备份成功。还请指点一下是脚本里的什么地方出错了，谢谢
