课程第49次（2018-05-23星期三）

botang

关于CDB和PDB的备份：

1. [oracle@station90 ~]$ . oraenv
   
2. ORACLE_SID = [orcl2] ? cdb2
   
3. The Oracle base remains unchanged with value /u01/app/oracle
   
4. [oracle@station90 ~]$ rman target /
   
5. 
   
6. Recovery Manager: Release 12.1.0.2.0 - Production on Wed May 23 19:49:23 2018
   
7. 
   
8. Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
   
9. 
   
10. connected to target database: CDB2 (DBID=723357305)
    
11. 
    
12. RMAN> backup tag '1T_WHOLE_INCR0' incremental level 0 database plus archivelog delete all input;
    
13. 
    
14. 
    
15. Starting backup at 2018-05-23:19:49:39
    
16. current log archived
    
17. using target database control file instead of recovery catalog
    
18. allocated channel: ORA_SBT_TAPE_1
    
19. channel ORA_SBT_TAPE_1: SID=323 device type=SBT_TAPE
    
20. channel ORA_SBT_TAPE_1: Oracle Secure Backup
    
21. allocated channel: ORA_SBT_TAPE_2
    
22. channel ORA_SBT_TAPE_2: SID=934 device type=SBT_TAPE
    
23. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
24. channel ORA_SBT_TAPE_1: starting archived log backup set
    
25. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
    
26. input archived log thread=1 sequence=75 RECID=1 STAMP=976909206
    
27. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-05-23:19:49:54
    
28. channel ORA_SBT_TAPE_2: starting archived log backup set
    
29. channel ORA_SBT_TAPE_2: specifying archived log(s) in backup set
    
30. input archived log thread=1 sequence=76 RECID=2 STAMP=976909780
    
31. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-05-23:19:49:54
    
32. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-05-23:19:50:19
    
33. piece handle=01t3ktf2_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
    
34. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
    
35. channel ORA_SBT_TAPE_1: deleting archived log(s)
    
36. archived log file name=/u01/app/oracle/fast_recovery_area/CDB2/archivelog/2018_05_23/o1_mf_1_75_fjbnrp4h_.arc RECID=1 STAMP=976909206
    
37. channel ORA_SBT_TAPE_2: finished piece 1 at 2018-05-23:19:50:19
    
38. piece handle=02t3ktf2_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
    
39. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
    
40. channel ORA_SBT_TAPE_2: deleting archived log(s)
    
41. archived log file name=/u01/app/oracle/fast_recovery_area/CDB2/archivelog/2018_05_23/o1_mf_1_76_fjbobmyf_.arc RECID=2 STAMP=976909780
    
42. Finished backup at 2018-05-23:19:50:19
    
43. 
    
44. Starting backup at 2018-05-23:19:50:19
    
45. using channel ORA_SBT_TAPE_1
    
46. using channel ORA_SBT_TAPE_2
    
47. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
    
48. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
49. input datafile file number=00004 name=/u01/app/oracle/oradata/cdb2/undotbs01.dbf
    
50. input datafile file number=00003 name=/u01/app/oracle/oradata/cdb2/sysaux01.dbf
    
51. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-05-23:19:50:20
    
52. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
    
53. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
    
54. input datafile file number=00028 name=/u01/app/oracle/oradata/CDB1/datafile/o1_mf_example_fhht9hsj_.dbf
    
55. input datafile file number=00027 name=/u01/app/oracle/oradata/CDB1/datafile/o1_mf_users_fhht9hym_.dbf
    
56. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-05-23:19:50:20
    
57. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-05-23:19:50:45
    
58. piece handle=03t3ktfs_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
    
59. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
    
60. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
    
61. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
62. input datafile file number=00021 name=/u01/app/oracle/oradata/cdb2/pdb_orcl2/system01.dbf
    
63. input datafile file number=00024 name=/u01/app/oracle/oradata/cdb2/pdb_orcl2/example01.dbf
    
64. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-05-23:19:50:45
    
65. channel ORA_SBT_TAPE_2: finished piece 1 at 2018-05-23:19:50:45
    
66. piece handle=04t3ktfs_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
    
67. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
    
68. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
    
69. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
    
70. input datafile file number=00022 name=/u01/app/oracle/oradata/cdb2/pdb_orcl2/sysaux01.dbf
    
71. input datafile file number=00023 name=/u01/app/oracle/oradata/cdb2/pdb_orcl2/users01.dbf
    
72. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-05-23:19:50:45
    
73. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-05-23:19:51:10
    
74. piece handle=05t3ktgl_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
    
75. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
    
76. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
    
77. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
78. input datafile file number=00026 name=/u01/app/oracle/oradata/CDB1/datafile/o1_mf_sysaux_fhht9hv8_.dbf
    
79. input datafile file number=00025 name=/u01/app/oracle/oradata/CDB1/datafile/o1_mf_system_fhht9hx3_.dbf
    
80. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-05-23:19:51:11
    
81. channel ORA_SBT_TAPE_2: finished piece 1 at 2018-05-23:19:51:12
    
82. piece handle=06t3ktgl_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
    
83. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:27
    
84. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
    
85. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
    
86. input datafile file number=00001 name=/u01/app/oracle/oradata/cdb2/system01.dbf
    
87. input datafile file number=00029 name=/u01/app/oracle/oradata/cdb2/cdata_01.dbf
    
88. input datafile file number=00006 name=/u01/app/oracle/oradata/cdb2/users01.dbf
    
89. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-05-23:19:51:12
    
90. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-05-23:19:51:37
    
91. piece handle=07t3kthf_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
    
92. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:26
    
93. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
    
94. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
95. input datafile file number=00011 name=/u01/app/oracle/oradata/cdb2/pdb2_1/sysaux01.dbf
    
96. input datafile file number=00030 name=/u01/app/oracle/oradata/cdb2/pdb2_1/ldata_01.dbf
    
97. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-05-23:19:51:37
    
98. channel ORA_SBT_TAPE_2: finished piece 1 at 2018-05-23:19:51:38
    
99. piece handle=08t3kthg_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
    
100. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:26
     
101. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
     
102. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
     
103. input datafile file number=00017 name=/u01/app/oracle/oradata/cdb2/pdb2_2/CDB2/6C9ADF4F1ED80D0EE0535A00A8C07133/datafile/o1_mf_sysaux_fj1qtlhd_.dbf
     
104. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-05-23:19:51:38
     
105. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-05-23:19:52:03
     
106. piece handle=09t3kti9_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
     
107. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:26
     
108. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
     
109. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
     
110. input datafile file number=00007 name=/u01/app/oracle/oradata/cdb2/pdbseed/sysaux01.dbf
     
111. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-05-23:19:52:03
     
112. channel ORA_SBT_TAPE_2: finished piece 1 at 2018-05-23:19:52:03
     
113. piece handle=0at3ktia_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
     
114. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
     
115. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
     
116. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
     
117. input datafile file number=00010 name=/u01/app/oracle/oradata/cdb2/pdb2_1/system01.dbf
     
118. input datafile file number=00012 name=/u01/app/oracle/oradata/cdb2/pdb2_1/users01.dbf
     
119. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-05-23:19:52:04
     
120. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-05-23:19:52:29
     
121. piece handle=0bt3ktj3_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
     
122. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:26
     
123. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
     
124. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
     
125. input datafile file number=00016 name=/u01/app/oracle/oradata/cdb2/pdb2_2/CDB2/6C9ADF4F1ED80D0EE0535A00A8C07133/datafile/o1_mf_system_fj1qtlhb_.dbf
     
126. input datafile file number=00018 name=/u01/app/oracle/oradata/cdb2/pdb2_2/CDB2/6C9ADF4F1ED80D0EE0535A00A8C07133/datafile/o1_mf_users_fj1qtlhf_.dbf
     
127. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-05-23:19:52:29
     
128. channel ORA_SBT_TAPE_2: finished piece 1 at 2018-05-23:19:52:29
     
129. piece handle=0ct3ktj4_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
     
130. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
     
131. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
     
132. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
     
133. input datafile file number=00005 name=/u01/app/oracle/oradata/cdb2/pdbseed/system01.dbf
     
134. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-05-23:19:52:30
     
135. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-05-23:19:52:55
     
136. piece handle=0dt3ktjt_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
     
137. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:26
     
138. channel ORA_SBT_TAPE_2: finished piece 1 at 2018-05-23:19:52:55
     
139. piece handle=0et3ktjt_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
     
140. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
     
141. Finished backup at 2018-05-23:19:52:55
     
142. 
     
143. Starting backup at 2018-05-23:19:52:55
     
144. current log archived
     
145. using channel ORA_SBT_TAPE_1
     
146. using channel ORA_SBT_TAPE_2
     
147. channel ORA_SBT_TAPE_1: starting archived log backup set
     
148. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
     
149. input archived log thread=1 sequence=77 RECID=3 STAMP=976909975
     
150. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-05-23:19:52:56
     
151. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-05-23:19:53:21
     
152. piece handle=0ft3ktko_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
     
153. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
     
154. channel ORA_SBT_TAPE_1: deleting archived log(s)
     
155. archived log file name=/u01/app/oracle/fast_recovery_area/CDB2/archivelog/2018_05_23/o1_mf_1_77_fjbojqnb_.arc RECID=3 STAMP=976909975
     
156. Finished backup at 2018-05-23:19:53:21
     
157. 
     
158. Starting Control File and SPFILE Autobackup at 2018-05-23:19:53:21
     
159. piece handle=c-723357305-20180523-00 comment=API Version 2.0,MMS Version 10.4.0.4
     
160. Finished Control File and SPFILE Autobackup at 2018-05-23:19:53:46
     
161. 
     
162. RMAN> list backup of database;
     
163. 
     
164. 
     
165. List of Backup Sets
     
166. ===================
     
167. 
     
168. 
     
169. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
170. ------- ---- -- ---------- ----------- ------------ -------------------
     
171. 3       Incr 0  615.50M    SBT_TAPE    00:00:14     2018-05-23:19:50:34
     
172.         BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
173.         Handle: 03t3ktfs_1_1   Media: station90-000008
     
174.   List of Datafiles in backup set 3
     
175.   File LV Type Ckp SCN    Ckp Time            Name
     
176.   ---- -- ---- ---------- ------------------- ----
     
177.   3    0  Incr 4293884    2018-05-23:19:50:20 /u01/app/oracle/oradata/cdb2/sysaux01.dbf
     
