课程第19次（2018-07-23星期一)

botang

图形界面做Dataguard请务必验证一下：



在转换最大可用模式之前，必须验证通过：


主库和备库的属性都要改：


TSPITR：
做自包含集检查，并处理：

1. [oracle@station90 ~]$ sqlplus /nolog
   
2. 
   
3. SQL*Plus: Release 11.2.0.3.0 Production on Mon Jul 23 20:27:34 2018
   
4. 
   
5. Copyright (c) 1982, 2011, Oracle.  All rights reserved.
   
6. 
   
7. SQL> conn / as sysdba
   
8. Connected.
   
9. SQL> exec dbms_tts.transport_set_check('USERS') ;
   
10. 
    
11. PL/SQL procedure successfully completed.
    
12. 
    
13. SQL> set linesize 1000
    
14. SQL> select  * from transport_set_violations;
    
15. 
    
16. VIOLATIONS
    
17. ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    
18. ORA-39929: Table HR.FUNC_SPEC in tablespace USERS has encrypted columns which are not supported.
    
19. ORA-39929: Table HR.T_PIC in tablespace USERS has encrypted columns which are not supported.
    
20. ORA-39905: Table HR.SYS_LOB0000080641C00002$ in tablespace EXAMPLE points to LOB segment HR.T_PIC in tablespace USERS.
    
21. ORA-39905: Table HR.SYS_LOB0000080631C00002$ in tablespace EXAMPLE points to LOB segment HR.T_PIC1 in tablespace USERS.
    
22. 
    
23. SQL> alter table HR.FUNC_SPEC  move tablespace example;
    
24. 
    
25. Table altered.
    
26. 
    
27. SQL> alter table hr.T_PIC  move tablespace example;
    
28. 
    
29. Table altered.
    
30. 
    
31. SQL> exec dbms_tts.transport_set_check('USERS') ;
    
32. 
    
33. PL/SQL procedure successfully completed.
    
34. 
    
35. SQL> select  * from transport_set_violations;
    
36. 
    
37. VIOLATIONS
    
38. ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    
39. ORA-39907: Index HR.SYS_IL0000080644C00002$ in tablespace USERS points to table HR.FUNC_SPEC in tablespace EXAMPLE.
    
40. ORA-39905: Table HR.FUNC_SPEC in tablespace EXAMPLE points to LOB segment HR.SYS_LOB0000080644C00002$ in tablespace USERS.
    
41. ORA-39905: Table HR.SYS_LOB0000080631C00002$ in tablespace EXAMPLE points to LOB segment HR.T_PIC1 in tablespace USERS.
    
42. 
    
43. SQL> alter table HR.FUNC_SPEC  move tablespace example;
    
44. 
    
45. Table altered.
    
46. 
    
47. SQL> exec dbms_tts.transport_set_check('USERS') ;
    
48. 
    
49. PL/SQL procedure successfully completed.
    
50. 
    
51. SQL> select  * from transport_set_violations;
    
52. 
    
53. VIOLATIONS
    
54. ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    
55. ORA-39907: Index HR.SYS_IL0000080644C00002$ in tablespace USERS points to table HR.FUNC_SPEC in tablespace EXAMPLE.
    
56. ORA-39905: Table HR.FUNC_SPEC in tablespace EXAMPLE points to LOB segment HR.SYS_LOB0000080644C00002$ in tablespace USERS.
    
57. ORA-39905: Table HR.SYS_LOB0000080631C00002$ in tablespace EXAMPLE points to LOB segment HR.T_PIC1 in tablespace USERS.
    
58. 
    
59. 
    
60. SQL> alter table HR.FUNC_SPEC   move    lob (doc )  store as  ( tablespace example)   ;
    
61. alter table HR.FUNC_SPEC   move    lob (doc )  store as  ( tablespace example)
    
62.                *
    
63. ERROR at line 1:
    
64. ORA-28365: wallet is not open
    
65. 
    
66. 
    
67. SQL> alter system set encryption wallet open identified by "oracle123";
    
68. 
    
69. System altered.
    
70. 
    
71. SQL> alter table HR.FUNC_SPEC   move    lob (doc )  store as  ( tablespace example)   ;
    
72. 
    
73. Table altered.
    
74. 
    
75. SQL> exec dbms_tts.transport_set_check('USERS') ;
    
76. 
    
77. PL/SQL procedure successfully completed.
    
78. 
    
79. SQL> select  * from transport_set_violations;
    
80. 
    
81. VIOLATIONS
    
82. ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    
83. ORA-39905: Table HR.SYS_LOB0000080631C00002$ in tablespace EXAMPLE points to LOB segment HR.T_PIC1 in tablespace USERS.
    
84. 
    
85. SQL> alter table  HR.T_PIC1   move lob (pic)   store as  ( tablespace example)   ;
    
86. 
    
87. Table altered.
    
88. 
    
89. SQL> exec dbms_tts.transport_set_check('USERS') ;
    
90. 
    
