免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
1234下一页
最近访问板块 发新帖
查看: 14117 | 回复: 39
打印 上一主题 下一主题

[Veritas NBU] NBU低级问题请教 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2009-06-27 20:59 |只看该作者 |倒序浏览
环境:
NBU:6.5
oracle: 10g (装在master server上)
OS: windows2003


NBU调用的rman的备份脚本改自NBU模板hot_database_backup.cmd .测试备份时,报错NBU返回status 6, RMAN-03009: failure of backup command on ch01 channel at 06/27/2009 20:56:00
ORA-27206: requested file not found in media management catalog

麻烦指点那里要修改。谢谢。

NBU处理日志如下:
  1. 2009-6-27 20:53:14 - requesting resource oracle
  2. 2009-6-27 20:53:14 - requesting resource mastersrv.NBU_CLIENT.MAXJOBS.master
  3. 2009-6-27 20:53:14 - requesting resource mastersrv.NBU_POLICY.MAXJOBS.oracle-bak
  4. 2009-6-27 20:53:14 - granted resource mastersrv.NBU_CLIENT.MAXJOBS.master
  5. 2009-6-27 20:53:14 - granted resource mastersrv.NBU_POLICY.MAXJOBS.oracle-bak
  6. 2009-6-27 20:53:14 - granted resource MediaID=@aaaab;Path=C:\sql;MediaServer=mastersrv
  7. 2009-6-27 20:53:14 - granted resource oracle
  8. 2009-6-27 20:53:14 - estimated 0 kbytes needed
  9. 2009-6-27 20:53:15 - started process bpbrm (4668)
  10. 2009-6-27 20:53:15 - connecting
  11. 2009-6-27 20:53:15 - connected; connect time: 00:00:00
  12. 2009-6-27 20:56:51 - end writing
  13. the backup failed to back up the requested files(6)
复制代码



