|
|
|
NetBackup политика для оракла под windows
|
|||
|---|---|---|---|
|
#18+
Существует политика NetBackup на сервере c OS Solaris, осуществляющая бекапирование оракловой базы под Windows. С недавних пор эта политика стала отрабатываться со статусом 29 (1: (29) failed trying to exec a command). текст скрипта @setlocal ENABLEEXTENSIONS @echo on @if "%NB_ORA_FULL%" EQU "1" ( @set BACKUP_TYPE=INCREMENTAL Level=0 @set RMAN_LOG_FILE=backup_database_full.out ) @if "%NB_ORA_INCR%" EQU "1" ( @set BACKUP_TYPE=INCREMENTAL Level=1 @set RMAN_LOG_FILE=backup_database_incremental.out ) @if "%NB_ORA_CINC%" EQU "1" ( @set RMAN_LOG_FILE=backup_archivelog.out ) @set MUTEX=c:\temp\active_backup @set ORACLE_HOME=C:\oracle\product\10.2.0\db_1\ @set ORACLE_SID=ONLRES @set TARGET_CONNECT_STR=/ @set RMAN=%ORACLE_HOME%\bin\rman.exe @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 @echo USER: %USERNAME% >> %RMAN_LOG_FILE% @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 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% @:START @if not exist %MUTEX% goto start_backup @echo MUTEX exist %MUTEX% >> %RMAN_LOG_FILE% @timeout /t 120 @goto START @:start_backup @mkdir %MUTEX% @echo MUTEX created %MUTEX% >> %RMAN_LOG_FILE% @if NOT DEFINED BACKUP_TYPE ( @( echo RUN { echo ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE'; echo BACKUP echo FILESPERSET 20 echo FORMAT 'arch-s%%s-p%%p' echo ARCHIVELOG ALL DELETE ALL INPUT; echo RELEASE CHANNEL ch00; echo } ) | %RMAN% target %TARGET_CONNECT_STR% catalog rmcat/lak23shem@tjkrmcat msglog '%RMAN_LOG_FILE%' append ) else ( @( echo RUN { echo ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE'; echo BACKUP echo %BACKUP_TYPE% echo FORMAT 'bk_u%%u_s%%s_p%%p_t%%t' echo DATABASE; echo sql 'alter system archive log current'; echo RELEASE CHANNEL ch00; 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 ALL; echo RELEASE CHANNEL ch00; echo } ) | %RMAN% target %TARGET_CONNECT_STR% catalog rmcat/lak23shem@tjkrmcat msglog '%RMAN_LOG_FILE%' append) @set ERRLEVEL=%ERRORLEVEL% @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 @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% @rmdir %MUTEX% @echo MUTEX deleted %MUTEX% >> %RMAN_LOG_FILE% @endlocal все ли нормально в нем? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 01.07.2010, 10:54 |
|
||
|
NetBackup политика для оракла под windows
|
|||
|---|---|---|---|
|
#18+
пути я проверил - они есть. скрипт попробовал в ручную запустить на виндовом сервре - выдал сообщение P:\>backup_database.bat The syntax of the command is incorrect. P:\>@echo ==== started on 01.07.2010 11:56 ==== >> P:\> ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 01.07.2010, 10:57 |
|
||
|
|

start [/forum/topic.php?fid=25&gotonew=1&tid=1484849]: |
0ms |
get settings: |
6ms |
get forum list: |
9ms |
check forum access: |
2ms |
check topic access: |
2ms |
track hit: |
164ms |
get topic data: |
6ms |
get first new msg: |
4ms |
get forum data: |
2ms |
get page messages: |
30ms |
get tp. blocked users: |
1ms |
| others: | 208ms |
| total: | 434ms |

| 0 / 0 |
