课程第29/30/31次（2017-09-09星期六上下午和2017-09-12星期二）

botang

bclresult-15.zip (52.27 KB, 下载次数: 484)

2017-9-13 09:45 上传

点击文件名下载附件

1. ###########
   
2.     startup upgrade   //其实就是禁用新特性
   
3.     spool filename.log
   
4.     @utlu112i.sql
   
5.     @catupgrd.sql >6h
   
6.     自动shutdown immediate
   
7.     startup
   
8.     @utlu112s.sql
   
9.     @catuppst.sql
   
10.     @utlrp.sql   2h
    

复制代码

1. RMAN> backup  tag 'NEW3'   incremental level 0  database  filesperset 1 plus archivelog delete all input;
   
2. 
   
3. 
   
4. Starting backup at 09-SEP-17
   
5. current log archived
   
6. allocated channel: ORA_SBT_TAPE_1
   
7. channel ORA_SBT_TAPE_1: SID=11 device type=SBT_TAPE
   
8. channel ORA_SBT_TAPE_1: Oracle Secure Backup
   
9. allocated channel: ORA_SBT_TAPE_2
   
10. channel ORA_SBT_TAPE_2: SID=68 device type=SBT_TAPE
    
11. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
12. channel ORA_SBT_TAPE_1: starting archived log backup set
    
13. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
    
14. input archived log thread=1 sequence=3 RECID=3 STAMP=954149584
    
15. input archived log thread=1 sequence=4 RECID=4 STAMP=954163356
    
16. input archived log thread=1 sequence=5 RECID=5 STAMP=954187223
    
17. input archived log thread=1 sequence=6 RECID=6 STAMP=954234290
    
18. input archived log thread=1 sequence=7 RECID=7 STAMP=954234321
    
19. input archived log thread=1 sequence=8 RECID=8 STAMP=954244111
    
20. input archived log thread=1 sequence=9 RECID=9 STAMP=954244163
    
21. input archived log thread=1 sequence=10 RECID=10 STAMP=954244242
    
22. input archived log thread=1 sequence=11 RECID=11 STAMP=954244296
    
23. input archived log thread=1 sequence=12 RECID=12 STAMP=954244321
    
24. input archived log thread=1 sequence=13 RECID=13 STAMP=954244369
    
25. input archived log thread=1 sequence=14 RECID=14 STAMP=954244448
    
26. input archived log thread=1 sequence=15 RECID=15 STAMP=954244475
    
27. input archived log thread=1 sequence=16 RECID=16 STAMP=954244493
    
28. input archived log thread=1 sequence=17 RECID=17 STAMP=954244527
    
29. input archived log thread=1 sequence=18 RECID=18 STAMP=954244580
    
30. input archived log thread=1 sequence=19 RECID=19 STAMP=954244670
    
31. input archived log thread=1 sequence=20 RECID=20 STAMP=954244740
    
32. input archived log thread=1 sequence=21 RECID=21 STAMP=954244806
    
33. input archived log thread=1 sequence=22 RECID=22 STAMP=954244858
    
34. input archived log thread=1 sequence=23 RECID=23 STAMP=954244897
    
35. input archived log thread=1 sequence=24 RECID=24 STAMP=954244949
    
36. input archived log thread=1 sequence=25 RECID=25 STAMP=954244982
    
37. input archived log thread=1 sequence=26 RECID=26 STAMP=954245016
    
38. input archived log thread=1 sequence=27 RECID=27 STAMP=954245111
    
39. input archived log thread=1 sequence=28 RECID=28 STAMP=954245126
    
40. input archived log thread=1 sequence=29 RECID=29 STAMP=954245139
    
41. input archived log thread=1 sequence=30 RECID=30 STAMP=954245151
    
42. input archived log thread=1 sequence=31 RECID=31 STAMP=954245179
    
43. input archived log thread=1 sequence=32 RECID=32 STAMP=954245194
    
44. input archived log thread=1 sequence=33 RECID=33 STAMP=954245222
    
45. channel ORA_SBT_TAPE_1: starting piece 1 at 09-SEP-17
    
46. channel ORA_SBT_TAPE_2: starting archived log backup set
    
47. channel ORA_SBT_TAPE_2: specifying archived log(s) in backup set
    
48. input archived log thread=1 sequence=34 RECID=34 STAMP=954245286
    