hot_database_backup.cmd 条目如下:

  1. @REM $Header: hot_database_backup.cmd,v 1.3 2005/11/28 19:01:53 $

  2. @REM bcpyrght
  3. @REM ***************************************************************************
  4. @REM * $VRTScprght: Copyright 1993 - 2007 Symantec Corporation, All Rights Reserved $ *
  5. @REM ***************************************************************************
  6. @REM ecpyrght
  7. @REM
  8. @REM ---------------------------------------------------------------------------
  9. @REM                          hot_database_backup.cmd
  10. @REM ---------------------------------------------------------------------------
  11. @REM This script uses Recovery Manager to take a hot (inconsistent) database
  12. @REM backup. A hot backup is inconsistent because portions of the database are
  13. @REM being modified and written to the disk while the backup is progressing.
  14. @REM You must run your database in ARCHIVELOG mode to make hot backups.
  15. @REM
  16. @REM NOTE information for running proxy backups has been included.  These
  17. @REM information sections begin with a comment line of PROXY
  18. @REM ---------------------------------------------------------------------------

  19. @setlocal ENABLEEXTENSIONS

  20. @REM ---------------------------------------------------------------------------
  21. @REM No need to echo the commands.
  22. @REM ---------------------------------------------------------------------------

  23. @echo off

  24. @REM ---------------------------------------------------------------------------
  25. @REM Put output in the same filename, different extension.
  26. @REM ---------------------------------------------------------------------------

  27. @set RMAN_LOG_FILE="%~dpn0.out"

  28. @REM ---------------------------------------------------------------------------
  29. @REM You may want to delete the output file so that backup information does
  30. @REM not accumulate.  If not, delete the following command.
  31. @REM ---------------------------------------------------------------------------

  32. @if exist %RMAN_LOG_FILE% del %RMAN_LOG_FILE%

  33. @REM ---------------------------------------------------------------------------
  34. @REM Replace H:\oracle\ora81, below, with the Oracle home path.
  35. @REM ---------------------------------------------------------------------------

  36. @set ORACLE_HOME=C:\oracle\product\10.1.0\Db_1

  37. @REM ---------------------------------------------------------------------------
  38. @REM Replace ora81, below, with the Oracle SID.
  39. @REM ---------------------------------------------------------------------------

  40. @set ORACLE_SID=ORCL

  41. @REM ---------------------------------------------------------------------------
  42. @REM Replace sys/manager, below, with the target connect string.
  43. @REM ---------------------------------------------------------------------------

  44. @set TARGET_CONNECT_STR=sys/password

  45. @REM ---------------------------------------------------------------------------
  46. @REM Set the Oracle Recovery Manager.
  47. @REM ---------------------------------------------------------------------------

  48. @set RMAN=%ORACLE_HOME%\bin\rman.exe

  49. @REM ---------------------------------------------------------------------------
  50. @REM PROXY
  51. @REM For a PROXY backup, uncomment the line below and replace the value.
  52. @REM
  53. @REM       NB_ORA_PC_STREAMS - specifies the number of parallel backup streams
  54. @REM                           to be started.
  55. @REM ---------------------------------------------------------------------------
  56. @REM @set NB_ORA_PC_STREAMS=3


  57. @REM ---------------------------------------------------------------------------
  58. @REM Log the start of this scripts.
  59. @REM ---------------------------------------------------------------------------

  60. @for /F "tokens=1*" %%p in ('date /T') do @set DATE=%%p %%q
  61. @for /F %%p in ('time /T') do @set DATE=%DATE% %%p

  62. @echo ==== started on %DATE% ==== >> %RMAN_LOG_FILE%
  63. @echo Script name: %0 >> %RMAN_LOG_FILE%

  64. @REM ---------------------------------------------------------------------------
  65. @REM Several RMAN commands use time parameters that require NLS_LANG and
  66. @REM NLS_DATE_FORMAT to be set. This example uses the standard date format.
  67. @REM Replace below with the desired language values.
  68. @REM ---------------------------------------------------------------------------

  69. @set NLS_LANG=american
  70. @set NLS_DATE_FORMAT=YYYY-MM-DD:hh24:mi:ss

  71. @REM ---------------------------------------------------------------------------
  72. @REM Print out environment variables set in this script.
  73. @REM ---------------------------------------------------------------------------

  74. @echo #                                       >> %RMAN_LOG_FILE%
  75. @echo   RMAN  :  %RMAN%                       >> %RMAN_LOG_FILE%
  76. @echo   NLS_LANG  :  %NLS_LANG%               >> %RMAN_LOG_FILE%
  77. @echo   ORACLE_HOME  :  %ORACLE_HOME%         >> %RMAN_LOG_FILE%
  78. @echo   ORACLE_SID  :  %ORACLE_SID%           >> %RMAN_LOG_FILE%
  79. @echo   NLS_DATE_FORMAT  :  %NLS_DATE_FORMAT% >> %RMAN_LOG_FILE%
  80. @echo   RMAN_LOG_FILE  :  %RMAN_LOG_FILE%     >> %RMAN_LOG_FILE%

  81. @REM ---------------------------------------------------------------------------
  82. @REM PROXY
  83. @REM For a PROXY backup, uncomment the line below.
  84. @REM ---------------------------------------------------------------------------
  85. @REM @echo   NB_ORA_PC_STREAMS  :  %NB_ORA_PC_STREAMS%     >> %RMAN_LOG_FILE%

  86. @REM ---------------------------------------------------------------------------
  87. @REM Print out environment variables set in bphdb.
  88. @REM ---------------------------------------------------------------------------

  89. @echo   NB_ORA_SERV  :  %NB_ORA_SERV%                     >> %RMAN_LOG_FILE%
  90. @echo   NB_ORA_FULL  :  %NB_ORA_FULL%                     >> %RMAN_LOG_FILE%
  91. @echo   NB_ORA_INCR  :  %NB_ORA_INCR%                     >> %RMAN_LOG_FILE%
  92. @echo   NB_ORA_CINC  :  %NB_ORA_CINC%                     >> %RMAN_LOG_FILE%
  93. @echo   NB_ORA_CLASS  :  %NB_ORA_CLASS%                   >> %RMAN_LOG_FILE%

  94. @REM ---------------------------------------------------------------------------
  95. @REM We assume that the database is properly opened. If desired, this would
  96. @REM be the place to verify that.
  97. @REM ---------------------------------------------------------------------------

  98. @REM ---------------------------------------------------------------------------
  99. @REM If this script is executed from a NetBackup schedule, NetBackup
  100. @REM sets an NB_ORA environment variable based on the schedule type.
  101. @REM For example, when:
  102. @REM     schedule type is                BACKUP_TYPE is
  103. @REM     ----------------                --------------
  104. @REM Automatic Full                      INCREMENTAL LEVEL=0
  105. @REM Automatic Differential Incremental  INCREMENTAL LEVEL=1
  106. @REM Automatic Cumulative Incremental    INCREMENTAL LEVEL=1 CUMULATIVE
  107. @REM
  108. @REM For user initiated backups, BACKUP_TYPE defaults to incremental
  109. @REM level 0 (Full).  To change the default for a user initiated
  110. @REM backup to incremental or incrementatl cumulative, uncomment
  111. @REM one of the following two lines.
  112. @REM @set BACKUP_TYPE="INCREMENTAL LEVEL=1"
  113. @REM @set BACKUP_TYPE="INCREMENTAL LEVEL=1 CUMULATIVE"
  114. @REM
  115. @REM Note that we use incremental level 0 to specify full backups.
  116. @REM That is because, although they are identical in content, only
  117. @REM the incremental level 0 backup can have incremental backups of
  118. @REM level > 0 applied to it.
  119. @REM ---------------------------------------------------------------------------

  120. @REM ---------------------------------------------------------------------------
  121. @REM What kind of backup will we perform.
  122. @REM ---------------------------------------------------------------------------

  123. @if "%NB_ORA_FULL%" EQU "1" @set BACKUP_TYPE=INCREMENTAL Level=0
  124. @if "%NB_ORA_INCR%" EQU "1" @set BACKUP_TYPE=INCREMENTAL Level=1
  125. @if "%NB_ORA_CINC%" EQU "1" @set BACKUP_TYPE=INCREMENTAL Level=1 CUMULATIVE
  126. @if NOT DEFINED BACKUP_TYPE @set BACKUP_TYPE=INCREMENTAL Level=0

  127. @REM ---------------------------------------------------------------------------
  128. @REM Call Recovery Manager to initiate the backup. This example does not use a
  129. @REM Recovery Catalog. If you choose to use one, remove the option, nocatalog,
  130. @REM from the rman command line below and add a
  131. @REM 'rcvcat <userid>/<passwd>@<tns alias>' statement.
  132. @REM
  133. @REM  NOTE WHEN USING TNS ALIAS: When connecting to a database
  134. @REM  using a TNS alias, you must use a send command or a parms operand to
  135. @REM  specify environment variables.  In other words, when accessing a database
  136. @REM  through a listener, the environment variables set at the system level are not
  137. @REM  visible when RMAN is running.  For more information on the environment
  138. @REM  variables, please refer to the NetBackup for Oracle Admin. Guide.
  139. @REM
  140. @REM If you are getting an error that the input line is too long, you will need
  141. @REM to put the RMAN run block in a separate file.  Then use the "cmdfile"
  142. @REM option of RMAN.  For more information on the "cmdfile" options please
  143. @REM refer to the RMAN documentation.
  144. @REM ---------------------------------------------------------------------------

  145. @REM ---------------------------------------------------------------------------
  146. @REM PROXY
  147. @REM For a PROXY backup, you must use a send command to specify
  148. @REM the NB_ORA_PC_STREAMS environment variable. For example,
  149. @REM echo ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
  150. @REM echo SEND 'NB_ORA_PC_STREAMS=%%NB_ORA_PC_STREAMS%%';
  151. @REM
  152. @REM %BACKUP_TYPE% must also be removed and replaced with the PROXY parameter
  153. @REM in the RMAN section associated with the data files.  For example,
  154. @REM echo BACKUP
  155. @REM echo       PROXY
  156. @REM echo       FORMAT 'bk_u%%u_s%%s_p%%p_t%%t'
  157. @REM echo       DATABASE;
  158. @REM            .
  159. @REM            .
  160. @REM  Note that the controlfiles and archivelogs are not backed up using proxy
  161. @REM  copy method. Rman will initiate non-proxy copy sessions to backup the
  162. @REM  controlfile and archivelogs.
  163. @REM ---------------------------------------------------------------------------
  164. @(
  165. echo RUN {
  166. echo ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
  167. echo ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
  168. echo BACKUP
  169. echo       %BACKUP_TYPE%
  170. echo       FORMAT 'bk_u%%u_s%%s_p%%p_t%%t'
  171. echo       DATABASE;
  172. echo sql 'alter system archive log current';
  173. echo RELEASE CHANNEL ch00;
  174. echo RELEASE CHANNEL ch01;
  175. echo # Backup all archive logs
  176. echo ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
  177. echo BACKUP
  178. echo       FILESPERSET 20
  179. echo       FORMAT 'arch-s%%s-p%%p'
  180. echo       ARCHIVELOG ALL;
  181. echo RELEASE CHANNEL ch00;
  182. echo }
  183. ) | %RMAN% target %TARGET_CONNECT_STR% nocatalog msglog '%RMAN_LOG_FILE%' append

  184. @set ERRLEVEL=%ERRORLEVEL%

  185. @REM ---------------------------------------------------------------------------
  186. @REM NetBackup (bphdb) stores the name of a file in an environment variable,
  187. @REM called STATUS_FILE. This file is used by an automatic schedule to
  188. @REM communicate status information with NetBackup's job monitor. It is up to
  189. @REM the script to write a 0 (passed) or 1 (failure) to the status file.
  190. @REM ---------------------------------------------------------------------------

  191. @if %ERRLEVEL% NEQ 0 @goto err

  192. @set LOGMSG=ended successfully
  193. @if "%STATUS_FILE%" EQU "" goto end
  194. @echo 0 > "%STATUS_FILE%"
  195. @goto end

  196. :err
  197. @set LOGMSG=ended in error
  198. @if "%STATUS_FILE%" EQU "" @goto end
  199. @echo 1 > "%STATUS_FILE%"

  200. :end

  201. @REM ---------------------------------------------------------------------------
  202. @REM Log the completion of this script.
  203. @REM ---------------------------------------------------------------------------

  204. @for /F "tokens=1*" %%p in ('date /T') do @set DATE=%%p %%q
  205. @for /F %%p in ('time /T') do @set DATE=%DATE% %%p

  206. @echo #  >> %RMAN_LOG_FILE%
  207. @echo %==== %LOGMSG% on %DATE% ==== >> %RMAN_LOG_FILE%
  208. @endlocal
  209. @REM End of Main Program -----------------------------------------------------
