传送表空间“自包含集”检查和目的地转换大小endian码

botang

1. create tablespace tbs3 datafile '/u01/app/oracle/oradata/orcl2/tbs3.dbf' size 10M autoextend on maxsize 3G;
   
2. 
   
3. select *
   
4.   from dba_objects o
   
5.   where o.owner='HR'  
   
6.   order by 2;
   
7.   
   
8.   
   
9.   create table hr.t062iu11_g  ( a number )  tablespace tbs3;
   
10.   
    
11.   insert into HR.t062iu11_g  values ( 999);
    
12.   
    
13.   commit;
    
14.   
    
15.   create index  hr.i062iu11_g   on HR.t062iu11_g (a)  tablespace users;
    
16.   
    
17.   create table hr.t062iu11_part ( a number )  tablespace tbs3
    
18.   partition by range (a)
    
19.   ( partition p1 values less than (100)  tablespace tbs3,
    
20.     partition p2 values less than (maxvalue)  tablespace users );
    
21.    
    
22. insert into hr.t062iu11_part  values ( 99) ;
    
23. 
    
24. insert into hr.t062iu11_part  values ( 100) ;
    
25. 
    
26. commit;
    
27. 
    
28. select  * from hr.t062iu11_part;
    
29. 
    
30. select  * from hr.t062iu11_part   partition ( p1);
    
31. 
    
32.   select  * from hr.t062iu11_part   partition ( p2);
    
33.   
    
34.   select  * from dba_segments
    
35.     where segment_name ='T062IU11_PART';
    
36.   
    
37.   select * from  dba_objects  where object_name like 'DBMS%TTS';
    
38.   desc dbms_tts;
    
39.   
    
40.   begin
    
41.     dbms_tts.TRANSPORT_SET_CHECK('TBS3');
    
42.   end;
    
43. 
    
44. select  * from transport_set_violations;
    
45.   

复制代码

-------

1. [oracle@classroom orcl2]$ impdp system/oracle_4U directory=dir1 dumpfile=xtts2.dmp transport_datafiles='/u01/app/oracle/oradata/orcl/tbs3.dbf'
   
2. 
   
3. Import: Release 12.1.0.2.0 - Production on Thu Sep 3 21:04:05 2020
   
4. 
   
5. Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
   
8. With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
   
9. and Real Application Testing options
   
10. Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
    
11. Source time zone is +00:00 and target time zone is +08:00.
    
12. Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01":  system/******** directory=dir1 dumpfile=xtts2.dmp transport_datafiles=/u01/app/oracle/oradata/orcl/tbs3.dbf
    
13. Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
    
14. ORA-39123: Data Pump transportable tablespace job aborted
    
15. ORA-01565: error in identifying file '/u01/app/oracle/oradata/orcl/tbs3.dbf'
    
16. ORA-27048: skgfifi: file header information is invalid
    
17. Additional information: 13
    
18. 
    
19. Job "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" stopped due to fatal error at Thu Sep 3 21:04:15 2020 elapsed 0 00:00:05
    
20. 
    
21. [oracle@classroom orcl2]$ rman target /
    
22. 
    
23. Recovery Manager: Release 12.1.0.2.0 - Production on Thu Sep 3 21:04:41 2020
    
24. 
    
25. Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
    
26. 
    
27. connected to target database: ORCL (DBID=1574592120)
    
28. 
    
29. RMAN> convert datafile '/u01/app/oracle/oradata/orcl/tbs3.dbf'  from platform 'Solaris[tm] OE (32-bit)'  format '/u01/app/oracle/oradata/orcl/tbs3-trans.dbf'
    
30. 2> ;
    
31. 
    
32. Starting conversion at target at 2020-09-03:21:07:21
    
33. using target database control file instead of recovery catalog
    
34. allocated channel: ORA_DISK_1
    
35. channel ORA_DISK_1: SID=7 device type=DISK
    
36. channel ORA_DISK_1: starting datafile conversion
    
37. input file name=/u01/app/oracle/oradata/orcl/tbs3.dbf
    
38. converted datafile=/u01/app/oracle/oradata/orcl/tbs3-trans.dbf
    
39. channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01
    
40. Finished conversion at target at 2020-09-03:21:07:24
    
41. 
    
42. RMAN> exit
    
43. 
    
44. 
    
45. Recovery Manager complete.
    
46. [oracle@classroom orcl2]$ cd /u01/app/oracle/
    
47. [oracle@classroom oracle]$ ls
    
48. admin        cfgtoollogs  Clusterware  fast_recovery_area   man_recovery_area      oradiag_oracle  wallet
    
49. audit        checkpoints  crsdata      flash_recovery_area  man_recovery_area.11g  product
    
50. botangdir01  classroom    diag         log                  oradata                station90
    
51. [oracle@classroom oracle]$ cd oradata/
    
52. [oracle@classroom oradata]$ ls
    
53. em12rep  orcl  orcl2  rcat  RCAT  rcat.11g  RCAT.11g  rcat.12c  RCAT.12c  rcat.12c.test  RCAT.12c.test
    
54. [oracle@classroom oradata]$ cd orcl
    
55. [oracle@classroom orcl]$ ls
    
56. sysaux01.dbf  system01.dbf  tbs1.dbf  tbs2.dbf  tbs3.dbf  tbs3-trans.dbf  temp01.dbf  undotbs01.dbf  users01.dbf
    
57. [oracle@classroom orcl]$ mv tbs3-trans.dbf tbs3.dbf
    
58. [oracle@classroom orcl]$ impdp system/oracle_4U directory=dir1 dumpfile=xtts2.dmp transport_datafiles='/u01/app/oracle/oradata/orcl/tbs3.dbf'
    
59. 
    
60. Import: Release 12.1.0.2.0 - Production on Thu Sep 3 21:08:25 2020
    
61. 
    
62. Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
    
63. 
    
64. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
    
65. With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
    
66. and Real Application Testing options
    
67. Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
    
68. Source time zone is +00:00 and target time zone is +08:00.
    
69. Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01":  system/******** directory=dir1 dumpfile=xtts2.dmp transport_datafiles=/u01/app/oracle/oradata/orcl/tbs3.dbf
    
70. Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
    
71. Processing object type TRANSPORTABLE_EXPORT/TABLE
    
72. Processing object type TRANSPORTABLE_EXPORT/TABLE_STATISTICS
    
73. Processing object type TRANSPORTABLE_EXPORT/STATISTICS/MARKER
    
74. Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
    
75. Job "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully completed at Thu Sep 3 21:08:55 2020 elapsed 0 00:00:29
    
76. 
    
77. [oracle@classroom orcl]$
    

复制代码