49. input archived log thread=1 sequence=35 RECID=35 STAMP=954245359
    
50. input archived log thread=1 sequence=36 RECID=36 STAMP=954245402
    
51. input archived log thread=1 sequence=37 RECID=37 STAMP=954245423
    
52. input archived log thread=1 sequence=38 RECID=38 STAMP=954245457
    
53. input archived log thread=1 sequence=39 RECID=39 STAMP=954245510
    
54. input archived log thread=1 sequence=40 RECID=40 STAMP=954245538
    
55. input archived log thread=1 sequence=41 RECID=41 STAMP=954245568
    
56. input archived log thread=1 sequence=42 RECID=42 STAMP=954245626
    
57. input archived log thread=1 sequence=43 RECID=43 STAMP=954245678
    
58. input archived log thread=1 sequence=44 RECID=44 STAMP=954245699
    
59. input archived log thread=1 sequence=45 RECID=45 STAMP=954245714
    
60. input archived log thread=1 sequence=46 RECID=46 STAMP=954245742
    
61. input archived log thread=1 sequence=47 RECID=47 STAMP=954245766
    
62. input archived log thread=1 sequence=48 RECID=48 STAMP=954245785
    
63. input archived log thread=1 sequence=49 RECID=49 STAMP=954245811
    
64. input archived log thread=1 sequence=50 RECID=50 STAMP=954245840
    
65. input archived log thread=1 sequence=51 RECID=51 STAMP=954245907
    
66. input archived log thread=1 sequence=52 RECID=52 STAMP=954245943
    
67. input archived log thread=1 sequence=53 RECID=53 STAMP=954245999
    
68. input archived log thread=1 sequence=54 RECID=54 STAMP=954246032
    
69. input archived log thread=1 sequence=55 RECID=55 STAMP=954256484
    
70. input archived log thread=1 sequence=56 RECID=56 STAMP=954256713
    
71. input archived log thread=1 sequence=57 RECID=57 STAMP=954256728
    
72. input archived log thread=1 sequence=58 RECID=58 STAMP=954256755
    
73. input archived log thread=1 sequence=59 RECID=59 STAMP=954256782
    
74. input archived log thread=1 sequence=60 RECID=60 STAMP=954256814
    
75. input archived log thread=1 sequence=61 RECID=61 STAMP=954256857
    
76. input archived log thread=1 sequence=62 RECID=62 STAMP=954256906
    
77. channel ORA_SBT_TAPE_2: starting piece 1 at 09-SEP-17
    
78. channel ORA_SBT_TAPE_1: finished piece 1 at 09-SEP-17
    
79. piece handle=0fse1krt_1_1 tag=NEW3 comment=API Version 2.0,MMS Version 10.4.0.4
    
80. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:34
    
81. channel ORA_SBT_TAPE_1: deleting archived log(s)
    
82. archived log file name=+FRA/orcl/archivelog/2017_09_08/thread_1_seq_3.293.954149585 RECID=3 STAMP=954149584
    
83. archived log file name=+FRA/orcl/archivelog/2017_09_08/thread_1_seq_4.294.954163357 RECID=4 STAMP=954163356
    
84. archived log file name=+FRA/orcl/archivelog/2017_09_08/thread_1_seq_5.295.954187223 RECID=5 STAMP=954187223
    
85. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_6.296.954234291 RECID=6 STAMP=954234290
    
86. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_7.297.954234321 RECID=7 STAMP=954234321
    
87. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_8.298.954244111 RECID=8 STAMP=954244111
    
88. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_9.299.954244163 RECID=9 STAMP=954244163
    
89. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_10.300.954244243 RECID=10 STAMP=954244242
    
90. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_11.301.954244297 RECID=11 STAMP=954244296
    
91. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_12.302.954244321 RECID=12 STAMP=954244321
    
92. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_13.303.954244369 RECID=13 STAMP=954244369
    
93. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_14.304.954244447 RECID=14 STAMP=954244448
    
94. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_15.305.954244475 RECID=15 STAMP=954244475
    
95. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_16.306.954244493 RECID=16 STAMP=954244493
    
96. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_17.307.954244527 RECID=17 STAMP=954244527
    
97. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_18.308.954244579 RECID=18 STAMP=954244580
    
98. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_19.309.954244669 RECID=19 STAMP=954244670
    
99. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_20.310.954244739 RECID=20 STAMP=954244740
    
100. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_21.311.954244807 RECID=21 STAMP=954244806
     
101. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_22.312.954244857 RECID=22 STAMP=954244858
     
102. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_23.313.954244897 RECID=23 STAMP=954244897
     
103. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_24.314.954244949 RECID=24 STAMP=954244949
     
104. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_25.315.954244981 RECID=25 STAMP=954244982
     
105. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_26.316.954245017 RECID=26 STAMP=954245016
     
106. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_27.317.954245111 RECID=27 STAMP=954245111
     
107. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_28.318.954245127 RECID=28 STAMP=954245126
     
108. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_29.319.954245139 RECID=29 STAMP=954245139
     
109. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_30.320.954245151 RECID=30 STAMP=954245151
     
110. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_31.321.954245179 RECID=31 STAMP=954245179
     
111. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_32.322.954245195 RECID=32 STAMP=954245194
     
112. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_33.323.954245223 RECID=33 STAMP=954245222
     
113. channel ORA_SBT_TAPE_1: starting archived log backup set
     
114. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
     
115. input archived log thread=1 sequence=63 RECID=63 STAMP=954256957
     
116. input archived log thread=1 sequence=64 RECID=64 STAMP=954258288
     
117. channel ORA_SBT_TAPE_1: starting piece 1 at 09-SEP-17
     
118. channel ORA_SBT_TAPE_2: finished piece 1 at 09-SEP-17
     
119. piece handle=0gse1krt_1_1 tag=NEW3 comment=API Version 2.0,MMS Version 10.4.0.4
     
120. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:37
     
121. channel ORA_SBT_TAPE_2: deleting archived log(s)
     
122. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_34.324.954245285 RECID=34 STAMP=954245286
     
123. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_35.325.954245359 RECID=35 STAMP=954245359
     
124. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_36.326.954245401 RECID=36 STAMP=954245402
     
125. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_37.327.954245423 RECID=37 STAMP=954245423
     
126. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_38.328.954245457 RECID=38 STAMP=954245457
     
127. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_39.329.954245511 RECID=39 STAMP=954245510
     
128. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_40.330.954245539 RECID=40 STAMP=954245538
     
129. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_41.331.954245569 RECID=41 STAMP=954245568
     
130. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_42.332.954245627 RECID=42 STAMP=954245626
     
131. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_43.333.954245677 RECID=43 STAMP=954245678
     
132. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_44.334.954245699 RECID=44 STAMP=954245699
     
133. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_45.335.954245715 RECID=45 STAMP=954245714
     
134. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_46.336.954245741 RECID=46 STAMP=954245742
     
135. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_47.337.954245767 RECID=47 STAMP=954245766
     
136. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_48.338.954245785 RECID=48 STAMP=954245785
     
137. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_49.339.954245811 RECID=49 STAMP=954245811
     
138. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_50.340.954245839 RECID=50 STAMP=954245840
     
139. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_51.341.954245907 RECID=51 STAMP=954245907
     
140. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_52.342.954245943 RECID=52 STAMP=954245943
     
141. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_53.343.954245999 RECID=53 STAMP=954245999
     
142. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_54.344.954246033 RECID=54 STAMP=954246032
     
143. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_55.345.954256485 RECID=55 STAMP=954256484
     
144. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_56.346.954256713 RECID=56 STAMP=954256713
     
145. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_57.347.954256729 RECID=57 STAMP=954256728
     
146. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_58.348.954256755 RECID=58 STAMP=954256755
     
147. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_59.349.954256781 RECID=59 STAMP=954256782
     
148. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_60.350.954256813 RECID=60 STAMP=954256814
     
149. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_61.351.954256857 RECID=61 STAMP=954256857
     
150. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_62.352.954256905 RECID=62 STAMP=954256906
     
151. channel ORA_SBT_TAPE_1: finished piece 1 at 09-SEP-17
     
152. piece handle=0hse1kt2_1_1 tag=NEW3 comment=API Version 2.0,MMS Version 10.4.0.4
     
153. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:18
     
154. channel ORA_SBT_TAPE_1: deleting archived log(s)
     
155. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_63.353.954256957 RECID=63 STAMP=954256957
     
156. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_64.354.954258287 RECID=64 STAMP=954258288
     
157. Finished backup at 09-SEP-17
     
158. 
     
159. Starting backup at 09-SEP-17
     
160. using channel ORA_SBT_TAPE_1
     
161. using channel ORA_SBT_TAPE_2
     
162. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
     
163. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
     
164. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
     
165. channel ORA_SBT_TAPE_1: starting piece 1 at 09-SEP-17
     
166. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
     
167. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
     
168. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
     
169. channel ORA_SBT_TAPE_2: starting piece 1 at 09-SEP-17
     
170. channel ORA_SBT_TAPE_1: finished piece 1 at 09-SEP-17
     
171. piece handle=0ise1ktm_1_1 tag=NEW3 comment=API Version 2.0,MMS Version 10.4.0.4
     
172. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
     
173. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
     
174. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
     
175. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
     
176. channel ORA_SBT_TAPE_1: starting piece 1 at 09-SEP-17
     
177. channel ORA_SBT_TAPE_2: finished piece 1 at 09-SEP-17
     
178. piece handle=0jse1ktm_1_1 tag=NEW3 comment=API Version 2.0,MMS Version 10.4.0.4
     
179. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:28
     
180. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
     
181. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
     
182. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
     
183. channel ORA_SBT_TAPE_2: starting piece 1 at 09-SEP-17
     
184. channel ORA_SBT_TAPE_1: finished piece 1 at 09-SEP-17
     
185. piece handle=0kse1kuf_1_1 tag=NEW3 comment=API Version 2.0,MMS Version 10.4.0.4
     
186. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:18
     
187. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
     
188. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
     
189. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
     
190. channel ORA_SBT_TAPE_1: starting piece 1 at 09-SEP-17
     
191. channel ORA_SBT_TAPE_2: finished piece 1 at 09-SEP-17
     
192. piece handle=0lse1kui_1_1 tag=NEW3 comment=API Version 2.0,MMS Version 10.4.0.4
     
193. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:16
     
194. channel ORA_SBT_TAPE_1: finished piece 1 at 09-SEP-17
     
195. piece handle=0mse1kv1_1_1 tag=NEW3 comment=API Version 2.0,MMS Version 10.4.0.4
     
196. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
     
197. Finished backup at 09-SEP-17
     
198. 
     
199. Starting backup at 09-SEP-17
     
200. current log archived
     
201. using channel ORA_SBT_TAPE_1
     
202. using channel ORA_SBT_TAPE_2
     
203. channel ORA_SBT_TAPE_1: starting archived log backup set
     
204. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
     
205. input archived log thread=1 sequence=65 RECID=65 STAMP=954258426
     
206. channel ORA_SBT_TAPE_1: starting piece 1 at 09-SEP-17
     
207. channel ORA_SBT_TAPE_1: finished piece 1 at 09-SEP-17
     
208. piece handle=0nse1kvs_1_1 tag=NEW3 comment=API Version 2.0,MMS Version 10.4.0.4
     
209. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:21
     
210. channel ORA_SBT_TAPE_1: deleting archived log(s)
     
211. archived log file name=+FRA/orcl/archivelog/2017_09_09/thread_1_seq_65.281.954258427 RECID=65 STAMP=954258426
     
212. Finished backup at 09-SEP-17
     
213. 
     
214. Starting Control File and SPFILE Autobackup at 09-SEP-17
     
215. RMAN>
     

复制代码

1. [oracle@station90 ~]$ rman target  /
   
2. 
   
3. Recovery Manager: Release 11.2.0.3.0 - Production on Wed Sep 13 09:43:50 2017
   
4. 
   
5. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: ORCL (DBID=1343950367)
   
8. 
   
9. RMAN> show all;
   
10. 
    
11. using target database control file instead of recovery catalog
    
12. RMAN configuration parameters for database with db_unique_name ORCL are:
    
13. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
    
14. CONFIGURE BACKUP OPTIMIZATION ON;
    
15. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
    
16. CONFIGURE CONTROLFILE AUTOBACKUP ON;
    
17. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
    
18. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
    
19. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
    
20. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
    
21. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 2;
    
22. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    
23. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    
24. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
    
25. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)' MAXPIECESIZE 150 M;
    
26. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)' MAXPIECESIZE 150 M;
    
27. CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 150 M;
    
28. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
    
29. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
    
30. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
    
31. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
    
32. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
    
33. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
    
34. 
    
35. RMAN>
    

复制代码