复制代码



备份后输出错误日志如下:
  1. ==== started on 2009-06-27 星期六  20:53 ====
  2. Script name: "C:\script\hot_database_backup.cmd"
  3. #                                       
  4.   RMAN  :  C:\oracle\product\10.1.0\Db_1\bin\rman.exe                       
  5.   NLS_LANG  :  american               
  6.   ORACLE_HOME  :  C:\oracle\product\10.1.0\Db_1         
  7.   ORACLE_SID  :  ORCL           
  8.   NLS_DATE_FORMAT  :  YYYY-MM-DD:hh24:mi:ss
  9.   RMAN_LOG_FILE  :  "C:\script\hot_database_backup.out"     
  10.   NB_ORA_SERV  :  mastersrv                     
  11.   NB_ORA_FULL  :  1                     
  12.   NB_ORA_INCR  :  0                     
  13.   NB_ORA_CINC  :  0                     
  14.   NB_ORA_CLASS  :  oracle-bak                  

  15. Recovery Manager: Release 10.1.0.2.0 - Production

  16. Copyright (c) 1995, 2004, Oracle.  All rights reserved.

  17. connected to target database: ORCL (DBID=1218420383)
  18. using target database controlfile instead of recovery catalog

  19. RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18>
  20. allocated channel: ch00
  21. channel ch00: sid=132 devtype=SBT_TAPE
  22. channel ch00: Veritas NetBackup for Oracle - Release 6.5 (20070723)

  23. allocated channel: ch01
  24. channel ch01: sid=148 devtype=SBT_TAPE
  25. channel ch01: Veritas NetBackup for Oracle - Release 6.5 (20070723)

  26. Starting backup at 2009-06-27:20:53:42
  27. channel ch00: starting incremental level 0 datafile backupset
  28. channel ch00: specifying datafile(s) in backupset
  29. input datafile fno=00001 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSTEM01.DBF
  30. input datafile fno=00004 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\USERS01.DBF
  31. channel ch00: starting piece 1 at 2009-06-27:20:53:42
  32. channel ch01: starting incremental level 0 datafile backupset
  33. channel ch01: specifying datafile(s) in backupset
  34. input datafile fno=00003 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSAUX01.DBF
  35. input datafile fno=00002 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\UNDOTBS01.DBF
  36. channel ch01: starting piece 1 at 2009-06-27:20:53:42
  37. RMAN-03009: failure of backup command on ch00 channel at 06/27/2009 20:55:21
  38. ORA-27206: requested file not found in media management catalog
  39. continuing other job steps, job failed will not be re-run
  40. channel ch00: starting incremental level 0 datafile backupset
  41. channel ch00: specifying datafile(s) in backupset
  42. including current controlfile in backupset
  43. channel ch00: starting piece 1 at 2009-06-27:20:55:45
  44. RMAN-03009: failure of backup command on ch01 channel at 06/27/2009 20:56:00
  45. ORA-27206: requested file not found in media management catalog
  46. continuing other job steps, job failed will not be re-run
  47. channel ch01: starting incremental level 0 datafile backupset
  48. channel ch01: specifying datafile(s) in backupset
  49. including current SPFILE in backupset
  50. channel ch01: starting piece 1 at 2009-06-27:20:56:00
  51. RMAN-03009: failure of backup command on ch00 channel at 06/27/2009 20:56:25
  52. ORA-27206: requested file not found in media management catalog
  53. continuing other job steps, job failed will not be re-run
  54. released channel: ch00
  55. released channel: ch01
  56. RMAN-00571: ===========================================================
  57. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  58. RMAN-00571: ===========================================================
  59. RMAN-03009: failure of backup command on ch01 channel at 06/27/2009 20:56:50
  60. ORA-27206: requested file not found in media management catalog

  61. RMAN>

  62. Recovery Manager complete.
  63. #   