91. PL/SQL procedure successfully completed.
    
92. 
    
93. SQL> select  * from transport_set_violations;
    
94. 
    
95. VIOLATIONS
    
96. ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    
97. ORA-39905: Table HR.SYS_LOB0000080631C00002$ in tablespace EXAMPLE points to LOB segment HR.T_PIC1 in tablespace USERS.
    
98. 
    
99. SQL> alter table HR.T_PIC1 move tablespace example;
    
100. 
     
101. Table altered.
     
102. 
     
103. SQL> exec dbms_tts.transport_set_check('USERS') ;
     
104. 
     
105. PL/SQL procedure successfully completed.
     
106. 
     
107. SQL> select  * from transport_set_violations;
     
108. 
     
109. no rows selected
     
110. 
     
111. SQL>
     
112. SQL> alter database default tablespace example;
     
113. 
     
114. Database altered.
     
115. 
     
116. SQL> select table_name  , owner from dba_Tables where tablespace_name='USERS';
     
117. 
     
118. TABLE_NAME                       OWNER
     
119. ------------------------------ ------------------------------
     
120. TTESTBOTANG_5                       SYS
     
121. DEPT                               SCOTT
     
122. EMP                               SCOTT
     
123. BONUS                               SCOTT
     
124. SALGRADE                       SCOTT
     
125. MLOG$_TAB1                       HR
     
126. T24351                               HR
     
127. PRODUCT_REF_LIST_NESTEDTAB     OE
     
128. SUBCATEGORY_REF_LIST_NESTEDTAB OE
     
129. DIMENSION_EXCEPTIONS               SH
     
130. 
     
131. 10 rows selected.
     
132. 
     
133. SQL> alter table SYS.TTESTBOTANG_5  move tablespace system ;
     
134. 
     
135. Table altered.
     
136. 
     
137. SQL> select table_name  , owner from dba_Tables where tablespace_name='USERS';
     
138. 
     
139. TABLE_NAME                       OWNER
     
140. ------------------------------ ------------------------------
     
141. DEPT                               SCOTT
     
142. EMP                               SCOTT
     
143. BONUS                               SCOTT
     
144. SALGRADE                       SCOTT
     
145. MLOG$_TAB1                       HR
     
146. T24351                               HR
     
147. PRODUCT_REF_LIST_NESTEDTAB     OE
     
148. SUBCATEGORY_REF_LIST_NESTEDTAB OE
     
149. DIMENSION_EXCEPTIONS               SH
     
150. 
     
151. 9 rows selected.
     
152. 
     
153. SQL>
     

复制代码

查询物化视图：

1. select * from dba_mviews  mv
   
2. where mv.MVIEW_NAME in (
   
3. select s.segment_name from dba_segments s
   
4. where  s.tablespace_name='USERS'
   
5. );

复制代码

1. drop materialized view log on  hr.TAB1;

复制代码

自动克隆了一个实例：

1. [root@station90 ~]# ps aux | grep ora_smon
   
2. oracle   15057  0.0  0.2 523720 40584 ?        Ss   20:43   0:00 ora_smon_Agrx
   
3. root     15352  0.0  0.0 103308  2032 pts/11   S+   20:45   0:00 grep ora_smon
   
4. oracle   27168  0.0  1.2 6795216 200232 ?      Ss   20:11   0:00 ora_smon_orcl
   

复制代码

TSPITR：

1. [oracle@station90 ~]$ export NLS_DATE_FORMAT='YYYY-MM-DD:HH24:MI:SS'
   
2. [oracle@station90 ~]$ rman target /
   
3. 
   
4. Recovery Manager: Release 11.2.0.3.0 - Production on Mon Jul 23 21:44:23 2018
   
5. 
   
6. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
   
7. 
   
8. connected to target database: ORCL (DBID=1343950367)
   
9. 
   
10. RMAN> recover tablespace users
    
11. 2> until time '2018-07-23:21:43:18'
    
12. 3> auxiliary destination '/u01/app/oracle/oradata';
    
13. 
    
14. Starting recover at 2018-07-23:21:45:03
    
15. using target database control file instead of recovery catalog
    
16. allocated channel: ORA_DISK_1
    
17. channel ORA_DISK_1: SID=78 device type=DISK
    
18. allocated channel: ORA_DISK_2
    
19. channel ORA_DISK_2: SID=9 device type=DISK
    
20. allocated channel: ORA_DISK_3
    
21. channel ORA_DISK_3: SID=76 device type=DISK
    
22. allocated channel: ORA_DISK_4
    
23. channel ORA_DISK_4: SID=143 device type=DISK
    
24. allocated channel: ORA_DISK_5
    
25. channel ORA_DISK_5: SID=202 device type=DISK
    
26. allocated channel: ORA_DISK_6
    
27. channel ORA_DISK_6: SID=11 device type=DISK
    
28. allocated channel: ORA_DISK_7
    
29. channel ORA_DISK_7: SID=73 device type=DISK
    