178.   4    0  Incr 4293884    2018-05-23:19:50:20 /u01/app/oracle/oradata/cdb2/undotbs01.dbf
     
179. 
     
180. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
181. ------- ---- -- ---------- ----------- ------------ -------------------
     
182. 4       Incr 0  98.00M     SBT_TAPE    00:00:15     2018-05-23:19:50:35
     
183.         BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
184.         Handle: 04t3ktfs_1_1   Media: station90-000007
     
185.   List of Datafiles in backup set 4
     
186.   Container ID: 6, PDB Name: PDB1_1
     
187.   File LV Type Ckp SCN    Ckp Time            Name
     
188.   ---- -- ---- ---------- ------------------- ----
     
189.   27   0  Incr 4293885    2018-05-23:19:50:20 /u01/app/oracle/oradata/CDB1/datafile/o1_mf_users_fhht9hym_.dbf
     
190.   28   0  Incr 4293885    2018-05-23:19:50:20 /u01/app/oracle/oradata/CDB1/datafile/o1_mf_example_fhht9hsj_.dbf
     
191. 
     
192. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
193. ------- ---- -- ---------- ----------- ------------ -------------------
     
194. 5       Incr 0  932.75M    SBT_TAPE    00:00:17     2018-05-23:19:51:02
     
195.         BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
196.         Handle: 05t3ktgl_1_1   Media: station90-000007
     
197.   List of Datafiles in backup set 5
     
198.   Container ID: 5, PDB Name: PDB_ORCL2
     
199.   File LV Type Ckp SCN    Ckp Time            Name
     
200.   ---- -- ---- ---------- ------------------- ----
     
201.   21   0  Incr 4293895    2018-05-23:19:50:45 /u01/app/oracle/oradata/cdb2/pdb_orcl2/system01.dbf
     
202.   24   0  Incr 4293895    2018-05-23:19:50:45 /u01/app/oracle/oradata/cdb2/pdb_orcl2/example01.dbf
     
203. 
     
204. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
205. ------- ---- -- ---------- ----------- ------------ -------------------
     
206. 6       Incr 0  776.75M    SBT_TAPE    00:00:17     2018-05-23:19:51:02
     
207.         BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
208.         Handle: 06t3ktgl_1_1   Media: station90-000008
     
209.   List of Datafiles in backup set 6
     
210.   Container ID: 5, PDB Name: PDB_ORCL2
     
211.   File LV Type Ckp SCN    Ckp Time            Name
     
212.   ---- -- ---- ---------- ------------------- ----
     
213.   22   0  Incr 4293896    2018-05-23:19:50:45 /u01/app/oracle/oradata/cdb2/pdb_orcl2/sysaux01.dbf
     
214.   23   0  Incr 4293896    2018-05-23:19:50:45 /u01/app/oracle/oradata/cdb2/pdb_orcl2/users01.dbf
     
215. 
     
216. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
217. ------- ---- -- ---------- ----------- ------------ -------------------
     
218. 7       Incr 0  691.00M    SBT_TAPE    00:00:16     2018-05-23:19:51:27
     
219.         BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
220.         Handle: 07t3kthf_1_1   Media: station90-000007
     
221.   List of Datafiles in backup set 7
     
222.   Container ID: 6, PDB Name: PDB1_1
     
223.   File LV Type Ckp SCN    Ckp Time            Name
     
224.   ---- -- ---- ---------- ------------------- ----
     
225.   25   0  Incr 4293906    2018-05-23:19:51:11 /u01/app/oracle/oradata/CDB1/datafile/o1_mf_system_fhht9hx3_.dbf
     
226.   26   0  Incr 4293906    2018-05-23:19:51:11 /u01/app/oracle/oradata/CDB1/datafile/o1_mf_sysaux_fhht9hv8_.dbf
     
227. 
     
228. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
229. ------- ---- -- ---------- ----------- ------------ -------------------
     
230. 8       Incr 0  679.50M    SBT_TAPE    00:00:17     2018-05-23:19:51:29
     
231.         BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
232.         Handle: 08t3kthg_1_1   Media: station90-000008
     
233.   List of Datafiles in backup set 8
     
234.   File LV Type Ckp SCN    Ckp Time            Name
     
235.   ---- -- ---- ---------- ------------------- ----
     
236.   1    0  Incr 4293908    2018-05-23:19:51:12 /u01/app/oracle/oradata/cdb2/system01.dbf
     
237.   6    0  Incr 4293908    2018-05-23:19:51:12 /u01/app/oracle/oradata/cdb2/users01.dbf
     
238.   29   0  Incr 4293908    2018-05-23:19:51:12 /u01/app/oracle/oradata/cdb2/cdata_01.dbf
     
239. 
     
240. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
241. ------- ---- -- ---------- ----------- ------------ -------------------
     
242. 9       Incr 0  465.75M    SBT_TAPE    00:00:13     2018-05-23:19:51:50
     
243.         BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
244.         Handle: 09t3kti9_1_1   Media: station90-000007
     
245.   List of Datafiles in backup set 9
     
246.   Container ID: 3, PDB Name: PDB2
     
247.   File LV Type Ckp SCN    Ckp Time            Name
     
248.   ---- -- ---- ---------- ------------------- ----
     
249.   11   0  Incr 4293917    2018-05-23:19:51:37 /u01/app/oracle/oradata/cdb2/pdb2_1/sysaux01.dbf
     
250.   30   0  Incr 4293917    2018-05-23:19:51:37 /u01/app/oracle/oradata/cdb2/pdb2_1/ldata_01.dbf
     
251. 
     
252. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
253. ------- ---- -- ---------- ----------- ------------ -------------------
     
254. 10      Incr 0  464.75M    SBT_TAPE    00:00:13     2018-05-23:19:51:51
     
255.         BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
256.         Handle: 0at3ktia_1_1   Media: station90-000008
     
257.   List of Datafiles in backup set 10
     
258.   Container ID: 4, PDB Name: PDB2_2
     
259.   File LV Type Ckp SCN    Ckp Time            Name
     
260.   ---- -- ---- ---------- ------------------- ----
     
261.   17   0  Incr 4293919    2018-05-23:19:51:38 /u01/app/oracle/oradata/cdb2/pdb2_2/CDB2/6C9ADF4F1ED80D0EE0535A00A8C07133/datafile/o1_mf_sysaux_fj1qtlhd_.dbf
     
262. 
     
263. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
264. ------- ---- -- ---------- ----------- ------------ -------------------
     
265. 11      Incr 0  210.50M    SBT_TAPE    00:00:11     2018-05-23:19:52:15
     
266.         BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
267.         Handle: 0ct3ktj4_1_1   Media: station90-000008
     
268.   List of Datafiles in backup set 11
     
269.   Container ID: 3, PDB Name: PDB2
     
270.   File LV Type Ckp SCN    Ckp Time            Name
     
271.   ---- -- ---- ---------- ------------------- ----
     
272.   10   0  Incr 4293929    2018-05-23:19:52:04 /u01/app/oracle/oradata/cdb2/pdb2_1/system01.dbf
     
273.   12   0  Incr 4293929    2018-05-23:19:52:04 /u01/app/oracle/oradata/cdb2/pdb2_1/users01.dbf
     
274. 
     
275. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
276. ------- ---- -- ---------- ----------- ------------ -------------------
     
277. 12      Incr 0  456.25M    SBT_TAPE    00:00:13     2018-05-23:19:52:16
     
278.         BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
279.         Handle: 0bt3ktj3_1_1   Media: station90-000007
     
280.   List of Datafiles in backup set 12
     
281.   Container ID: 2, PDB Name: PDB$SEED
     
282.   File LV Type Ckp SCN    Ckp Time            Name
     
283.   ---- -- ---- ---------- ------------------- ----
     
284.   7    0  Incr 1740084    2018-05-16:21:27:24 /u01/app/oracle/oradata/cdb2/pdbseed/sysaux01.dbf
     
285. 
     
286. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
287. ------- ---- -- ---------- ----------- ------------ -------------------
     
288. 13      Incr 0  210.50M    SBT_TAPE    00:00:10     2018-05-23:19:52:39
     
289.         BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
290.         Handle: 0dt3ktjt_1_1   Media: station90-000007
     
291.   List of Datafiles in backup set 13
     
292.   Container ID: 4, PDB Name: PDB2_2
     
293.   File LV Type Ckp SCN    Ckp Time            Name
     
294.   ---- -- ---- ---------- ------------------- ----
     
295.   16   0  Incr 4293943    2018-05-23:19:52:29 /u01/app/oracle/oradata/cdb2/pdb2_2/CDB2/6C9ADF4F1ED80D0EE0535A00A8C07133/datafile/o1_mf_system_fj1qtlhb_.dbf
     
296.   18   0  Incr 4293943    2018-05-23:19:52:29 /u01/app/oracle/oradata/cdb2/pdb2_2/CDB2/6C9ADF4F1ED80D0EE0535A00A8C07133/datafile/o1_mf_users_fj1qtlhf_.dbf
     
297. 
     
298. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
299. ------- ---- -- ---------- ----------- ------------ -------------------
     
300. 14      Incr 0  204.75M    SBT_TAPE    00:00:11     2018-05-23:19:52:40
     
301.         BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
302.         Handle: 0et3ktjt_1_1   Media: station90-000008
     
303.   List of Datafiles in backup set 14
     
304.   Container ID: 2, PDB Name: PDB$SEED
     
305.   File LV Type Ckp SCN    Ckp Time            Name
     
306.   ---- -- ---- ---------- ------------------- ----
     
307.   5    0  Incr 1740084    2018-05-16:21:27:24 /u01/app/oracle/oradata/cdb2/pdbseed/system01.dbf
     
308. 
     
309. RMAN> list backup ;
     
310. 
     
311. 
     
312. List of Backup Sets
     
313. ===================
     
314. 
     
315. 
     
316. BS Key  Size       Device Type Elapsed Time Completion Time   
     
317. ------- ---------- ----------- ------------ -------------------
     
318. 1       768.00K    SBT_TAPE    00:00:16     2018-05-23:19:50:10
     
319.         BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
320.         Handle: 02t3ktf2_1_1   Media: station90-000007
     
321. 
     
322.   List of Archived Logs in backup set 1
     
323.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
     
324.   ---- ------- ---------- ------------------- ---------- ---------
     
325.   1    76      4292078    2018-05-23:19:40:05 4293826    2018-05-23:19:49:39
     