复制代码

论坛徽章:
0
2 [报告]
发表于 2009-06-27 21:37 |只看该作者
时间对么?
备份到DISK还是TAPE?
另外把日志贴出来瞧瞧
\veritas\netbackup\logs\user_ops\dbext\logs

论坛徽章:
1
CU十二周年纪念徽章
日期:2013-10-24 15:41:34
3 [报告]
发表于 2009-06-27 22:04 |只看该作者
在脚本里面加上下面这行试一试。
send 'NB_ORA_CLIENT=mastersrv,NB_ORA_SERV=mastersrv';

master server的名字是mastersrv吗?

论坛徽章:
0
4 [报告]
发表于 2009-06-28 00:04 |只看该作者
加了无牙的那一行也不行。master server名字是mastersrv 的。


\veritas\netbackup\logs\user_ops\dbext\logs 最新日志如下。






  1. Backup started Sat Jun 27 23:55:12 2009


  2. 23:55:13 Initiating backup
  3. 23:55:14 INF - Starting bprm
  4. 23:55:14 INF - Data socket = master.IPC:4343;b6ff1efd6cd1ff75cda450913965bdc2;4;300
  5. 23:55:14 INF - Name socket = master.IPC:4345;8a36c05fce84483f67365936a9c37eb5;4;300
  6. 23:55:14 INF - Job id = 60
  7. 23:55:14 INF - Backup id = master_1246118113
  8. 23:55:14 INF - Backup time = 1246118113
  9. 23:55:14 INF - Policy name = oracle-bak
  10. 23:55:14 INF - Snapshot = 0
  11. 23:55:14 INF - Frozen image = 0
  12. 23:55:14 INF - Backup copy = 0
  13. 23:55:14 INF - Master server = mastersrv
  14. 23:55:14 INF - Media server = mastersrv
  15. 23:55:14 INF - Multiplexing = 0
  16. 23:55:14 INF - New data socket = master.IPC:4341;2ce97e5b45d38060fece1aa7eb13f8ff;4;300
  17. 23:55:14 INF - Encrypt = 0
  18. 23:55:14 INF - Use shared memory = 1
  19. 23:55:14 INF - Compression = 0
  20. 23:55:14 INF - Encrypt = 0
  21. 23:55:14 INF - Keep logs = 28
  22. 23:55:14 INF - Client read timeout = 300
  23. 23:55:14 INF - Media mount timeout = 0
  24. 23:55:25 INF - Beginning backup on server mastersrv of client master
  25. 23:57:04 INF - Server status = 0
  26. 23:57:06 INF - Backup by SYSTEM on client master using policy oracle-bak, sched Default-Application-Backup:the requested operation was successfully completed.


  27. Backup started Sat Jun 27 23:57:17 2009


  28. 23:57:17 Initiating backup
  29. 23:58:07 INF - Starting bprm
  30. 23:58:07 INF - Data socket = master.IPC:4722;7ae14663ab3478b3b4b9c7a044b96744;4;300
  31. 23:58:07 INF - Name socket = master.IPC:4724;9fdb8ed4b9f6e98c5d6954e86e9c70ad;4;300
  32. 23:58:07 INF - Job id = 62
  33. 23:58:07 INF - Backup id = master_1246118286
  34. 23:58:07 INF - Backup time = 1246118286
  35. 23:58:07 INF - Policy name = oracle-bak
  36. 23:58:07 INF - Snapshot = 0
  37. 23:58:07 INF - Frozen image = 0
  38. 23:58:07 INF - Backup copy = 0
  39. 23:58:07 INF - Master server = mastersrv
  40. 23:58:07 INF - Media server = mastersrv
  41. 23:58:07 INF - Multiplexing = 0
  42. 23:58:07 INF - New data socket = master.IPC:4720;48f18de40c4be0f2f93a618d1d633afd;4;300
  43. 23:58:07 INF - Encrypt = 0
  44. 23:58:07 INF - Use shared memory = 1
  45. 23:58:07 INF - Compression = 0
  46. 23:58:07 INF - Encrypt = 0
  47. 23:58:07 INF - Keep logs = 28
  48. 23:58:07 INF - Client read timeout = 300
  49. 23:58:07 INF - Media mount timeout = 0
  50. 23:58:21 INF - Beginning backup on server mastersrv of client master
  51. 23:58:31 INF - Server status = 0
  52. 23:58:32 INF - Backup by SYSTEM on client master using policy oracle-bak, sched Default-Application-Backup:the requested operation was successfully completed.

  53. Backup started Sat Jun 27 23:58:23 2009


  54. 23:58:24 Initiating backup
  55. 23:58:33 INF - Starting bprm
  56. 23:58:33 INF - Data socket = master.IPC:4976;bfc40d28271b7a988fcd537628846e9f;4;300
  57. 23:58:33 INF - Name socket = master.IPC:4978;c6865a1c9c39b1a64096398a2f3220d0;4;300
  58. 23:58:33 INF - Job id = 63
  59. 23:58:33 INF - Backup id = master_1246118311
  60. 23:58:33 INF - Backup time = 1246118311
  61. 23:58:33 INF - Policy name = oracle-bak
  62. 23:58:33 INF - Snapshot = 0
  63. 23:58:33 INF - Frozen image = 0
  64. 23:58:33 INF - Backup copy = 0
  65. 23:58:33 INF - Master server = mastersrv
  66. 23:58:33 INF - Media server = mastersrv
  67. 23:58:33 INF - Multiplexing = 0
  68. 23:58:33 INF - New data socket = master.IPC:4974;46e6610da0cb94eed6b4c0c712d6c800;4;300
  69. 23:58:33 INF - Encrypt = 0
  70. 23:58:33 INF - Use shared memory = 1
  71. 23:58:33 INF - Compression = 0
  72. 23:58:33 INF - Encrypt = 0
  73. 23:58:33 INF - Keep logs = 28
  74. 23:58:33 INF - Client read timeout = 300
  75. 23:58:33 INF - Media mount timeout = 0
  76. 23:58:42 INF - Beginning backup on server mastersrv of client master
  77. 23:58:50 INF - Server status = 0
  78. 23:58:50 INF - Backup by SYSTEM on client master using policy oracle-bak, sched Default-Application-Backup:the requested operation was successfully completed.