30. allocated channel: ORA_DISK_8
    
31. channel ORA_DISK_8: SID=14 device type=DISK
    
32. allocated channel: ORA_SBT_TAPE_1
    
33. channel ORA_SBT_TAPE_1: SID=71 device type=SBT_TAPE
    
34. channel ORA_SBT_TAPE_1: Oracle Secure Backup
    
35. allocated channel: ORA_SBT_TAPE_2
    
36. channel ORA_SBT_TAPE_2: SID=75 device type=SBT_TAPE
    
37. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
38. RMAN-05026: WARNING: presuming following set of tablespaces applies to specified point-in-time
    
39. 
    
40. List of tablespaces expected to have UNDO segments
    
41. Tablespace SYSTEM
    
42. Tablespace UNDOTBS1
    
43. 
    
44. Creating automatic instance, with SID='BcBD'
    
45. 
    
46. initialization parameters used for automatic instance:
    
47. db_name=ORCL
    
48. db_unique_name=BcBD_tspitr_ORCL
    
49. compatible=11.2.0.0.0
    
50. db_block_size=8192
    
51. db_files=200
    
52. sga_target=280M
    
53. processes=50
    
54. db_create_file_dest=/u01/app/oracle/oradata
    
55. log_archive_dest_1='location=/u01/app/oracle/oradata'
    
56. #No auxiliary parameter file used
    
57. 
    
58. 
    
59. starting up automatic instance ORCL
    
60. 
    
61. Oracle instance started
    
62. 
    
63. Total System Global Area     292278272 bytes
    
64. 
    
65. Fixed Size                     2227744 bytes
    
66. Variable Size                100663776 bytes
    
67. Database Buffers             184549376 bytes
    
68. Redo Buffers                   4837376 bytes
    
69. Automatic instance created
    
70. Running TRANSPORT_SET_CHECK on recovery set tablespaces
    
71. TRANSPORT_SET_CHECK completed successfully
    
72. 
    
73. contents of Memory Script:
    
74. {
    
75. # set requested point in time
    
76. set until  time "2018-07-23:21:43:18";
    
77. # restore the controlfile
    
78. restore clone controlfile;
    
79. # mount the controlfile
    
80. sql clone 'alter database mount clone database';
    
81. # archive current online log
    
82. sql 'alter system archive log current';
    
83. # avoid unnecessary autobackups for structural changes during TSPITR
    
84. sql 'begin dbms_backup_restore.AutoBackupFlag(FALSE); end;';
    
85. }
    
86. executing Memory Script
    
87. 
    
88. executing command: SET until clause
    
89. 
    
90. Starting restore at 2018-07-23:21:45:50
    
91. allocated channel: ORA_AUX_DISK_1
    
92. channel ORA_AUX_DISK_1: SID=80 device type=DISK
    
93. allocated channel: ORA_AUX_DISK_2
    
94. channel ORA_AUX_DISK_2: SID=5 device type=DISK
    
95. allocated channel: ORA_AUX_DISK_3
    
96. channel ORA_AUX_DISK_3: SID=30 device type=DISK
    
97. allocated channel: ORA_AUX_DISK_4
    
98. channel ORA_AUX_DISK_4: SID=56 device type=DISK
    
99. allocated channel: ORA_AUX_DISK_5
    
100. channel ORA_AUX_DISK_5: SID=81 device type=DISK
     
101. allocated channel: ORA_AUX_DISK_6
     
102. channel ORA_AUX_DISK_6: SID=6 device type=DISK
     
103. allocated channel: ORA_AUX_DISK_7
     
104. channel ORA_AUX_DISK_7: SID=31 device type=DISK
     
105. allocated channel: ORA_AUX_DISK_8
     
106. channel ORA_AUX_DISK_8: SID=57 device type=DISK
     
107. allocated channel: ORA_AUX_SBT_TAPE_1
     
108. channel ORA_AUX_SBT_TAPE_1: SID=82 device type=SBT_TAPE
     
109. channel ORA_AUX_SBT_TAPE_1: Oracle Secure Backup
     
110. allocated channel: ORA_AUX_SBT_TAPE_2
     
111. channel ORA_AUX_SBT_TAPE_2: SID=7 device type=SBT_TAPE
     
112. channel ORA_AUX_SBT_TAPE_2: Oracle Secure Backup
     
113. 
     
114. channel ORA_AUX_DISK_1: starting datafile backup set restore
     
115. channel ORA_AUX_DISK_1: restoring control file
     
116. channel ORA_AUX_DISK_1: reading from backup piece +FRA/orcl/autobackup/2018_07_23/s_982272726.326.982272727
     
117. channel ORA_AUX_DISK_1: piece handle=+FRA/orcl/autobackup/2018_07_23/s_982272726.326.982272727 tag=TAG20180723T213205
     
118. channel ORA_AUX_DISK_1: restored backup piece 1
     
119. channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
     
120. output file name=/u01/app/oracle/oradata/ORCL/controlfile/o1_mf_focq0r3q_.ctl
     
