NBU低级问题请教

无牙

原帖由 chensimon 于 2009-6-30 11:09 发表
关注，问题解决了吗？

应该还没，LZ没更新状态。

美好美好

呵呵，我是在实验环境测试的，等有时间再搞搞 到时把结果告诉大家。

ifei76

问题应该出在备份脚本的这里
echo ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
echo ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';

在备份脚本上你使用的的type类型tape，而你备份的地方是是本地磁盘。
你需要修改脚本的Type类型为disk就可以了。

无牙

原帖由 ifei76 于 2009-7-1 16:04 发表
问题应该出在备份脚本的这里
echo ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
echo ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';

在备份脚本上你使用的的type类型tape，而你备份的地方是是本地磁盘。
你需要修改 ...

美好美好

原帖由 ifei76 于 2009-7-1 16:04 发表
问题应该出在备份脚本的这里
echo ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
echo ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';

在备份脚本上你使用的的type类型tape，而你备份的地方是是本地磁盘。
你需要修改 ...

呵呵你说的这个已经修改过，不行。

美好美好

无语了，今天把上面的代码拷到另外一台虚拟机上，结果在使用虚拟带库和使用磁盘做为Storage Units都可以备份成功。但我还没找到为什么在上次那虚拟机上不成功的原因

1. ==== started on 2009-07-05 星期日  13:36 ====
   
2. Script name: "C:\nbubackupscripts\nbuhot_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:\nbubackupscripts\nbuhot_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                  
    
15. 
    
16. Recovery Manager: Release 10.1.0.2.0 - Production
    
17. 
    
18. Copyright (c) 1995, 2004, Oracle.  All rights reserved.
    
19. 
    
20. connected to target database: ORCL (DBID=1214188000)
    
21. using target database controlfile instead of recovery catalog
    
22. 
    
23. RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18>
    
24. allocated channel: ch00
    
25. channel ch00: sid=140 devtype=SBT_TAPE
    
26. channel ch00: Veritas NetBackup for Oracle - Release 6.5 (20070723)
    
27. 
    
28. allocated channel: ch01
    
29. channel ch01: sid=133 devtype=SBT_TAPE
    
30. channel ch01: Veritas NetBackup for Oracle - Release 6.5 (20070723)
    
31. 
    
32. Starting backup at 2009-07-05:13:36:52
    
33. channel ch00: starting incremental level 0 datafile backupset
    
34. channel ch00: specifying datafile(s) in backupset
    
35. input datafile fno=00001 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSTEM01.DBF
    
36. input datafile fno=00004 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\USERS01.DBF
    
37. channel ch00: starting piece 1 at 2009-07-05:13:36:52
    
38. channel ch01: starting incremental level 0 datafile backupset
    
39. channel ch01: specifying datafile(s) in backupset
    
40. input datafile fno=00003 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSAUX01.DBF
    
41. input datafile fno=00002 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\UNDOTBS01.DBF
    
42. channel ch01: starting piece 1 at 2009-07-05:13:36:52
    
43. channel ch00: finished piece 1 at 2009-07-05:13:38:24
    
44. piece handle=bk_u0kkjcgjk_s20_p1_t691421812 comment=API Version 2.0,MMS Version 5.0.0.0
    
45. channel ch00: backup set complete, elapsed time: 00:01:32
    
46. channel ch01: finished piece 1 at 2009-07-05:13:39:00
    
47. piece handle=bk_u0lkjcgjk_s21_p1_t691421812 comment=API Version 2.0,MMS Version 5.0.0.0
    
48. channel ch01: backup set complete, elapsed time: 00:02:08
    
49. Finished backup at 2009-07-05:13:39:01
    
50. 
    
51. Starting Control File and SPFILE Autobackup at 2009-07-05:13:39:01
    
52. piece handle=c-1214188000-20090705-04 comment=API Version 2.0,MMS Version 5.0.0.0
    
53. Finished Control File and SPFILE Autobackup at 2009-07-05:13:39:46
    
54. 
    
55. sql statement: alter system archive log current
    
56. 
    
57. released channel: ch00
    
58. 
    
59. released channel: ch01
    
60. 
    
61. allocated channel: ch00
    
62. channel ch00: sid=140 devtype=SBT_TAPE
    
63. channel ch00: Veritas NetBackup for Oracle - Release 6.5 (20070723)
    
64. 
    
65. Starting backup at 2009-07-05:13:39:47
    
66. current log archived
    
67. channel ch00: starting archive log backupset
    
68. channel ch00: specifying archive log(s) in backup set
    
69. input archive log thread=1 sequence=1 recid=3 stamp=686414531
    
70. input archive log thread=1 sequence=2 recid=4 stamp=686940474
    
71. input archive log thread=1 sequence=3 recid=5 stamp=686940989
    
72. input archive log thread=1 sequence=4 recid=6 stamp=686942721
    
73. input archive log thread=1 sequence=5 recid=7 stamp=687200251
    
74. input archive log thread=1 sequence=6 recid=8 stamp=687283272
    
75. input archive log thread=1 sequence=7 recid=9 stamp=691326720
    
76. input archive log thread=1 sequence=8 recid=10 stamp=691334430
    
77. input archive log thread=1 sequence=9 recid=11 stamp=691340432
    
78. input archive log thread=1 sequence=10 recid=12 stamp=691418977
    
79. input archive log thread=1 sequence=11 recid=13 stamp=691419614
    
80. input archive log thread=1 sequence=12 recid=14 stamp=691419614
    
81. input archive log thread=1 sequence=13 recid=15 stamp=691420147
    
82. input archive log thread=1 sequence=14 recid=16 stamp=691420149
    
83. input archive log thread=1 sequence=15 recid=17 stamp=691421987
    
84. input archive log thread=1 sequence=16 recid=18 stamp=691421988
    
85. channel ch00: starting piece 1 at 2009-07-05:13:39:50
    
86. channel ch00: finished piece 1 at 2009-07-05:13:40:36
    
87. piece handle=arch-s23-p1 comment=API Version 2.0,MMS Version 5.0.0.0
    
88. channel ch00: backup set complete, elapsed time: 00:00:47
    
89. channel ch00: starting archive log backupset
    
90. channel ch00: specifying archive log(s) in backup set
    
91. input archive log thread=1 sequence=5 recid=1 stamp=686410540
    
92. input archive log thread=1 sequence=6 recid=2 stamp=686410545
    
93. channel ch00: starting piece 1 at 2009-07-05:13:40:37
    
94. channel ch00: finished piece 1 at 2009-07-05:13:41:12
    
95. piece handle=arch-s24-p1 comment=API Version 2.0,MMS Version 5.0.0.0
    
96. channel ch00: backup set complete, elapsed time: 00:00:36
    
97. Finished backup at 2009-07-05:13:41:12
    
98. 
    
99. Starting Control File and SPFILE Autobackup at 2009-07-05:13:41:12
    
100. piece handle=c-1214188000-20090705-05 comment=API Version 2.0,MMS Version 5.0.0.0
     
101. Finished Control File and SPFILE Autobackup at 2009-07-05:13:41:57
     
102. 
     
103. released channel: ch00
     
104. 
     
105. RMAN>
     
106. 
     
107. Recovery Manager complete.
     
108. #  

复制代码

无牙

从日志上看应该是NBU for Oracle agent的问题。
“piece handle=arch-s23-p1 comment=API Version 2.0,MMS Version 5.0.0.0”
上次没有这个。

美好美好

谢谢。等我恢复上次的环境再搞搞看

无牙

你可以试着用Oracle的工具sbttest检查NBU for Oracle agent是不是弄好了。

Perl_Er