复制代码
  1. ==== started on 2009-06-27 星期六  23:54 ====
  2. Script name: "C:\script\hot_database_backup.cmd"
  3. #                                       
  4.   RMAN  :  C:\oracle\product\10.1.0\Db_1\bin\rman.exe                       
  5.   NLS_LANG  :  american               
  6.   ORACLE_HOME  :  C:\oracle\product\10.1.0\Db_1         
  7.   ORACLE_SID  :  ORCL           
  8.   NLS_DATE_FORMAT  :  YYYY-MM-DD:hh24:mi:ss
  9.   RMAN_LOG_FILE  :  "C:\script\hot_database_backup.out"     
  10.   NB_ORA_SERV  :  mastersrv                     
  11.   NB_ORA_FULL  :  1                     
  12.   NB_ORA_INCR  :  0                     
  13.   NB_ORA_CINC  :  0                     
  14.   NB_ORA_CLASS  :  oracle-bak                  

  15. Recovery Manager: Release 10.1.0.2.0 - Production

  16. Copyright (c) 1995, 2004, Oracle.  All rights reserved.

  17. connected to target database: ORCL (DBID=1218420383)
  18. using target database controlfile instead of recovery catalog

  19. RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18>
  20. allocated channel: ch00
  21. channel ch00: sid=147 devtype=SBT_TAPE
  22. channel ch00: Veritas NetBackup for Oracle - Release 6.5 (20070723)

  23. allocated channel: ch01
  24. channel ch01: sid=148 devtype=SBT_TAPE
  25. channel ch01: Veritas NetBackup for Oracle - Release 6.5 (20070723)

  26. Starting backup at 2009-06-27:23:55:11
  27. channel ch00: starting incremental level 0 datafile backupset
  28. channel ch00: specifying datafile(s) in backupset
  29. input datafile fno=00001 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSTEM01.DBF
  30. input datafile fno=00004 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\USERS01.DBF
  31. channel ch00: starting piece 1 at 2009-06-27:23:55:12
  32. channel ch01: starting incremental level 0 datafile backupset
  33. channel ch01: specifying datafile(s) in backupset
  34. input datafile fno=00003 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSAUX01.DBF
  35. input datafile fno=00002 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\UNDOTBS01.DBF
  36. channel ch01: starting piece 1 at 2009-06-27:23:55:12
  37. RMAN-03009: failure of backup command on ch00 channel at 06/27/2009 23:57:16
  38. ORA-27206: requested file not found in media management catalog
  39. continuing other job steps, job failed will not be re-run
  40. channel ch00: starting incremental level 0 datafile backupset
  41. channel ch00: specifying datafile(s) in backupset
  42. including current controlfile in backupset
  43. channel ch00: starting piece 1 at 2009-06-27:23:57:17
  44. RMAN-03009: failure of backup command on ch01 channel at 06/27/2009 23:58:22
  45. ORA-27206: requested file not found in media management catalog
  46. continuing other job steps, job failed will not be re-run
  47. channel ch01: starting incremental level 0 datafile backupset
  48. channel ch01: specifying datafile(s) in backupset
  49. including current SPFILE in backupset
  50. channel ch01: starting piece 1 at 2009-06-27:23:58:23
  51. RMAN-03009: failure of backup command on ch00 channel at 06/27/2009 23:58:48
  52. ORA-27206: requested file not found in media management catalog
  53. continuing other job steps, job failed will not be re-run
  54. released channel: ch00
  55. released channel: ch01
  56. RMAN-00571: ===========================================================
  57. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  58. RMAN-00571: ===========================================================
  59. RMAN-03009: failure of backup command on ch01 channel at 06/27/2009 23:59:03
  60. ORA-27206: requested file not found in media management catalog

  61. RMAN>

  62. Recovery Manager complete.
  63. #   