121. Finished restore at 2018-07-23:21:46:00
     
122. 
     
123. sql statement: alter database mount clone database
     
124. 
     
125. sql statement: alter system archive log current
     
126. 
     
127. sql statement: begin dbms_backup_restore.AutoBackupFlag(FALSE); end;
     
128. 
     
129. contents of Memory Script:
     
130. {
     
131. # set requested point in time
     
132. set until  time "2018-07-23:21:43:18";
     
133. plsql <<<-- tspitr_2
     
134. declare
     
135.   sqlstatement       varchar2(512);
     
136.   offline_not_needed exception;
     
137.   pragma exception_init(offline_not_needed, -01539);
     
138. begin
     
139.   sqlstatement := 'alter tablespace '||  'USERS' ||' offline immediate';
     
140.   krmicd.writeMsg(6162, sqlstatement);
     
141.   krmicd.execSql(sqlstatement);
     
142. exception
     
143.   when offline_not_needed then
     
144.     null;
     
145. end; >>>;
     
146. # set destinations for recovery set and auxiliary set datafiles
     
147. set newname for clone datafile  1 to new;
     
148. set newname for clone datafile  3 to new;
     
149. set newname for clone datafile  2 to new;
     
150. set newname for clone tempfile  1 to new;
     
151. set newname for datafile  4 to
     
152. "+DATA/orcl/datafile/users.259.816169553";
     
153. # switch all tempfiles
     
154. switch clone tempfile all;
     
155. # restore the tablespaces in the recovery set and the auxiliary set
     
156. restore clone datafile  1, 3, 2, 4;
     
157. switch clone datafile all;
     
158. }
     
159. executing Memory Script
     
160. 
     
161. executing command: SET until clause
     
162. 
     
163. sql statement: alter tablespace USERS offline immediate
     
164. 
     
165. executing command: SET NEWNAME
     
166. 
     
167. executing command: SET NEWNAME
     
168. 
     
169. executing command: SET NEWNAME
     
170. 
     
171. executing command: SET NEWNAME
     
172. 
     
173. executing command: SET NEWNAME
     
174. 
     
175. renamed tempfile 1 to /u01/app/oracle/oradata/ORCL/datafile/o1_mf_temp_%u_.tmp in control file
     
176. 
     
177. Starting restore at 2018-07-23:21:46:06
     
178. using channel ORA_AUX_DISK_1
     
179. using channel ORA_AUX_DISK_2
     
180. using channel ORA_AUX_DISK_3
     
181. using channel ORA_AUX_DISK_4
     
182. using channel ORA_AUX_DISK_5
     
183. using channel ORA_AUX_DISK_6
     
184. using channel ORA_AUX_DISK_7
     
185. using channel ORA_AUX_DISK_8
     
186. using channel ORA_AUX_SBT_TAPE_1
     
187. using channel ORA_AUX_SBT_TAPE_2
     
188. 
     
189. channel ORA_AUX_SBT_TAPE_1: starting datafile backup set restore
     
190. channel ORA_AUX_SBT_TAPE_1: specifying datafile(s) to restore from backup set
     
191. channel ORA_AUX_SBT_TAPE_1: restoring datafile 00001 to /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_%u_.dbf
     
192. channel ORA_AUX_SBT_TAPE_1: reading from backup piece 1rt88jb3_1_1
     
193. channel ORA_AUX_SBT_TAPE_2: starting datafile backup set restore
     
194. channel ORA_AUX_SBT_TAPE_2: specifying datafile(s) to restore from backup set
     
195. channel ORA_AUX_SBT_TAPE_2: restoring datafile 00003 to /u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_%u_.dbf
     
196. channel ORA_AUX_SBT_TAPE_2: restoring datafile 00002 to /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_%u_.dbf
     
197. channel ORA_AUX_SBT_TAPE_2: restoring datafile 00004 to +DATA/orcl/datafile/users.259.816169553
     
198. channel ORA_AUX_SBT_TAPE_2: reading from backup piece 1qt88jb3_1_1
     
199. channel ORA_AUX_SBT_TAPE_1: piece handle=1rt88jb3_1_1 tag=100T_WHOLE_FULL
     
200. channel ORA_AUX_SBT_TAPE_1: restored backup piece 1
     
201. channel ORA_AUX_SBT_TAPE_1: restore complete, elapsed time: 00:00:35
     
202. channel ORA_AUX_SBT_TAPE_2: piece handle=1qt88jb3_1_1 tag=100T_WHOLE_FULL
     
203. channel ORA_AUX_SBT_TAPE_2: restored backup piece 1
     
204. channel ORA_AUX_SBT_TAPE_2: restore complete, elapsed time: 00:00:35
     
205. Finished restore at 2018-07-23:21:46:42
     
206. 
     
207. datafile 1 switched to datafile copy
     
208. input datafile copy RECID=8 STAMP=982273603 file name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_focq1l57_.dbf
     