326. 
     
327. BS Key  Size       Device Type Elapsed Time Completion Time   
     
328. ------- ---------- ----------- ------------ -------------------
     
329. 2       5.50M      SBT_TAPE    00:00:17     2018-05-23:19:50:11
     
330.         BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
331.         Handle: 01t3ktf2_1_1   Media: station90-000008
     
332. 
     
333.   List of Archived Logs in backup set 2
     
334.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
     
335.   ---- ------- ---------- ------------------- ---------- ---------
     
336.   1    75      4188069    2018-05-23:17:00:40 4292078    2018-05-23:19:40:05
     
337. 
     
338. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
339. ------- ---- -- ---------- ----------- ------------ -------------------
     
340. 3       Incr 0  615.50M    SBT_TAPE    00:00:14     2018-05-23:19:50:34
     
341.         BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
342.         Handle: 03t3ktfs_1_1   Media: station90-000008
     
343.   List of Datafiles in backup set 3
     
344.   File LV Type Ckp SCN    Ckp Time            Name
     
345.   ---- -- ---- ---------- ------------------- ----
     
346.   3    0  Incr 4293884    2018-05-23:19:50:20 /u01/app/oracle/oradata/cdb2/sysaux01.dbf
     
347.   4    0  Incr 4293884    2018-05-23:19:50:20 /u01/app/oracle/oradata/cdb2/undotbs01.dbf
     
348. 
     
349. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
350. ------- ---- -- ---------- ----------- ------------ -------------------
     
351. 4       Incr 0  98.00M     SBT_TAPE    00:00:15     2018-05-23:19:50:35
     
352.         BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
353.         Handle: 04t3ktfs_1_1   Media: station90-000007
     
354.   List of Datafiles in backup set 4
     
355.   Container ID: 6, PDB Name: PDB1_1
     
356.   File LV Type Ckp SCN    Ckp Time            Name
     
357.   ---- -- ---- ---------- ------------------- ----
     
358.   27   0  Incr 4293885    2018-05-23:19:50:20 /u01/app/oracle/oradata/CDB1/datafile/o1_mf_users_fhht9hym_.dbf
     
359.   28   0  Incr 4293885    2018-05-23:19:50:20 /u01/app/oracle/oradata/CDB1/datafile/o1_mf_example_fhht9hsj_.dbf
     
360. 
     
361. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
362. ------- ---- -- ---------- ----------- ------------ -------------------
     
363. 5       Incr 0  932.75M    SBT_TAPE    00:00:17     2018-05-23:19:51:02
     
364.         BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
365.         Handle: 05t3ktgl_1_1   Media: station90-000007
     
366.   List of Datafiles in backup set 5
     
367.   Container ID: 5, PDB Name: PDB_ORCL2
     
368.   File LV Type Ckp SCN    Ckp Time            Name
     
369.   ---- -- ---- ---------- ------------------- ----
     
370.   21   0  Incr 4293895    2018-05-23:19:50:45 /u01/app/oracle/oradata/cdb2/pdb_orcl2/system01.dbf
     
371.   24   0  Incr 4293895    2018-05-23:19:50:45 /u01/app/oracle/oradata/cdb2/pdb_orcl2/example01.dbf
     
372. 
     
373. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
374. ------- ---- -- ---------- ----------- ------------ -------------------
     
375. 6       Incr 0  776.75M    SBT_TAPE    00:00:17     2018-05-23:19:51:02
     
376.         BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
377.         Handle: 06t3ktgl_1_1   Media: station90-000008
     
378.   List of Datafiles in backup set 6
     
379.   Container ID: 5, PDB Name: PDB_ORCL2
     
380.   File LV Type Ckp SCN    Ckp Time            Name
     
381.   ---- -- ---- ---------- ------------------- ----
     
382.   22   0  Incr 4293896    2018-05-23:19:50:45 /u01/app/oracle/oradata/cdb2/pdb_orcl2/sysaux01.dbf
     
383.   23   0  Incr 4293896    2018-05-23:19:50:45 /u01/app/oracle/oradata/cdb2/pdb_orcl2/users01.dbf
     
384. 
     
385. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
386. ------- ---- -- ---------- ----------- ------------ -------------------
     
387. 7       Incr 0  691.00M    SBT_TAPE    00:00:16     2018-05-23:19:51:27
     
388.         BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
389.         Handle: 07t3kthf_1_1   Media: station90-000007
     
390.   List of Datafiles in backup set 7
     
391.   Container ID: 6, PDB Name: PDB1_1
     
392.   File LV Type Ckp SCN    Ckp Time            Name
     
393.   ---- -- ---- ---------- ------------------- ----
     
394.   25   0  Incr 4293906    2018-05-23:19:51:11 /u01/app/oracle/oradata/CDB1/datafile/o1_mf_system_fhht9hx3_.dbf
     
395.   26   0  Incr 4293906    2018-05-23:19:51:11 /u01/app/oracle/oradata/CDB1/datafile/o1_mf_sysaux_fhht9hv8_.dbf
     
396. 
     
397. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
398. ------- ---- -- ---------- ----------- ------------ -------------------
     
399. 8       Incr 0  679.50M    SBT_TAPE    00:00:17     2018-05-23:19:51:29
     
400.         BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
401.         Handle: 08t3kthg_1_1   Media: station90-000008
     
402.   List of Datafiles in backup set 8
     
403.   File LV Type Ckp SCN    Ckp Time            Name
     
404.   ---- -- ---- ---------- ------------------- ----
     
405.   1    0  Incr 4293908    2018-05-23:19:51:12 /u01/app/oracle/oradata/cdb2/system01.dbf
     
406.   6    0  Incr 4293908    2018-05-23:19:51:12 /u01/app/oracle/oradata/cdb2/users01.dbf
     
407.   29   0  Incr 4293908    2018-05-23:19:51:12 /u01/app/oracle/oradata/cdb2/cdata_01.dbf
     
408. 
     
409. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
410. ------- ---- -- ---------- ----------- ------------ -------------------
     
411. 9       Incr 0  465.75M    SBT_TAPE    00:00:13     2018-05-23:19:51:50
     
412.         BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
413.         Handle: 09t3kti9_1_1   Media: station90-000007
     
414.   List of Datafiles in backup set 9
     
415.   Container ID: 3, PDB Name: PDB2
     
416.   File LV Type Ckp SCN    Ckp Time            Name
     
417.   ---- -- ---- ---------- ------------------- ----
     
418.   11   0  Incr 4293917    2018-05-23:19:51:37 /u01/app/oracle/oradata/cdb2/pdb2_1/sysaux01.dbf
     
419.   30   0  Incr 4293917    2018-05-23:19:51:37 /u01/app/oracle/oradata/cdb2/pdb2_1/ldata_01.dbf
     
420. 
     
421. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
422. ------- ---- -- ---------- ----------- ------------ -------------------
     
423. 10      Incr 0  464.75M    SBT_TAPE    00:00:13     2018-05-23:19:51:51
     
424.         BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
425.         Handle: 0at3ktia_1_1   Media: station90-000008
     
426.   List of Datafiles in backup set 10
     
427.   Container ID: 4, PDB Name: PDB2_2
     
428.   File LV Type Ckp SCN    Ckp Time            Name
     
429.   ---- -- ---- ---------- ------------------- ----
     
430.   17   0  Incr 4293919    2018-05-23:19:51:38 /u01/app/oracle/oradata/cdb2/pdb2_2/CDB2/6C9ADF4F1ED80D0EE0535A00A8C07133/datafile/o1_mf_sysaux_fj1qtlhd_.dbf
     
431. 
     
432. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
433. ------- ---- -- ---------- ----------- ------------ -------------------
     
434. 11      Incr 0  210.50M    SBT_TAPE    00:00:11     2018-05-23:19:52:15
     
435.         BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
436.         Handle: 0ct3ktj4_1_1   Media: station90-000008
     
437.   List of Datafiles in backup set 11
     
438.   Container ID: 3, PDB Name: PDB2
     
439.   File LV Type Ckp SCN    Ckp Time            Name
     
440.   ---- -- ---- ---------- ------------------- ----
     
441.   10   0  Incr 4293929    2018-05-23:19:52:04 /u01/app/oracle/oradata/cdb2/pdb2_1/system01.dbf
     
442.   12   0  Incr 4293929    2018-05-23:19:52:04 /u01/app/oracle/oradata/cdb2/pdb2_1/users01.dbf
     
443. 
     
444. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
445. ------- ---- -- ---------- ----------- ------------ -------------------
     
446. 12      Incr 0  456.25M    SBT_TAPE    00:00:13     2018-05-23:19:52:16
     
447.         BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
448.         Handle: 0bt3ktj3_1_1   Media: station90-000007
     
449.   List of Datafiles in backup set 12
     
450.   Container ID: 2, PDB Name: PDB$SEED
     
451.   File LV Type Ckp SCN    Ckp Time            Name
     
452.   ---- -- ---- ---------- ------------------- ----
     
453.   7    0  Incr 1740084    2018-05-16:21:27:24 /u01/app/oracle/oradata/cdb2/pdbseed/sysaux01.dbf
     
454. 
     
455. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
456. ------- ---- -- ---------- ----------- ------------ -------------------
     
457. 13      Incr 0  210.50M    SBT_TAPE    00:00:10     2018-05-23:19:52:39
     
458.         BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
459.         Handle: 0dt3ktjt_1_1   Media: station90-000007
     
460.   List of Datafiles in backup set 13
     
461.   Container ID: 4, PDB Name: PDB2_2
     
462.   File LV Type Ckp SCN    Ckp Time            Name
     
463.   ---- -- ---- ---------- ------------------- ----
     
464.   16   0  Incr 4293943    2018-05-23:19:52:29 /u01/app/oracle/oradata/cdb2/pdb2_2/CDB2/6C9ADF4F1ED80D0EE0535A00A8C07133/datafile/o1_mf_system_fj1qtlhb_.dbf
     
465.   18   0  Incr 4293943    2018-05-23:19:52:29 /u01/app/oracle/oradata/cdb2/pdb2_2/CDB2/6C9ADF4F1ED80D0EE0535A00A8C07133/datafile/o1_mf_users_fj1qtlhf_.dbf
     
466. 
     
467. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
468. ------- ---- -- ---------- ----------- ------------ -------------------
     
469. 14      Incr 0  204.75M    SBT_TAPE    00:00:11     2018-05-23:19:52:40
     
470.         BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
471.         Handle: 0et3ktjt_1_1   Media: station90-000008
     
472.   List of Datafiles in backup set 14
     
473.   Container ID: 2, PDB Name: PDB$SEED
     
474.   File LV Type Ckp SCN    Ckp Time            Name
     
475.   ---- -- ---- ---------- ------------------- ----
     
476.   5    0  Incr 1740084    2018-05-16:21:27:24 /u01/app/oracle/oradata/cdb2/pdbseed/system01.dbf
     
477. 
     
478. BS Key  Size       Device Type Elapsed Time Completion Time   
     
479. ------- ---------- ----------- ------------ -------------------
     
480. 15      256.00K    SBT_TAPE    00:00:08     2018-05-23:19:53:04
     
481.         BP Key: 15   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
482.         Handle: 0ft3ktko_1_1   Media: station90-000007
     
483. 
     
484.   List of Archived Logs in backup set 15
     
485.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
     
486.   ---- ------- ---------- ------------------- ---------- ---------
     
487.   1    77      4293826    2018-05-23:19:49:39 4293957    2018-05-23:19:52:55
     
488. 
     
489. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
490. ------- ---- -- ---------- ----------- ------------ -------------------
     
491. 16      Full    17.25M     SBT_TAPE    00:00:09     2018-05-23:19:53:30
     
492.         BP Key: 16   Status: AVAILABLE  Compressed: NO  Tag: TAG20180523T195321
     
493.         Handle: c-723357305-20180523-00   Media: station90-000007
     
494.   SPFILE Included: Modification time: 2018-05-23:19:40:46
     
495.   SPFILE db_unique_name: CDB2
     
496.   Control File Included: Ckp SCN: 4293978      Ckp time: 2018-05-23:19:53:21
     
497. 
     
498. RMAN> list backup of database;
     
499. 
     
500. 
     
501. List of Backup Sets
     
502. ===================
     
503. 
     
504. 
     
505. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
506. ------- ---- -- ---------- ----------- ------------ -------------------
     
507. 3       Incr 0  615.50M    SBT_TAPE    00:00:14     2018-05-23:19:50:34
     
508.         BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
509.         Handle: 03t3ktfs_1_1   Media: station90-000008
     
510.   List of Datafiles in backup set 3
     
511.   File LV Type Ckp SCN    Ckp Time            Name
     
512.   ---- -- ---- ---------- ------------------- ----
     
513.   3    0  Incr 4293884    2018-05-23:19:50:20 /u01/app/oracle/oradata/cdb2/sysaux01.dbf
     
514.   4    0  Incr 4293884    2018-05-23:19:50:20 /u01/app/oracle/oradata/cdb2/undotbs01.dbf
     
515. 
     
516. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
517. ------- ---- -- ---------- ----------- ------------ -------------------
     
518. 4       Incr 0  98.00M     SBT_TAPE    00:00:15     2018-05-23:19:50:35
     
519.         BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
520.         Handle: 04t3ktfs_1_1   Media: station90-000007
     
521.   List of Datafiles in backup set 4
     
522.   Container ID: 6, PDB Name: PDB1_1
     
523.   File LV Type Ckp SCN    Ckp Time            Name
     
524.   ---- -- ---- ---------- ------------------- ----
     
525.   27   0  Incr 4293885    2018-05-23:19:50:20 /u01/app/oracle/oradata/CDB1/datafile/o1_mf_users_fhht9hym_.dbf
     
526.   28   0  Incr 4293885    2018-05-23:19:50:20 /u01/app/oracle/oradata/CDB1/datafile/o1_mf_example_fhht9hsj_.dbf
     
527. 
     
528. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
529. ------- ---- -- ---------- ----------- ------------ -------------------
     
530. 5       Incr 0  932.75M    SBT_TAPE    00:00:17     2018-05-23:19:51:02
     
531.         BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
532.         Handle: 05t3ktgl_1_1   Media: station90-000007
     
533.   List of Datafiles in backup set 5
     
534.   Container ID: 5, PDB Name: PDB_ORCL2
     
535.   File LV Type Ckp SCN    Ckp Time            Name
     
536.   ---- -- ---- ---------- ------------------- ----
     
537.   21   0  Incr 4293895    2018-05-23:19:50:45 /u01/app/oracle/oradata/cdb2/pdb_orcl2/system01.dbf
     
538.   24   0  Incr 4293895    2018-05-23:19:50:45 /u01/app/oracle/oradata/cdb2/pdb_orcl2/example01.dbf
     
539. 
     
540. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
541. ------- ---- -- ---------- ----------- ------------ -------------------
     
542. 6       Incr 0  776.75M    SBT_TAPE    00:00:17     2018-05-23:19:51:02
     
543.         BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
544.         Handle: 06t3ktgl_1_1   Media: station90-000008
     
545.   List of Datafiles in backup set 6
     
546.   Container ID: 5, PDB Name: PDB_ORCL2
     
547.   File LV Type Ckp SCN    Ckp Time            Name
     
548.   ---- -- ---- ---------- ------------------- ----
     
549.   22   0  Incr 4293896    2018-05-23:19:50:45 /u01/app/oracle/oradata/cdb2/pdb_orcl2/sysaux01.dbf
     
550.   23   0  Incr 4293896    2018-05-23:19:50:45 /u01/app/oracle/oradata/cdb2/pdb_orcl2/users01.dbf
     
551. 
     
552. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
553. ------- ---- -- ---------- ----------- ------------ -------------------
     
554. 7       Incr 0  691.00M    SBT_TAPE    00:00:16     2018-05-23:19:51:27
     
555.         BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
556.         Handle: 07t3kthf_1_1   Media: station90-000007
     
557.   List of Datafiles in backup set 7
     
558.   Container ID: 6, PDB Name: PDB1_1
     
559.   File LV Type Ckp SCN    Ckp Time            Name
     
560.   ---- -- ---- ---------- ------------------- ----
     
561.   25   0  Incr 4293906    2018-05-23:19:51:11 /u01/app/oracle/oradata/CDB1/datafile/o1_mf_system_fhht9hx3_.dbf
     
562.   26   0  Incr 4293906    2018-05-23:19:51:11 /u01/app/oracle/oradata/CDB1/datafile/o1_mf_sysaux_fhht9hv8_.dbf
     
563. 
     
564. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
565. ------- ---- -- ---------- ----------- ------------ -------------------
     
566. 8       Incr 0  679.50M    SBT_TAPE    00:00:17     2018-05-23:19:51:29
     
567.         BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
568.         Handle: 08t3kthg_1_1   Media: station90-000008
     
569.   List of Datafiles in backup set 8
     
570.   File LV Type Ckp SCN    Ckp Time            Name
     
571.   ---- -- ---- ---------- ------------------- ----
     
572.   1    0  Incr 4293908    2018-05-23:19:51:12 /u01/app/oracle/oradata/cdb2/system01.dbf
     
573.   6    0  Incr 4293908    2018-05-23:19:51:12 /u01/app/oracle/oradata/cdb2/users01.dbf
     
574.   29   0  Incr 4293908    2018-05-23:19:51:12 /u01/app/oracle/oradata/cdb2/cdata_01.dbf
     
575. 
     
576. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
577. ------- ---- -- ---------- ----------- ------------ -------------------
     
578. 9       Incr 0  465.75M    SBT_TAPE    00:00:13     2018-05-23:19:51:50
     
579.         BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
580.         Handle: 09t3kti9_1_1   Media: station90-000007
     
581.   List of Datafiles in backup set 9
     
582.   Container ID: 3, PDB Name: PDB2
     
583.   File LV Type Ckp SCN    Ckp Time            Name
     
584.   ---- -- ---- ---------- ------------------- ----
     
585.   11   0  Incr 4293917    2018-05-23:19:51:37 /u01/app/oracle/oradata/cdb2/pdb2_1/sysaux01.dbf
     
586.   30   0  Incr 4293917    2018-05-23:19:51:37 /u01/app/oracle/oradata/cdb2/pdb2_1/ldata_01.dbf
     
587. 
     
588. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
589. ------- ---- -- ---------- ----------- ------------ -------------------
     
590. 10      Incr 0  464.75M    SBT_TAPE    00:00:13     2018-05-23:19:51:51
     
591.         BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
592.         Handle: 0at3ktia_1_1   Media: station90-000008
     
593.   List of Datafiles in backup set 10
     
594.   Container ID: 4, PDB Name: PDB2_2
     
595.   File LV Type Ckp SCN    Ckp Time            Name
     
596.   ---- -- ---- ---------- ------------------- ----
     
597.   17   0  Incr 4293919    2018-05-23:19:51:38 /u01/app/oracle/oradata/cdb2/pdb2_2/CDB2/6C9ADF4F1ED80D0EE0535A00A8C07133/datafile/o1_mf_sysaux_fj1qtlhd_.dbf
     
598. 
     
599. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
600. ------- ---- -- ---------- ----------- ------------ -------------------
     
601. 11      Incr 0  210.50M    SBT_TAPE    00:00:11     2018-05-23:19:52:15
     
602.         BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
603.         Handle: 0ct3ktj4_1_1   Media: station90-000008
     
604.   List of Datafiles in backup set 11
     
605.   Container ID: 3, PDB Name: PDB2
     
606.   File LV Type Ckp SCN    Ckp Time            Name
     
607.   ---- -- ---- ---------- ------------------- ----
     
608.   10   0  Incr 4293929    2018-05-23:19:52:04 /u01/app/oracle/oradata/cdb2/pdb2_1/system01.dbf
     
609.   12   0  Incr 4293929    2018-05-23:19:52:04 /u01/app/oracle/oradata/cdb2/pdb2_1/users01.dbf
     
610. 
     
611. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
612. ------- ---- -- ---------- ----------- ------------ -------------------
     
613. 12      Incr 0  456.25M    SBT_TAPE    00:00:13     2018-05-23:19:52:16
     
614.         BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
615.         Handle: 0bt3ktj3_1_1   Media: station90-000007
     
616.   List of Datafiles in backup set 12
     
617.   Container ID: 2, PDB Name: PDB$SEED
     
618.   File LV Type Ckp SCN    Ckp Time            Name
     
619.   ---- -- ---- ---------- ------------------- ----
     
620.   7    0  Incr 1740084    2018-05-16:21:27:24 /u01/app/oracle/oradata/cdb2/pdbseed/sysaux01.dbf
     
621. 
     
622. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
623. ------- ---- -- ---------- ----------- ------------ -------------------
     
624. 13      Incr 0  210.50M    SBT_TAPE    00:00:10     2018-05-23:19:52:39
     
625.         BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
626.         Handle: 0dt3ktjt_1_1   Media: station90-000007
     
627.   List of Datafiles in backup set 13
     
628.   Container ID: 4, PDB Name: PDB2_2
     
629.   File LV Type Ckp SCN    Ckp Time            Name
     
630.   ---- -- ---- ---------- ------------------- ----
     
631.   16   0  Incr 4293943    2018-05-23:19:52:29 /u01/app/oracle/oradata/cdb2/pdb2_2/CDB2/6C9ADF4F1ED80D0EE0535A00A8C07133/datafile/o1_mf_system_fj1qtlhb_.dbf
     
632.   18   0  Incr 4293943    2018-05-23:19:52:29 /u01/app/oracle/oradata/cdb2/pdb2_2/CDB2/6C9ADF4F1ED80D0EE0535A00A8C07133/datafile/o1_mf_users_fj1qtlhf_.dbf
     
633. 
     
634. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
635. ------- ---- -- ---------- ----------- ------------ -------------------
     
636. 14      Incr 0  204.75M    SBT_TAPE    00:00:11     2018-05-23:19:52:40
     
637.         BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
638.         Handle: 0et3ktjt_1_1   Media: station90-000008
     
639.   List of Datafiles in backup set 14
     
640.   Container ID: 2, PDB Name: PDB$SEED
     
641.   File LV Type Ckp SCN    Ckp Time            Name
     
642.   ---- -- ---- ---------- ------------------- ----
     
643.   5    0  Incr 1740084    2018-05-16:21:27:24 /u01/app/oracle/oradata/cdb2/pdbseed/system01.dbf
     
644. 
     
645. RMAN> list backup of pluggable  database pdb2;
     
646. 
     
647. 
     
648. List of Backup Sets
     
649. ===================
     
650. 
     
651. 
     
652. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
653. ------- ---- -- ---------- ----------- ------------ -------------------
     
654. 9       Incr 0  465.75M    SBT_TAPE    00:00:13     2018-05-23:19:51:50
     
655.         BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
656.         Handle: 09t3kti9_1_1   Media: station90-000007
     
657.   List of Datafiles in backup set 9
     
658.   Container ID: 3, PDB Name: PDB2
     
659.   File LV Type Ckp SCN    Ckp Time            Name
     
660.   ---- -- ---- ---------- ------------------- ----
     
661.   11   0  Incr 4293917    2018-05-23:19:51:37 /u01/app/oracle/oradata/cdb2/pdb2_1/sysaux01.dbf
     
662.   30   0  Incr 4293917    2018-05-23:19:51:37 /u01/app/oracle/oradata/cdb2/pdb2_1/ldata_01.dbf
     
663. 
     
664. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
665. ------- ---- -- ---------- ----------- ------------ -------------------
     
666. 11      Incr 0  210.50M    SBT_TAPE    00:00:11     2018-05-23:19:52:15
     
667.         BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
668.         Handle: 0ct3ktj4_1_1   Media: station90-000008
     
669.   List of Datafiles in backup set 11
     
670.   Container ID: 3, PDB Name: PDB2
     
671.   File LV Type Ckp SCN    Ckp Time            Name
     
672.   ---- -- ---- ---------- ------------------- ----
     
673.   10   0  Incr 4293929    2018-05-23:19:52:04 /u01/app/oracle/oradata/cdb2/pdb2_1/system01.dbf
     
674.   12   0  Incr 4293929    2018-05-23:19:52:04 /u01/app/oracle/oradata/cdb2/pdb2_1/users01.dbf
     
675. 
     
676. RMAN> backup tag '2T_PLUG-PDB2_INCR0'  incremental level 0 pluggable database pdb2 plus archivelog ;
     
677. 
     
678. 
     
679. Starting backup at 2018-05-23:19:59:38
     
680. current log archived
     
681. using channel ORA_SBT_TAPE_1
     
682. using channel ORA_SBT_TAPE_2
     
683. channel ORA_SBT_TAPE_1: starting archived log backup set
     
684. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
     
685. input archived log thread=1 sequence=78 RECID=4 STAMP=976910379
     
686. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-05-23:19:59:39
     
687. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-05-23:19:59:54
     
688. piece handle=0ht3ku1b_1_1 tag=2T_PLUG-PDB2_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
     
689. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:15
     
690. Finished backup at 2018-05-23:19:59:54
     
691. 
     
692. Starting backup at 2018-05-23:19:59:54
     
693. using channel ORA_SBT_TAPE_1
     
694. using channel ORA_SBT_TAPE_2
     
695. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
     
696. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
     
697. input datafile file number=00011 name=/u01/app/oracle/oradata/cdb2/pdb2_1/sysaux01.dbf
     
698. input datafile file number=00030 name=/u01/app/oracle/oradata/cdb2/pdb2_1/ldata_01.dbf
     
699. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-05-23:19:59:55
     
700. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
     
701. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
     
702. input datafile file number=00010 name=/u01/app/oracle/oradata/cdb2/pdb2_1/system01.dbf
     
703. input datafile file number=00012 name=/u01/app/oracle/oradata/cdb2/pdb2_1/users01.dbf
     
704. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-05-23:19:59:55
     
705. 
     

复制代码

当再次使用 list backup ...看到PDB2多了几个备份集（在备份恢复的视角看，插件数据库就是一群特定表空间）：

1. RMAN> list backup of pluggable  database pdb2;
   
2. 
   
3. 
   
4. List of Backup Sets
   
5. ===================
   
6. 
   
7. 
   
8. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
   
9. ------- ---- -- ---------- ----------- ------------ -------------------
   
10. 9       Incr 0  465.75M    SBT_TAPE    00:00:13     2018-05-23:19:51:50
    
11.         BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
    
12.         Handle: 09t3kti9_1_1   Media: station90-000007
    
13.   List of Datafiles in backup set 9
    
14.   Container ID: 3, PDB Name: PDB2
    
15.   File LV Type Ckp SCN    Ckp Time            Name
    
16.   ---- -- ---- ---------- ------------------- ----
    
17.   11   0  Incr 4293917    2018-05-23:19:51:37 /u01/app/oracle/oradata/cdb2/pdb2_1/sysaux01.dbf
    
18.   30   0  Incr 4293917    2018-05-23:19:51:37 /u01/app/oracle/oradata/cdb2/pdb2_1/ldata_01.dbf
    
19. 
    
20. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
    
21. ------- ---- -- ---------- ----------- ------------ -------------------
    
22. 11      Incr 0  210.50M    SBT_TAPE    00:00:11     2018-05-23:19:52:15
    
23.         BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
    
24.         Handle: 0ct3ktj4_1_1   Media: station90-000008
    
25.   List of Datafiles in backup set 11
    
26.   Container ID: 3, PDB Name: PDB2
    
27.   File LV Type Ckp SCN    Ckp Time            Name
    
28.   ---- -- ---- ---------- ------------------- ----
    
29.   10   0  Incr 4293929    2018-05-23:19:52:04 /u01/app/oracle/oradata/cdb2/pdb2_1/system01.dbf
    
30.   12   0  Incr 4293929    2018-05-23:19:52:04 /u01/app/oracle/oradata/cdb2/pdb2_1/users01.dbf
    
31. 
    
32. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
    
33. ------- ---- -- ---------- ----------- ------------ -------------------
    
34. 18      Incr 0  210.50M    SBT_TAPE    00:00:10     2018-05-23:20:00:05
    
35.         BP Key: 18   Status: AVAILABLE  Compressed: NO  Tag: 2T_PLUG-PDB2_INCR0
    
36.         Handle: 0jt3ku1r_1_1   Media: station90-000007
    
37.   List of Datafiles in backup set 18
    
38.   Container ID: 3, PDB Name: PDB2
    
39.   File LV Type Ckp SCN    Ckp Time            Name
    
40.   ---- -- ---- ---------- ------------------- ----
    
41.   10   0  Incr 4294494    2018-05-23:19:59:55 /u01/app/oracle/oradata/cdb2/pdb2_1/system01.dbf
    
42.   12   0  Incr 4294494    2018-05-23:19:59:55 /u01/app/oracle/oradata/cdb2/pdb2_1/users01.dbf
    
43. 
    
44. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
    
45. ------- ---- -- ---------- ----------- ------------ -------------------
    
46. 19      Incr 0  465.75M    SBT_TAPE    00:00:20     2018-05-23:20:00:15
    
47.         BP Key: 19   Status: AVAILABLE  Compressed: NO  Tag: 2T_PLUG-PDB2_INCR0
    
48.         Handle: 0it3ku1r_1_1   Media: station90-000008
    
49.   List of Datafiles in backup set 19
    
50.   Container ID: 3, PDB Name: PDB2
    
51.   File LV Type Ckp SCN    Ckp Time            Name
    
52.   ---- -- ---- ---------- ------------------- ----
    
53.   11   0  Incr 4294492    2018-05-23:19:59:55 /u01/app/oracle/oradata/cdb2/pdb2_1/sysaux01.dbf
    
54.   30   0  Incr 4294492    2018-05-23:19:59:55 /u01/app/oracle/oradata/cdb2/pdb2_1/ldata_01.dbf
    
55. 
    
56. RMAN>
    

复制代码

也可更小范围备份和查看备份：

1. RMAN> list backup of tablespace pdb2:ldata;
   
2. 
   
3. 
   
4. List of Backup Sets
   
5. ===================
   
6. 
   
7. 
   
8. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
   
9. ------- ---- -- ---------- ----------- ------------ -------------------
   
10. 9       Incr 0  465.75M    SBT_TAPE    00:00:13     2018-05-23:19:51:50
    
11.         BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
    
12.         Handle: 09t3kti9_1_1   Media: station90-000007
    
13.   List of Datafiles in backup set 9
    
14.   File LV Type Ckp SCN    Ckp Time            Name
    
15.   ---- -- ---- ---------- ------------------- ----
    
16.   30   0  Incr 4293917    2018-05-23:19:51:37 /u01/app/oracle/oradata/cdb2/pdb2_1/ldata_01.dbf
    
17. 
    
18. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
    
19. ------- ---- -- ---------- ----------- ------------ -------------------
    
20. 19      Incr 0  465.75M    SBT_TAPE    00:00:20     2018-05-23:20:00:15
    
21.         BP Key: 19   Status: AVAILABLE  Compressed: NO  Tag: 2T_PLUG-PDB2_INCR0
    
22.         Handle: 0it3ku1r_1_1   Media: station90-000008
    
23.   List of Datafiles in backup set 19
    
24.   File LV Type Ckp SCN    Ckp Time            Name
    
25.   ---- -- ---- ---------- ------------------- ----
    
26.   30   0  Incr 4294492    2018-05-23:19:59:55 /u01/app/oracle/oradata/cdb2/pdb2_1/ldata_01.dbf
    

复制代码

1. RMAN> backup tag '3T_PDB2-LDATA_INCR0'  incremental level 0 tablespace pdb2:ldata;
   
2. 
   
3. Starting backup at 2018-05-23:20:06:49
   
4. using channel ORA_SBT_TAPE_1
   
5. using channel ORA_SBT_TAPE_2
   
6. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
   
7. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
   
8. input datafile file number=00030 name=/u01/app/oracle/oradata/cdb2/pdb2_1/ldata_01.dbf
   
9. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-05-23:20:06:49
   
10. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-05-23:20:07:14
    
11. piece handle=0mt3kuep_1_1 tag=3T_PDB2-LDATA_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
    
12. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
    
13. Finished backup at 2018-05-23:20:07:14
    
14. 
    
15. Starting Control File and SPFILE Autobackup at 2018-05-23:20:07:14
    
16. piece handle=c-723357305-20180523-02 comment=API Version 2.0,MMS Version 10.4.0.4
    
17. Finished Control File and SPFILE Autobackup at 2018-05-23:20:07:40
    
18. 
    
19. RMAN>
    

复制代码

如果做多租户AG的7-4实验，在12.1.0.2没有关闭CDB2的情况下，可能在recover tablespace pdb2:system之后，会遇到：


则这样解决：

1. RMAN> recover pluggable database pdb2;
   
2. 
   
3. Starting recover at 2018-05-23:20:59:41
   
4. using channel ORA_SBT_TAPE_1
   
5. using channel ORA_SBT_TAPE_2
   
6. using channel ORA_DISK_1
   
7. using channel ORA_DISK_2
   
8. using channel ORA_DISK_3
   
9. using channel ORA_DISK_4
   
10. using channel ORA_DISK_5
    
11. using channel ORA_DISK_6
    
12. using channel ORA_DISK_7
    
13. using channel ORA_DISK_8
    
14. 
    
15. starting media recovery
    
16. media recovery complete, elapsed time: 00:00:01
    
17. 
    
18. Finished recover at 2018-05-23:20:59:42
    
19. 
    
20. RMAN>
    

复制代码

在根容器本身上面，可以做传统意义的不完全恢复， 插件级别的恢复都是完全恢复。

多租户AG的7-5练习：

1. [oracle@station90 ~]$ rman target /
   
2. 
   
3. Recovery Manager: Release 12.1.0.2.0 - Production on Wed May 23 21:12:27 2018
   
4. 
   
5. Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: CDB2 (DBID=723357305)
   
8. 
   
9. RMAN> list failure all;
   
10. 
    
11. using target database control file instead of recovery catalog
    
12. Database Role: PRIMARY
    
13. 
    
14. List of Database Failures
    
15. =========================
    
16. 
    
17. Failure ID Priority Status    Time Detected       Summary
    
18. ---------- -------- --------- ------------------- -------
    
19. 842        HIGH     OPEN      2018-05-23:21:12:05 One or more non-system datafiles are missing
    
20. 465        HIGH     OPEN      2018-05-23:20:13:30 One or more non-system datafiles need media recovery
    
21. 
    
22. RMAN> advise failure all;
    
23. 
    
24. Database Role: PRIMARY
    
25. 
    
26. List of Database Failures
    
27. =========================
    
28. 
    
29. Failure ID Priority Status    Time Detected       Summary
    
30. ---------- -------- --------- ------------------- -------
    
31. 842        HIGH     OPEN      2018-05-23:21:12:05 One or more non-system datafiles are missing
    
32. 465        HIGH     OPEN      2018-05-23:20:13:30 One or more non-system datafiles need media recovery
    
33. 
    
34. analyzing automatic repair options; this may take some time
    
35. allocated channel: ORA_SBT_TAPE_1
    
36. channel ORA_SBT_TAPE_1: SID=7 device type=SBT_TAPE
    
37. channel ORA_SBT_TAPE_1: Oracle Secure Backup
    
38. allocated channel: ORA_SBT_TAPE_2
    
39. channel ORA_SBT_TAPE_2: SID=6 device type=SBT_TAPE
    
40. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
41. allocated channel: ORA_DISK_1
    
42. channel ORA_DISK_1: SID=633 device type=DISK
    
43. allocated channel: ORA_DISK_2
    
44. channel ORA_DISK_2: SID=926 device type=DISK
    
45. allocated channel: ORA_DISK_3
    
46. channel ORA_DISK_3: SID=13 device type=DISK
    
47. allocated channel: ORA_DISK_4
    
48. channel ORA_DISK_4: SID=316 device type=DISK
    
49. allocated channel: ORA_DISK_5
    
50. channel ORA_DISK_5: SID=919 device type=DISK
    
51. allocated channel: ORA_DISK_6
    
52. channel ORA_DISK_6: SID=8 device type=DISK
    
53. allocated channel: ORA_DISK_7
    
54. channel ORA_DISK_7: SID=312 device type=DISK
    
55. allocated channel: ORA_DISK_8
    
56. channel ORA_DISK_8: SID=636 device type=DISK
    
57. analyzing automatic repair options complete
    
58. 
    
59. Mandatory Manual Actions
    
60. ========================
    
61. no manual actions available
    
62. 
    
63. Optional Manual Actions
    
64. =======================
    
65. 1. If file /u01/app/oracle/oradata/cdb2/pdb2_1/ldata_01.dbf was unintentionally renamed or moved, restore it
    
66. 2. If you restored the wrong version of data file /u01/app/oracle/oradata/cdb2/pdb2_1/ldata_01.dbf, then replace it with the correct one
    
67. 
    
68. Automated Repair Options
    
69. ========================
    
70. Option Repair Description
    
71. ------ ------------------
    
72. 1      Restore and recover datafile 30  
    
73.   Strategy: The repair includes complete media recovery with no data loss
    
74.   Repair script: /u01/app/oracle/diag/rdbms/cdb2/cdb2/hm/reco_2092345284.hm
    
75. 
    
76. RMAN> repair failure preview;
    
77. 
    
78. Strategy: The repair includes complete media recovery with no data loss
    
79. Repair script: /u01/app/oracle/diag/rdbms/cdb2/cdb2/hm/reco_2092345284.hm
    
80. 
    
81. contents of repair script:
    
82.    # restore and recover datafile
    
83.    sql 'PDB2' 'alter database datafile 30 offline';
    
84.    restore ( datafile 30 );
    
85.    recover datafile 30;
    
86.    sql 'PDB2' 'alter database datafile 30 online';
    
87. 
    
88. RMAN> sql 'PDB2' 'alter database datafile 30 offline';
    
89. 
    
90. sql statement: alter database datafile 30 offline
    
91. 
    
92. RMAN>  restore  tablespace pdb2:ldata;
    
93. 
    
94. Starting restore at 2018-05-23:21:14:08
    
95. using channel ORA_SBT_TAPE_1
    
96. using channel ORA_SBT_TAPE_2
    
97. using channel ORA_DISK_1
    
98. using channel ORA_DISK_2
    
99. using channel ORA_DISK_3
    
100. using channel ORA_DISK_4
     
101. using channel ORA_DISK_5
     
102. using channel ORA_DISK_6
     
103. using channel ORA_DISK_7
     
104. using channel ORA_DISK_8
     
105. 
     
106. channel ORA_SBT_TAPE_1: starting datafile backup set restore
     
107. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
     
108. channel ORA_SBT_TAPE_1: restoring datafile 00030 to /u01/app/oracle/oradata/cdb2/pdb2_1/ldata_01.dbf
     
109. channel ORA_SBT_TAPE_1: reading from backup piece 0mt3kuep_1_1
     
110. channel ORA_SBT_TAPE_1: piece handle=0mt3kuep_1_1 tag=3T_PDB2-LDATA_INCR0
     
111. channel ORA_SBT_TAPE_1: restored backup piece 1
     
112. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:25
     
113. Finished restore at 2018-05-23:21:14:35
     
114. 
     
115. RMAN> recover tablespace pdb2:ldata;
     
116. 
     
117. Starting recover at 2018-05-23:21:14:45
     
118. using channel ORA_SBT_TAPE_1
     
119. using channel ORA_SBT_TAPE_2
     
120. using channel ORA_DISK_1
     
121. using channel ORA_DISK_2
     
122. using channel ORA_DISK_3
     
123. using channel ORA_DISK_4
     
124. using channel ORA_DISK_5
     
125. using channel ORA_DISK_6
     
126. using channel ORA_DISK_7
     
127. using channel ORA_DISK_8
     
128. 
     
129. starting media recovery
     
130. 
     
131. archived log for thread 1 with sequence 80 is already on disk as file /u01/app/oracle/fast_recovery_area/CDB2/archivelog/2018_05_23/o1_mf_1_80_fjbqmqns_.arc
     
132. archived log for thread 1 with sequence 81 is already on disk as file /u01/app/oracle/fast_recovery_area/CDB2/archivelog/2018_05_23/o1_mf_1_81_fjbqmr2s_.arc
     
133. archived log file name=/u01/app/oracle/fast_recovery_area/CDB2/archivelog/2018_05_23/o1_mf_1_80_fjbqmqns_.arc thread=1 sequence=80
     
134. archived log file name=/u01/app/oracle/fast_recovery_area/CDB2/archivelog/2018_05_23/o1_mf_1_81_fjbqmr2s_.arc thread=1 sequence=81
     
135. media recovery complete, elapsed time: 00:00:01
     
136. Finished recover at 2018-05-23:21:14:48
     
137. 
     
138. RMAN> sql 'PDB2' 'alter database datafile 30 online';
     
139. 
     
140. sql statement: alter database datafile 30 online
     
141. 
     
142. RMAN>
     

复制代码

PDB TSPITR和传统的TSPITR注意几点：
1.  时间格式export NLS_DATE_FORMAT="YYYY-MM-DD:HH24:MI:SS"。
2.  如果要恢复的对象在users表空间上：alter database default tablespace example。
3.  如果db_recovery_file_dest没有设置，设置成：alter system set db_recovery_file_dest='/u01/app/oracle/oradata'。
4.  对users表空间进行自包含集检查。并处理。  
5.  alter tablespace users offline;
6.

1. [oracle@station90 ~]$ date
   
2. 2018年 05月 24日 星期四 15:17:55 CST
   
3. [oracle@station90 ~]$ sqlplus /nolog
   
4. 
   
5. SQL*Plus: Release 11.2.0.3.0 Production on Thu May 24 15:19:35 2018
   
6. 
   
7. Copyright (c) 1982, 2011, Oracle.  All rights reserved.
   
8. 
   
9. SQL> conn / as sysdba
   
10. Connected.
    
11. SQL> alter database default tablespace example;
    
12. 
    
13. Database altered.
    
14. 
    
15. SQL> select  table_name from dba_tables where tablespace_name='USERS';
    
16. 
    
17. TABLE_NAME
    
18. ------------------------------
    
19. TTESTBOTANG_5
    
20. DEPT
    
21. EMP
    
22. BONUS
    
23. SALGRADE
    
24. PRODUCT_REF_LIST_NESTEDTAB
    
25. SUBCATEGORY_REF_LIST_NESTEDTAB
    
26. 
    
27. 7 rows selected.
    
28. 
    
29. SQL> select  owner,table_name from dba_tables where tablespace_name='USERS';
    
30. 
    
31. OWNER                               TABLE_NAME
    
32. ------------------------------ ------------------------------
    
33. SYS                               TTESTBOTANG_5
    
34. SCOTT                               DEPT
    
35. SCOTT                               EMP
    
36. SCOTT                               BONUS
    
37. SCOTT                               SALGRADE
    
38. OE                               PRODUCT_REF_LIST_NESTEDTAB
    
39. OE                               SUBCATEGORY_REF_LIST_NESTEDTAB
    
40. 
    
41. 7 rows selected.
    
42. 
    
43. SQL> alter table TTESTBOTANG_5  move tablespace system;
    
44. 
    
45. Table altered.
    
46. 
    
47. SQL> alter tablespace users offline ;
    
48. 
    
49. Tablespace altered.
    
50. 
    
51. SQL> exit
    
52. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    
53. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
    
54. and Real Application Testing options
    
55. [oracle@station90 ~]$ rman target /
    
56. 
    
57. Recovery Manager: Release 11.2.0.3.0 - Production on Thu May 24 15:22:53 2018
    
58. 
    
59. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
    
60. 
    
61. connected to target database: ORCL (DBID=1504656014)
    
62. 
    
63. RMAN> recover tablespace users
    
64. 2> until time '2018-05-24:15:19:02'
    
65. 3> AUXILIARY DESTINATION '/u01/app/oracle/oradata'
    
66. 4> ;
    
67. 
    
68. Starting recover at 2018-05-24:15:25:29
    
69. using target database control file instead of recovery catalog
    
70. allocated channel: ORA_DISK_1
    
71. channel ORA_DISK_1: SID=141 device type=DISK
    
72. RMAN-05026: WARNING: presuming following set of tablespaces applies to specified point-in-time
    
73. 
    
74. List of tablespaces expected to have UNDO segments
    
75. Tablespace SYSTEM
    
76. Tablespace UNDOTBS1
    
77. 
    
78. Creating automatic instance, with SID='jDzu'
    
79. 
    
80. initialization parameters used for automatic instance:
    
81. db_name=ORCL
    
82. db_unique_name=jDzu_tspitr_ORCL
    
83. compatible=11.2.0.0.0
    
84. db_block_size=8192
    
85. db_files=200
    
86. sga_target=280M
    
87. processes=50
    
88. db_create_file_dest=/u01/app/oracle/oradata
    
89. log_archive_dest_1='location=/u01/app/oracle/oradata'
    
90. #No auxiliary parameter file used
    
91. 
    
92. 
    
93. starting up automatic instance ORCL
    
94. 
    
95. Oracle instance started
    
96. 
    
97. Total System Global Area     292278272 bytes
    
98. 
    
99. Fixed Size                     2227744 bytes
    
100. Variable Size                100663776 bytes
     
101. Database Buffers             184549376 bytes
     
102. Redo Buffers                   4837376 bytes
     
103. Automatic instance created
     
104. Running TRANSPORT_SET_CHECK on recovery set tablespaces
     
105. TRANSPORT_SET_CHECK completed successfully
     
106. 
     
107. contents of Memory Script:
     
108. {
     
109. # set requested point in time
     
110. set until  time "2018-05-24:15:19:02";
     
111. # restore the controlfile
     
112. restore clone controlfile;
     
113. # mount the controlfile
     
114. sql clone 'alter database mount clone database';
     
115. # archive current online log
     
116. sql 'alter system archive log current';
     
117. # avoid unnecessary autobackups for structural changes during TSPITR
     
118. sql 'begin dbms_backup_restore.AutoBackupFlag(FALSE); end;';
     
119. }
     
120. executing Memory Script
     
121. 
     
122. executing command: SET until clause
     
123. 
     
124. Starting restore at 2018-05-24:15:26:07
     
125. allocated channel: ORA_AUX_DISK_1
     
126. channel ORA_AUX_DISK_1: SID=80 device type=DISK
     
127. 
     
128. channel ORA_AUX_DISK_1: starting datafile backup set restore
     
129. channel ORA_AUX_DISK_1: restoring control file
     
130. channel ORA_AUX_DISK_1: reading from backup piece +FRA/orcl/backupset/2018_05_24/ncsnf0_tag20180524t151653_0.363.976979831
     
131. channel ORA_AUX_DISK_1: piece handle=+FRA/orcl/backupset/2018_05_24/ncsnf0_tag20180524t151653_0.363.976979831 tag=TAG20180524T151653
     
132. channel ORA_AUX_DISK_1: restored backup piece 1
     
133. channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:05
     
134. output file name=/u01/app/oracle/oradata/ORCL/controlfile/o1_mf_fjdt8m66_.ctl
     
135. Finished restore at 2018-05-24:15:26:12
     
136. 
     
137. sql statement: alter database mount clone database
     
138. 
     
139. sql statement: alter system archive log current
     
140. 
     
141. sql statement: begin dbms_backup_restore.AutoBackupFlag(FALSE); end;
     
142. 
     
143. contents of Memory Script:
     
144. {
     
145. # set requested point in time
     
146. set until  time "2018-05-24:15:19:02";
     
147. # set destinations for recovery set and auxiliary set datafiles
     
148. set newname for clone datafile  1 to new;
     
149. set newname for clone datafile  3 to new;
     
150. set newname for clone datafile  2 to new;
     
151. set newname for clone tempfile  1 to new;
     
152. set newname for datafile  4 to
     
153. "+DATA/orcl/datafile/users.263.976875167";
     
154. # switch all tempfiles
     
155. switch clone tempfile all;
     
156. # restore the tablespaces in the recovery set and the auxiliary set
     
157. restore clone datafile  1, 3, 2, 4;
     
158. switch clone datafile all;
     
159. }
     
160. executing Memory Script
     
161. 
     
162. executing command: SET until clause
     
163. 
     
164. executing command: SET NEWNAME
     
165. 
     
166. executing command: SET NEWNAME
     
167. 
     
168. executing command: SET NEWNAME
     
169. 
     
170. executing command: SET NEWNAME
     
171. 
     
172. executing command: SET NEWNAME
     
173. 
     
174. renamed tempfile 1 to /u01/app/oracle/oradata/ORCL/datafile/o1_mf_temp_%u_.tmp in control file
     
175. 
     
176. Starting restore at 2018-05-24:15:26:17
     
177. using channel ORA_AUX_DISK_1
     
178. 
     
179. channel ORA_AUX_DISK_1: starting datafile backup set restore
     
180. channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
     
181. channel ORA_AUX_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_%u_.dbf
     
182. channel ORA_AUX_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_%u_.dbf
     
183. channel ORA_AUX_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_%u_.dbf
     
184. channel ORA_AUX_DISK_1: restoring datafile 00004 to +DATA/orcl/datafile/users.263.976875167
     
185. channel ORA_AUX_DISK_1: reading from backup piece +FRA/orcl/backupset/2018_05_24/nnndf0_tag20180524t151653_0.257.976979815
     
186. channel ORA_AUX_DISK_1: piece handle=+FRA/orcl/backupset/2018_05_24/nnndf0_tag20180524t151653_0.257.976979815 tag=TAG20180524T151653
     
187. channel ORA_AUX_DISK_1: restored backup piece 1
     
188. channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07
     
189. Finished restore at 2018-05-24:15:26:25
     
190. 
     
191. datafile 1 switched to datafile copy
     
192. input datafile copy RECID=5 STAMP=976980385 file name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_fjdt8t02_.dbf
     
193. datafile 3 switched to datafile copy
     
194. input datafile copy RECID=6 STAMP=976980385 file name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_fjdt8t11_.dbf
     
195. datafile 2 switched to datafile copy
     
196. input datafile copy RECID=7 STAMP=976980385 file name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_fjdt8t0k_.dbf
     
197. 
     
198. contents of Memory Script:
     
199. {
     
200. # set requested point in time
     
201. set until  time "2018-05-24:15:19:02";
     
202. # online the datafiles restored or switched
     
203. sql clone "alter database datafile  1 online";
     
204. sql clone "alter database datafile  3 online";
     
205. sql clone "alter database datafile  2 online";
     
206. sql clone "alter database datafile  4 online";
     
207. # recover and open resetlogs
     
208. recover clone database tablespace  "USERS", "SYSTEM", "UNDOTBS1", "SYSAUX" delete archivelog;
     
209. alter clone database open resetlogs;
     
210. }
     
211. executing Memory Script
     
212. 
     
213. executing command: SET until clause
     
214. 
     
215. sql statement: alter database datafile  1 online
     
216. 
     
217. sql statement: alter database datafile  3 online
     
218. 
     
219. sql statement: alter database datafile  2 online
     
220. 
     
221. sql statement: alter database datafile  4 online
     
222. 
     
223. Starting recover at 2018-05-24:15:26:25
     
224. using channel ORA_AUX_DISK_1
     
225. 
     
226. starting media recovery
     
227. 
     
228. archived log for thread 1 with sequence 5 is already on disk as file +FRA/orcl/archivelog/2018_05_24/thread_1_seq_5.362.976979937
     