复制代码

论坛徽章:
0
5 [报告]
发表于 2009-06-28 00:06 |只看该作者
备份卷池用的是本地磁盘,时间,路径都没问题的。

论坛徽章:
0
6 [报告]
发表于 2009-06-28 10:28 |只看该作者
NBU是什么版本?印象中企业版才可以用两个通道。
先确保文件系统能够备份。
另外,在命令行下用RMAN备份试试看能否备份得了。

论坛徽章:
0
7 [报告]
发表于 2009-06-28 10:44 |只看该作者
NBU是6.5
文件系统能够备份。
另外,在命令行下用RMAN备份能备份得了。
只使用一个通道?在hot_database_backup.cmd 中把有关CH01的条目都删除吗?

论坛徽章:
0
8 [报告]
发表于 2009-06-28 11:07 |只看该作者
企业版才能用两个CHANNEL。你看看你的是哪个版本。

论坛徽章:
1
CU十二周年纪念徽章
日期:2013-10-24 15:41:34
9 [报告]
发表于 2009-06-28 11:42 |只看该作者
NBU的标准版和企业版对RMAN的通道数没什么限制吧?

论坛徽章:
0
10 [报告]
发表于 2009-06-28 11:56 |只看该作者
  不好意思,在那里看我装的是什么版本呢?
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP