- 论坛徽章:
- 0
|
@setlocal ENABLEEXTENSIONS
@REM -----------------------------------------------------------------
@REM Backup script generated on 12/01/07 12:55:10
@REM Shell Script name: hot_back.cmd
@REM
@REM Veritas NetBackup for oracle on Windows
@REM $VRTScprght: Copyright 1993 - 2007 Symantec Corporation, All Rights Reserved $
@REM -----------------------------------------------------------------
@set RMAN_LOG_FILE="%~dpn0.out"
@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\ora92（根据实际写）
@set ORACLE_SID=ldl（根据实际写）
@set TARGET_CONNECT_STR=sys/pswd（sys密码）
@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 RMIS.
@REM If you are getting an error that the input line is too long, you will need
@REM to put the RMAN run block in a separate file. Then use the "cmdfile"
@REM option of RMAN. For more information on the "cmdfile" options please
@REM refer to the RMAN documentation.
@REM -----------------------------------------------------------------
@(
echo RUN {
echo ALLOCATE CHANNEL ch00
echo TYPE 'SBT_TAPE';
echo BACKUP
echo %BACKUP_TYPE%
echo FORMAT 'bk_u%%u_s%%s_p%%p_t%%t'
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 BACKUP
echo FORMAT 'arch_u%%u_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 BACKUP
echo FORMAT 'ctrl_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 |
|
免费注册
发表于 2010-04-09 13:32
发表于 2010-04-09 21:15