209. datafile 3 switched to datafile copy
     
210. input datafile copy RECID=9 STAMP=982273603 file name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_focq1q5x_.dbf
     
211. datafile 2 switched to datafile copy
     
212. input datafile copy RECID=10 STAMP=982273603 file name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_focq1q59_.dbf
     
213. 
     
214. contents of Memory Script:
     
215. {
     
216. # set requested point in time
     
217. set until  time "2018-07-23:21:43:18";
     
218. # online the datafiles restored or switched
     
219. sql clone "alter database datafile  1 online";
     
220. sql clone "alter database datafile  3 online";
     
221. sql clone "alter database datafile  2 online";
     
222. sql clone "alter database datafile  4 online";
     
223. # recover and open resetlogs
     
224. recover clone database tablespace  "USERS", "SYSTEM", "UNDOTBS1", "SYSAUX" delete archivelog;
     
225. alter clone database open resetlogs;
     
226. }
     
227. executing Memory Script
     
228. 
     
229. executing command: SET until clause
     
230. 
     
231. sql statement: alter database datafile  1 online
     
232. 
     
233. sql statement: alter database datafile  3 online
     
234. 
     
235. sql statement: alter database datafile  2 online
     
236. 
     
237. sql statement: alter database datafile  4 online
     
238. 
     
239. Starting recover at 2018-07-23:21:46:43
     
240. using channel ORA_AUX_DISK_1
     
241. using channel ORA_AUX_DISK_2
     
242. using channel ORA_AUX_DISK_3
     
243. using channel ORA_AUX_DISK_4
     
244. using channel ORA_AUX_DISK_5
     
245. using channel ORA_AUX_DISK_6
     
246. using channel ORA_AUX_DISK_7
     
247. using channel ORA_AUX_DISK_8
     
248. using channel ORA_AUX_SBT_TAPE_1
     
249. using channel ORA_AUX_SBT_TAPE_2
     
250. 
     
251. starting media recovery
     
252. 
     
253. archived log for thread 1 with sequence 160 is already on disk as file +FRA/orcl/archivelog/2018_07_17/thread_1_seq_160.283.981749477
     
254. archived log for thread 1 with sequence 161 is already on disk as file +FRA/orcl/archivelog/2018_07_17/thread_1_seq_161.284.981749479
     
255. archived log for thread 1 with sequence 162 is already on disk as file +FRA/orcl/archivelog/2018_07_17/thread_1_seq_162.285.981749481
     
256. archived log for thread 1 with sequence 163 is already on disk as file +FRA/orcl/archivelog/2018_07_17/thread_1_seq_163.286.981749481
     
257. archived log for thread 1 with sequence 164 is already on disk as file +FRA/orcl/archivelog/2018_07_17/thread_1_seq_164.287.981749483
     
258. archived log for thread 1 with sequence 165 is already on disk as file +FRA/orcl/archivelog/2018_07_17/thread_1_seq_165.288.981749485
     
259. archived log for thread 1 with sequence 1 is already on disk as file +FRA/orcl/archivelog/2018_07_19/thread_1_seq_1.292.981927643
     
260. archived log for thread 1 with sequence 2 is already on disk as file +FRA/orcl/archivelog/2018_07_22/thread_1_seq_2.293.982145289
     
261. archived log for thread 1 with sequence 3 is already on disk as file +FRA/orcl/archivelog/2018_07_22/thread_1_seq_3.294.982145393
     
262. archived log for thread 1 with sequence 4 is already on disk as file +FRA/orcl/archivelog/2018_07_22/thread_1_seq_4.295.982159249
     
263. archived log for thread 1 with sequence 5 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_5.296.982267971
     
264. archived log for thread 1 with sequence 6 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_6.297.982268257
     
265. archived log for thread 1 with sequence 7 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_7.298.982268257
     
266. archived log for thread 1 with sequence 8 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_8.299.982268269
     
267. archived log for thread 1 with sequence 9 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_9.300.982268269
     
268. archived log for thread 1 with sequence 10 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_10.301.982268271
     
269. archived log for thread 1 with sequence 11 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_11.302.982268275
     
270. archived log for thread 1 with sequence 12 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_12.303.982269845
     
271. archived log for thread 1 with sequence 13 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_13.304.982270181
     
272. archived log for thread 1 with sequence 14 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_14.305.982270719
     
273. archived log for thread 1 with sequence 15 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_15.306.982270721
     
274. archived log for thread 1 with sequence 16 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_16.307.982270729
     
275. archived log for thread 1 with sequence 17 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_17.308.982270729
     
276. archived log for thread 1 with sequence 18 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_18.309.982270729
     
277. archived log for thread 1 with sequence 19 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_19.310.982270731
     
278. archived log for thread 1 with sequence 20 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_20.311.982270909
     
279. archived log for thread 1 with sequence 21 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_21.313.982272133
     
280. archived log for thread 1 with sequence 22 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_22.314.982272133
     
281. archived log for thread 1 with sequence 23 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_23.315.982272145
     
282. archived log for thread 1 with sequence 24 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_24.316.982272151
     
283. archived log for thread 1 with sequence 25 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_25.317.982272151
     
284. archived log for thread 1 with sequence 26 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_26.318.982272153
     
285. archived log for thread 1 with sequence 27 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_27.319.982272459
     
286. archived log for thread 1 with sequence 28 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_28.320.982272459
     
287. archived log for thread 1 with sequence 29 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_29.321.982272469
     
288. archived log for thread 1 with sequence 30 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_30.322.982272473
     
289. archived log for thread 1 with sequence 31 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_31.323.982272473
     
290. archived log for thread 1 with sequence 32 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_32.324.982272475
     
291. archived log for thread 1 with sequence 33 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_33.325.982272615
     
292. archived log for thread 1 with sequence 34 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_34.327.982273393
     
293. archived log for thread 1 with sequence 35 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_35.328.982273393
     
294. archived log for thread 1 with sequence 36 is already on disk as file +FRA/orcl/archivelog/2018_07_23/thread_1_seq_36.333.982273403
     
295. channel ORA_AUX_SBT_TAPE_1: starting archived log restore to default destination
     
296. channel ORA_AUX_SBT_TAPE_1: restoring archived log
     
297. archived log thread=1 sequence=159
     
298. channel ORA_AUX_SBT_TAPE_1: reading from backup piece 1st88jbu_1_1
     
299. channel ORA_AUX_SBT_TAPE_1: piece handle=1st88jbu_1_1 tag=100T_WHOLE_FULL
     
300. channel ORA_AUX_SBT_TAPE_1: restored backup piece 1
     
301. channel ORA_AUX_SBT_TAPE_1: restore complete, elapsed time: 00:00:22
     
302. archived log file name=/u01/app/oracle/oradata/1_159_816169635.dbf thread=1 sequence=159
     
303. channel clone_default: deleting archived log(s)
     
304. archived log file name=/u01/app/oracle/oradata/1_159_816169635.dbf RECID=194 STAMP=982273621
     
305. archived log file name=+FRA/orcl/archivelog/2018_07_17/thread_1_seq_160.283.981749477 thread=1 sequence=160
     
306. archived log file name=+FRA/orcl/archivelog/2018_07_17/thread_1_seq_161.284.981749479 thread=1 sequence=161
     
307. archived log file name=+FRA/orcl/archivelog/2018_07_17/thread_1_seq_162.285.981749481 thread=1 sequence=162
     
308. archived log file name=+FRA/orcl/archivelog/2018_07_17/thread_1_seq_163.286.981749481 thread=1 sequence=163
     
309. archived log file name=+FRA/orcl/archivelog/2018_07_17/thread_1_seq_164.287.981749483 thread=1 sequence=164
     
310. archived log file name=+FRA/orcl/archivelog/2018_07_17/thread_1_seq_165.288.981749485 thread=1 sequence=165
     
311. archived log file name=+FRA/orcl/archivelog/2018_07_19/thread_1_seq_1.292.981927643 thread=1 sequence=1
     
312. archived log file name=+FRA/orcl/archivelog/2018_07_22/thread_1_seq_2.293.982145289 thread=1 sequence=2
     
313. archived log file name=+FRA/orcl/archivelog/2018_07_22/thread_1_seq_3.294.982145393 thread=1 sequence=3
     
314. archived log file name=+FRA/orcl/archivelog/2018_07_22/thread_1_seq_4.295.982159249 thread=1 sequence=4
     
315. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_5.296.982267971 thread=1 sequence=5
     
316. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_6.297.982268257 thread=1 sequence=6
     
317. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_7.298.982268257 thread=1 sequence=7
     
318. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_8.299.982268269 thread=1 sequence=8
     
319. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_9.300.982268269 thread=1 sequence=9
     
320. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_10.301.982268271 thread=1 sequence=10
     
321. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_11.302.982268275 thread=1 sequence=11
     
322. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_12.303.982269845 thread=1 sequence=12
     
323. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_13.304.982270181 thread=1 sequence=13
     
324. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_14.305.982270719 thread=1 sequence=14
     
325. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_15.306.982270721 thread=1 sequence=15
     
326. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_16.307.982270729 thread=1 sequence=16
     
327. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_17.308.982270729 thread=1 sequence=17
     
328. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_18.309.982270729 thread=1 sequence=18
     
329. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_19.310.982270731 thread=1 sequence=19
     
330. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_20.311.982270909 thread=1 sequence=20
     
331. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_21.313.982272133 thread=1 sequence=21
     
332. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_22.314.982272133 thread=1 sequence=22
     
333. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_23.315.982272145 thread=1 sequence=23
     
334. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_24.316.982272151 thread=1 sequence=24
     
335. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_25.317.982272151 thread=1 sequence=25
     
336. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_26.318.982272153 thread=1 sequence=26
     
337. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_27.319.982272459 thread=1 sequence=27
     
338. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_28.320.982272459 thread=1 sequence=28
     
339. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_29.321.982272469 thread=1 sequence=29
     
340. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_30.322.982272473 thread=1 sequence=30
     
341. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_31.323.982272473 thread=1 sequence=31
     
342. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_32.324.982272475 thread=1 sequence=32
     
343. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_33.325.982272615 thread=1 sequence=33
     
344. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_34.327.982273393 thread=1 sequence=34
     
345. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_35.328.982273393 thread=1 sequence=35
     
346. archived log file name=+FRA/orcl/archivelog/2018_07_23/thread_1_seq_36.333.982273403 thread=1 sequence=36
     
347. media recovery complete, elapsed time: 00:01:09
     
348. Finished recover at 2018-07-23:21:48:17
     
349. 
     
350. database opened
     
351. 
     
352. contents of Memory Script:
     
353. {
     
354. # make read only the tablespace that will be exported
     
355. sql clone 'alter tablespace  USERS read only';
     
356. # create directory for datapump import
     
357. sql "create or replace directory TSPITR_DIROBJ_DPDIR as ''
     
358. /u01/app/oracle/oradata''";
     
359. # create directory for datapump export
     
360. sql clone "create or replace directory TSPITR_DIROBJ_DPDIR as ''
     
361. /u01/app/oracle/oradata''";
     
362. }
     
363. executing Memory Script
     
364. 
     
365. sql statement: alter tablespace  USERS read only
     
366. 
     
367. sql statement: create or replace directory TSPITR_DIROBJ_DPDIR as ''/u01/app/oracle/oradata''
     
368. 
     
369. sql statement: create or replace directory TSPITR_DIROBJ_DPDIR as ''/u01/app/oracle/oradata''
     
370. 
     
371. Performing export of metadata...
     
372.    EXPDP> Starting "SYS"."TSPITR_EXP_BcBD":  
     
373.    EXPDP> Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
     
374.    EXPDP> Processing object type TRANSPORTABLE_EXPORT/TYPE/TYPE_SPEC
     
375.    EXPDP> Processing object type TRANSPORTABLE_EXPORT/TYPE/TYPE_BODY
     
376.    EXPDP> Processing object type TRANSPORTABLE_EXPORT/XMLSCHEMA/XMLSCHEMA
     
377.    EXPDP> Processing object type TRANSPORTABLE_EXPORT/TABLE
     
378.    EXPDP> Processing object type TRANSPORTABLE_EXPORT/INDEX/INDEX
     
379.    EXPDP> Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/CONSTRAINT
     
380.    EXPDP> Processing object type TRANSPORTABLE_EXPORT/INDEX_STATISTICS
     
381.    EXPDP> Processing object type TRANSPORTABLE_EXPORT/COMMENT
     
382.    EXPDP> Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/REF_CONSTRAINT
     
383.    EXPDP> Processing object type TRANSPORTABLE_EXPORT/TABLE_STATISTICS
     
384.    EXPDP> Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
     
385.    EXPDP> Master table "SYS"."TSPITR_EXP_BcBD" successfully loaded/unloaded
     
386.    EXPDP> ******************************************************************************
     
387.    EXPDP> Dump file set for SYS.TSPITR_EXP_BcBD is:
     
388.    EXPDP>   /u01/app/oracle/oradata/tspitr_BcBD_77380.dmp
     
389.    EXPDP> ******************************************************************************
     
390.    EXPDP> Datafiles required for transportable tablespace USERS:
     
391.    EXPDP>   +DATA/orcl/datafile/users.259.816169553
     
392.    EXPDP> Job "SYS"."TSPITR_EXP_BcBD" successfully completed at 21:49:21
     
393. Export completed
     
394. 
     
395. 
     
396. contents of Memory Script:
     
397. {
     
398. # shutdown clone before import
     
399. shutdown clone immediate
     
400. # drop target tablespaces before importing them back
     
401. sql 'drop tablespace  USERS including contents keep datafiles';
     
402. }
     
403. executing Memory Script
     
404. 
     
405. database closed
     
406. database dismounted
     
407. Oracle instance shut down
     
408. 
     
409. sql statement: drop tablespace  USERS including contents keep datafiles
     
410. 
     
411. Performing import of metadata...
     
412.    IMPDP> Master table "SYS"."TSPITR_IMP_BcBD" successfully loaded/unloaded
     
413.    IMPDP> Starting "SYS"."TSPITR_IMP_BcBD":  
     
414.    IMPDP> Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
     
415.    IMPDP> Processing object type TRANSPORTABLE_EXPORT/TYPE/TYPE_SPEC
     
416.    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
     
417.    IMPDP> Processing object type TRANSPORTABLE_EXPORT/TYPE/TYPE_BODY
     
418.    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
     
419.    IMPDP> Processing object type TRANSPORTABLE_EXPORT/XMLSCHEMA/XMLSCHEMA
     
420.    IMPDP> ORA-39083: Object type XMLSCHEMA failed to create with error:
     