229. archived log for thread 1 with sequence 6 is already on disk as file +FRA/orcl/archivelog/2018_05_24/thread_1_seq_6.361.976979937
     
230. archived log for thread 1 with sequence 7 is already on disk as file +FRA/orcl/archivelog/2018_05_24/thread_1_seq_7.360.976979947
     
231. archived log file name=+FRA/orcl/archivelog/2018_05_24/thread_1_seq_5.362.976979937 thread=1 sequence=5
     
232. archived log file name=+FRA/orcl/archivelog/2018_05_24/thread_1_seq_6.361.976979937 thread=1 sequence=6
     
233. archived log file name=+FRA/orcl/archivelog/2018_05_24/thread_1_seq_7.360.976979947 thread=1 sequence=7
     
234. media recovery complete, elapsed time: 00:00:01
     
235. Finished recover at 2018-05-24:15:26:28
     
236. 
     
237. database opened
     
238. 
     
239. contents of Memory Script:
     
240. {
     
241. # make read only the tablespace that will be exported
     
242. sql clone 'alter tablespace  USERS read only';
     
243. # create directory for datapump import
     
244. sql "create or replace directory TSPITR_DIROBJ_DPDIR as ''
     
245. /u01/app/oracle/oradata''";
     
246. # create directory for datapump export
     
247. sql clone "create or replace directory TSPITR_DIROBJ_DPDIR as ''
     
248. /u01/app/oracle/oradata''";
     
249. }
     
250. executing Memory Script
     
251. 
     
252. sql statement: alter tablespace  USERS read only
     
253. 
     
254. sql statement: create or replace directory TSPITR_DIROBJ_DPDIR as ''/u01/app/oracle/oradata''
     
255. 
     
256. sql statement: create or replace directory TSPITR_DIROBJ_DPDIR as ''/u01/app/oracle/oradata''
     
257. 
     
258. Performing export of metadata...
     
259.    EXPDP> Starting "SYS"."TSPITR_EXP_jDzu":  
     
260.    EXPDP> Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
     
261.    EXPDP> Processing object type TRANSPORTABLE_EXPORT/TYPE/TYPE_SPEC
     
262.    EXPDP> Processing object type TRANSPORTABLE_EXPORT/TYPE/TYPE_BODY
     
263.    EXPDP> Processing object type TRANSPORTABLE_EXPORT/XMLSCHEMA/XMLSCHEMA
     
264.    EXPDP> Processing object type TRANSPORTABLE_EXPORT/TABLE
     
265.    EXPDP> Processing object type TRANSPORTABLE_EXPORT/INDEX/INDEX
     
266.    EXPDP> Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/CONSTRAINT
     
267.    EXPDP> Processing object type TRANSPORTABLE_EXPORT/INDEX_STATISTICS
     
268.    EXPDP> Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/REF_CONSTRAINT
     
269.    EXPDP> Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
     
270.    EXPDP> Master table "SYS"."TSPITR_EXP_jDzu" successfully loaded/unloaded
     
271.    EXPDP> ******************************************************************************
     
272.    EXPDP> Dump file set for SYS.TSPITR_EXP_jDzu is:
     
273.    EXPDP>   /u01/app/oracle/oradata/tspitr_jDzu_44512.dmp
     
274.    EXPDP> ******************************************************************************
     
275.    EXPDP> Datafiles required for transportable tablespace USERS:
     
276.    EXPDP>   +DATA/orcl/datafile/users.263.976875167
     
277.    EXPDP> Job "SYS"."TSPITR_EXP_jDzu" successfully completed at 15:27:36
     
278. Export completed
     
279. 
     
280. 
     
281. contents of Memory Script:
     
282. {
     
283. # shutdown clone before import
     
284. shutdown clone immediate
     
285. # drop target tablespaces before importing them back
     
286. sql 'drop tablespace  USERS including contents keep datafiles';
     
287. }
     
288. executing Memory Script
     
289. 
     
290. database closed
     
291. database dismounted
     
292. Oracle instance shut down
     
293. 
     
294. sql statement: drop tablespace  USERS including contents keep datafiles
     
295. 
     
296. Performing import of metadata...
     
297.    IMPDP> Master table "SYS"."TSPITR_IMP_jDzu" successfully loaded/unloaded
     
298.    IMPDP> Starting "SYS"."TSPITR_IMP_jDzu":  
     
299.    IMPDP> Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
     
300.    IMPDP> Processing object type TRANSPORTABLE_EXPORT/TYPE/TYPE_SPEC
     
301.    IMPDP> ORA-31684: Object type TYPE:"OE"."SHIPPING_INSTRUCTIONS_T" already existsORA-31684: Object type TYPE:"OE"."REJECTION_T" already existsORA-31684: Object type TYPE:"OE"."ACTION_T" already existsORA-31684: Object type TYPE:"OE"."PART_T" already existsORA-31684: Object type TYPE:"OE"."PRODUCT_REF_LIST_TYP" already existsORA-31684: Object type TYPE:"OE"."CATEGORY_TYP" already existsORA-31684: Object type TYPE:"OE"."SUBCATEGORY_REF_LIST_TYP" already existsORA-31684: Object type TYPE:"OE"."ACTION_V" already existsORA-31684: Object type TYPE:"OE"."LINEITEM_T" already existsORA-31684: Object type TYPE:"OE"."LEAF_CATEGORY_TYP" already existsORA-31684: Object type TYPE:"OE"."COMPOSITE_CATEGORY_TYP" already existsORA-31684: Object type TYPE:"OE"."ACTIONS_T" already existsORA-31684: Object type TYPE:"OE"."LINEITEM_V" already existsORA-31684: Object type TYPE:"OE"."CATALOG_TYP" already existsORA-31684: Object type TYPE:"OE"."LINEITEMS_T" already existsORA-31684: Object type TYPE:"OE"."PURCHASEORDER_T" already exists
     
302.    IMPDP> Processing object type TRANSPORTABLE_EXPORT/TYPE/TYPE_BODY
     
303.    IMPDP> ORA-31684: Object type TYPE_BODY:"OE"."LEAF_CATEGORY_TYP" already existsORA-31684: Object type TYPE_BODY:"OE"."COMPOSITE_CATEGORY_TYP" already existsORA-31684: Object type TYPE_BODY:"OE"."CATALOG_TYP" already exists
     
304.    IMPDP> Processing object type TRANSPORTABLE_EXPORT/XMLSCHEMA/XMLSCHEMA
     
305.    IMPDP> ORA-39083: Object type XMLSCHEMA failed to create with error:
     
306. ORA-31085: schema "http://localhost:8080/source/schemas/poSource/xsd/purchaseOrder.xsd" already registered
     
307. Failing sql is:
     
308. BEGIN dbms_xmlschema.registerSchema(:1, :2, (:3 = 1), FALSE,FALSE,FALSE,FALSE, :4, options=> :5, schemaoid => :6, import_options => :7); END;
     
309.    IMPDP> Processing object type TRANSPORTABLE_EXPORT/TABLE
     
310.    IMPDP> ORA-39083: Object type TABLE:"OE"."PURCHASEORDER" failed to create with error:
     
311. ORA-31061: XDB error: DBMS_XDBZ.ENABLE_HIERARCHY
     
312. ORA-06512: at "XDB.DBMS_XDBZ0", line 131
     
313. ORA-06512: at "XDB.DBMS_XDBZ0", line 588
     
314. ORA-01031: insufficient privileges
     
315. Failing sql is:
     
316. BEGIN DBMS_XDBZ.ENABLE_HIERARCHY('"OE"','"PURCHASEORDER"'); END;
     
317.    IMPDP> Processing object type TRANSPORTABLE_EXPORT/INDEX/INDEX
     
318.    IMPDP> Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/CONSTRAINT
     
319.    IMPDP> Processing object type TRANSPORTABLE_EXPORT/INDEX_STATISTICS
     
320.    IMPDP> Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/REF_CONSTRAINT
     
321.    IMPDP> Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
     
322.    IMPDP> Job "SYS"."TSPITR_IMP_jDzu" completed with 21 error(s) at 15:28:05
     
323. Import completed
     
324. 
     
325. 
     
326. contents of Memory Script:
     
327. {
     
328. # make read write and offline the imported tablespaces
     
329. sql 'alter tablespace  USERS read write';
     
330. sql 'alter tablespace  USERS offline';
     
331. # enable autobackups after TSPITR is finished
     
332. sql 'begin dbms_backup_restore.AutoBackupFlag(TRUE); end;';
     
333. }
     
334. executing Memory Script
     
335. 
     
336. sql statement: alter tablespace  USERS read write
     
337. 
     
338. sql statement: alter tablespace  USERS offline
     
339. 
     
340. sql statement: begin dbms_backup_restore.AutoBackupFlag(TRUE); end;
     
341. 
     
342. Removing automatic instance
     
343. Automatic instance removed
     
344. auxiliary instance file /u01/app/oracle/oradata/ORCL/datafile/o1_mf_temp_fjdt97cq_.tmp deleted
     
345. auxiliary instance file /u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_3_fjdt963f_.log deleted
     
346. auxiliary instance file /u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_2_fjdt95n7_.log deleted
     
347. auxiliary instance file /u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_1_fjdt9547_.log deleted
     
348. auxiliary instance file /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_fjdt8t0k_.dbf deleted
     
349. auxiliary instance file /u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_fjdt8t11_.dbf deleted
     
350. auxiliary instance file /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_fjdt8t02_.dbf deleted
     
351. auxiliary instance file /u01/app/oracle/oradata/ORCL/controlfile/o1_mf_fjdt8m66_.ctl deleted
     
352. Finished recover at 2018-05-24:15:28:07
     
353. 
     
354. RMAN> exit
     
355. 
     
356. 
     
357. Recovery Manager complete.
     
358. [oracle@station90 ~]$ sqlplus /nolog
     
359. 
     
360. SQL*Plus: Release 11.2.0.3.0 Production on Thu May 24 15:32:45 2018
     
361. 
     
362. Copyright (c) 1982, 2011, Oracle.  All rights reserved.
     
363. 
     
364. SQL> conn / as sysdba
     
365. Connected.
     
366. SQL> alter tablespace users online;
     
367. 
     
368. Tablespace altered.
     
369. 
     
370. SQL> select* from hr.t126;
     
371. 
     
372.          A
     
373. ----------
     
374.          1
     
375. 
     
376. SQL>
     

复制代码