421. ORA-31085: schema "http://localhost:8080/source/schemas/poSource/xsd/purchaseOrder.xsd" already registered
     
422. Failing sql is:
     
423. BEGIN dbms_xmlschema.registerSchema(:1, :2, (:3 = 1), FALSE,FALSE,FALSE,FALSE, :4, options=> :5, schemaoid => :6, import_options => :7); END;
     
424.    IMPDP> Processing object type TRANSPORTABLE_EXPORT/TABLE
     
425.    IMPDP> ORA-39083: Object type TABLE:"OE"."PURCHASEORDER" failed to create with error:
     
426. ORA-31061: XDB error: DBMS_XDBZ.ENABLE_HIERARCHY
     
427. ORA-06512: at "XDB.DBMS_XDBZ0", line 131
     
428. ORA-06512: at "XDB.DBMS_XDBZ0", line 588
     
429. ORA-01031: insufficient privileges
     
430. Failing sql is:
     
431. BEGIN DBMS_XDBZ.ENABLE_HIERARCHY('"OE"','"PURCHASEORDER"'); END;
     
432.    IMPDP> Processing object type TRANSPORTABLE_EXPORT/INDEX/INDEX
     
433.    IMPDP> Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/CONSTRAINT
     
434.    IMPDP> Processing object type TRANSPORTABLE_EXPORT/INDEX_STATISTICS
     
435.    IMPDP> ORA-39083: Object type INDEX_STATISTICS failed to create with error:
     
436. ORA-20000: INDEX "OE"."LINEITEM_TABLE_MEMBERS" does not exist or insufficient privileges
     
437. Failing sql is:
     
438. DECLARE I_N VARCHAR2(60);   I_O VARCHAR2(60);   NV VARCHAR2(1);   c DBMS_METADATA.T_VAR_COLL;   df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS';  stmt varchar2(300) := ' INSERT INTO "SYS"."IMPDP_STATS" (type,version,flags,c1,c2,c3,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,d1,cl1) VALUES (''I'',6,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,NULORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type TABLE:"OE"."PURCHASEORDER" creation failedORA-39083: Object type INDEX_STATISTICS failed to create with error:
     
439. ORA-20000: INDEX "OE"."ACTION_TABLE_MEMBERS" does not exist or insufficient privileges
     
440. Failing sql is:
     
441. DECLARE I_N VARCHAR2(60);   I_O VARCHAR2(60);   NV VARCHAR2(1);   c DBMS_METADATA.T_VAR_COLL;   df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS';  stmt varchar2(300) := ' INSERT INTO "SYS"."IMPDP_STATS" (type,version,flags,c1,c2,c3,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,d1,cl1) VALUES (''I'',6,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,NULL,
     
442.    IMPDP> Processing object type TRANSPORTABLE_EXPORT/COMMENT
     
443.    IMPDP> Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/REF_CONSTRAINT
     
444.    IMPDP> Processing object type TRANSPORTABLE_EXPORT/TABLE_STATISTICS
     
445.    IMPDP> ORA-39112: Dependent object type TABLE_STATISTICS skipped, base object type TABLE:"OE"."PURCHASEORDER" creation failed
     
446.    IMPDP> Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
     
447.    IMPDP> Job "SYS"."TSPITR_IMP_BcBD" completed with 25 error(s) at 21:49:53
     
448. Import completed
     
449. 
     
450. 
     
451. contents of Memory Script:
     
452. {
     
453. # make read write and offline the imported tablespaces
     
454. sql 'alter tablespace  USERS read write';
     
455. sql 'alter tablespace  USERS offline';
     
456. # enable autobackups after TSPITR is finished
     
457. sql 'begin dbms_backup_restore.AutoBackupFlag(TRUE); end;';
     
458. }
     
459. executing Memory Script
     
460. 
     
461. sql statement: alter tablespace  USERS read write
     
462. 
     
463. sql statement: alter tablespace  USERS offline
     
464. 
     
465. sql statement: begin dbms_backup_restore.AutoBackupFlag(TRUE); end;
     
466. 
     
467. Removing automatic instance
     
468. Automatic instance removed
     
469. auxiliary instance file /u01/app/oracle/oradata/ORCL/datafile/o1_mf_temp_focq53vc_.tmp deleted
     
470. auxiliary instance file /u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_3_focq52oo_.log deleted
     
471. auxiliary instance file /u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_2_focq52bt_.log deleted
     
472. auxiliary instance file /u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_1_focq51yc_.log deleted
     
473. auxiliary instance file /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_focq1q59_.dbf deleted
     
474. auxiliary instance file /u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_focq1q5x_.dbf deleted
     
475. auxiliary instance file /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_focq1l57_.dbf deleted
     
476. auxiliary instance file /u01/app/oracle/oradata/ORCL/controlfile/o1_mf_focq0r3q_.ctl deleted
     
477. Finished recover at 2018-07-23:21:49:56
     
478. 
     
479. RMAN>
     

复制代码