课程第34次

botang

1. select  * from v$transportable_platform
   
2. order by 2;

复制代码

	PLATFORM_ID	PLATFORM_NAME	ENDIAN_FORMAT
1	6	AIX-Based Systems (64-bit)	Big
2	16	Apple Mac OS	Big
3	21	Apple Mac OS (x86-64)	Little
4	19	HP IA Open VMS	Little
5	15	HP Open VMS	Little
6	5	HP Tru64 UNIX	Little
7	3	HP-UX (64-bit)	Big
8	4	HP-UX IA (64-bit)	Big
9	18	IBM Power Based Linux	Big
10	9	IBM zSeries Based Linux	Big
11	10	Linux IA (32-bit)	Little
12	11	Linux IA (64-bit)	Little
13	13	Linux x86 64-bit	Little
14	7	Microsoft Windows IA (32-bit)	Little
15	8	Microsoft Windows IA (64-bit)	Little
16	12	Microsoft Windows x86 64-bit	Little
17	17	Solaris Operating System (x86)	Little
18	20	Solaris Operating System (x86-64)	Little
19	1	Solaris[tm] OE (32-bit)	Big
20	2	Solaris[tm] OE (64-bit)	Big

传送表空间要大的跨平台：转换数据文件头+数据文件体。
如果要convert（不同的endian序列才要covert）,源头convert语法是：convert tablespace to platform
                                                                    目的地convert语法是：convert datafile from platform

----------------------------------------------------WINORCL 原来是4K ，重新穿件控制文件和日志文件-----------------------------

1. SQL> startup mount
   
2. ORACLE 例程已经启动。
   
3. 
   
4. Total System Global Area  617975808 bytes
   
5. Fixed Size                  2283744 bytes
   
6. Variable Size             234882848 bytes
   
7. Database Buffers          373293056 bytes
   
8. Redo Buffers                7516160 bytes
   
9. 数据库装载完毕。
   
10. SQL> alter database open ;
    
11. alter database open
    
12. *
    
13. 第 1 行出现错误:
    
14. ORA-03113: 通信通道的文件结尾
    
15. 进程 ID: 254808
    
16. 会话 ID: 191 序列号: 3

复制代码

------------------------------------------------
drop 或者clear unarchived 都过不去：

1. SQL> conn / as sysdba
   
2. 已连接。
   
3. SQL> alter database drop logfile group 2;
   
4. alter database drop logfile group 2
   
5. *
   
6. 第 1 行出现错误:
   
7. ORA-01623: 日志 2 是实例 winorcl (线程 1) 的当前日志 - 无法删除
   
8. ORA-00312: 联机日志 2 线程 1: 'C:\APP\APPLE\ORADATA\WINORCL\REDO02.LOG'
   

复制代码

1. SQL> alter database clear unarchived logfile group 2  blocksize 4096;
   
2. alter database clear unarchived logfile group 2  blocksize 4096
   
3.                                                  *
   
4. 第 1 行出现错误:
   
5. ORA-00933: SQL 命令未正确结束

复制代码

脚本重建控制文件，编辑去掉"4096"，要选择set 2：

1. CREATE CONTROLFILE REUSE DATABASE "WINORCL" RESETLOGS  ARCHIVELOG
   
2.     MAXLOGFILES 16
   
3.     MAXLOGMEMBERS 3
   
4.     MAXDATAFILES 100
   
5.     MAXINSTANCES 8
   
6.     MAXLOGHISTORY 292
   
7. LOGFILE
   
8.   GROUP 2 'C:\APP\APPLE\ORADATA\WINORCL\REDO02.LOG'  SIZE 50M BLOCKSIZE 512,
   
9.   GROUP 4 'C:\APP\APPLE\ORADATA\WINORCL\REDO04.LOG'  SIZE 100M BLOCKSIZE 512,
   
10.   GROUP 5 'C:\APP\APPLE\ORADATA\WINORCL\REDO05.LOG'  SIZE 100M BLOCKSIZE 512,
    
11.   GROUP 6 'C:\APP\APPLE\ORADATA\WINORCL\REDO06.LOG'  SIZE 100M BLOCKSIZE 512
    
12. -- STANDBY LOGFILE
    
13. DATAFILE
    
14.   'C:\APP\APPLE\ORADATA\WINORCL\SYSTEM01.DBF',
    
15.   'C:\APP\APPLE\ORADATA\WINORCL\SYSAUX01.DBF',
    
16.   'C:\APP\APPLE\ORADATA\WINORCL\UNDOTBS01.DBF',
    
17.   'C:\APP\APPLE\ORADATA\WINORCL\USERS01.DBF',
    
18.   'C:\APP\APPLE\ORADATA\WINORCL\RCAT01.DBF',
    
19.   'C:\APP\APPLE\ORADATA\WINORCL\TBS05319.DBF',
    
20.   'C:\APP\APPLE\ORADATA\WINORCL\TBS05319X.DBF',
    
21.   'C:\APP\APPLE\ORADATA\WINORCL\TBSSOLARIS.DBF'
    
22. CHARACTER SET AL32UTF8
    
23. ;
    
24. 
    
25. ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\APP\APPLE\ORADAT\WINORCL\TEMP01.DBF' REUSE;
    
26. 
    

复制代码

---------------------------------------------------------------------------------------------------------------------
源头转换：

1. create tablespace tbstrans1 datafile size 10M  ;
   
2. 
   
3. create tablespace tbstrans2 datafile size 10M;
   
4. 
   
5. alter tablespace tbstrans1 read only;
   
6. 
   
7. alter tablespace tbstrans2 read only ;
   
8. 
   
9. begin
   
10.    dbms_tts.transport_set_check('TBSTRANS1,TBSTRANS2');
    
11. end;
    
12. 
    
13. select  * from transport_set_violations;

复制代码

1. RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO  BACKUPSET;
   
2. 
   
3. old RMAN configuration parameters:
   
4. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO COMPRESSED BACKUPSET;
   
5. new RMAN configuration parameters:
   
6. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
   
7. new RMAN configuration parameters are successfully stored
   
8. released channel: ORA_DISK_1
   
9. released channel: ORA_DISK_2
   
10. released channel: ORA_DISK_3
    
11. released channel: ORA_DISK_4
    
12. released channel: ORA_DISK_5
    
13. released channel: ORA_DISK_6
    
14. released channel: ORA_DISK_7
    
15. released channel: ORA_DISK_8
    
16. 
    
17. RMAN>  convert tablespace tbstrans1  to platform 'Microsoft Windows IA (64-bit)' format '/home/oracle/tbstrans1.dbf';
    
18. 
    
19. Starting conversion at source at 2019-12-22:21:29:11
    
20. allocated channel: ORA_DISK_1
    
21. channel ORA_DISK_1: SID=79 device type=DISK
    
22. allocated channel: ORA_DISK_2
    
23. channel ORA_DISK_2: SID=77 device type=DISK
    
24. allocated channel: ORA_DISK_3
    
25. channel ORA_DISK_3: SID=130 device type=DISK
    
26. allocated channel: ORA_DISK_4
    
27. channel ORA_DISK_4: SID=20 device type=DISK
    
28. allocated channel: ORA_DISK_5
    
29. channel ORA_DISK_5: SID=69 device type=DISK
    
30. allocated channel: ORA_DISK_6
    
31. channel ORA_DISK_6: SID=145 device type=DISK
    
32. allocated channel: ORA_DISK_7
    
33. channel ORA_DISK_7: SID=143 device type=DISK
    
34. allocated channel: ORA_DISK_8
    
35. channel ORA_DISK_8: SID=203 device type=DISK
    
36. ignoring encryption for proxy or image copies
    
37. channel ORA_DISK_1: starting datafile conversion
    
38. input datafile file number=00005 name=+DATA/orcl/datafile/tbstrans1.261.1027718433
    
39. converted datafile=/home/oracle/tbstrans1.dbf
    
40. channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01
    
41. Finished conversion at source at 2019-12-22:21:29:13
    
42. 
    
43. RMAN>

复制代码

1. C:\Users\Apple>impdp system/oracle_4U  directory=dirwin dumpfile=tbstrans1.dmp  TRANSPORT_DATAFILES='C:\app\Apple\oradata\winorcl\tbstrans1.dbf'
   
2. 
   
3. Import: Release 11.2.0.4.0 - Production on 星期日 12月 22 22:00:47 2019
   
4. 
   
5. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. 连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
   
8. With the Partitioning, OLAP, Data Mining and Real Application Testing options
   
9. 已成功加载/卸载了主表 "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01"
   
10. 源时区为 +00:00, 目标时区为 +08:00。
    
11. 启动 "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01":  system/******** directory=dirwin dumpfile=tbstrans1.dmp TRANSPORT_DATAFILES='C:\app\Apple\oradata\winorcl\tbstrans1.dbf'
    
12. 处理对象类型 TRANSPORTABLE_EXPORT/PLUGTS_BLK
    
13. 处理对象类型 TRANSPORTABLE_EXPORT/TABLE
    
14. 处理对象类型 TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
    
15. 作业 "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" 已于 星期日 12月 22 22:00:59 2019 elapsed 0 00:00:06 成功完成
    
16. 
    
17. 
    
18. C:\Users\Apple>
    

复制代码

-------------
目的地转换：

在源头上故意转不对的平台：

1. RMAN>  convert tablespace tbstrans2 to platform 'IBM zSeries Based Linux' format '/home/oracle/tbstrans2.dbf' ;
   
2. 
   
3. Starting conversion at source at 2019-12-22:22:07:10
   
4. using target database control file instead of recovery catalog
   
5. allocated channel: ORA_DISK_1
   
6. channel ORA_DISK_1: SID=82 device type=DISK
   
7. allocated channel: ORA_DISK_2
   
8. channel ORA_DISK_2: SID=143 device type=DISK
   
9. allocated channel: ORA_DISK_3
   
10. channel ORA_DISK_3: SID=130 device type=DISK
    
11. allocated channel: ORA_DISK_4
    
12. channel ORA_DISK_4: SID=204 device type=DISK
    
13. allocated channel: ORA_DISK_5
    
14. channel ORA_DISK_5: SID=138 device type=DISK
    
15. allocated channel: ORA_DISK_6
    
16. channel ORA_DISK_6: SID=197 device type=DISK
    
17. allocated channel: ORA_DISK_7
    
18. channel ORA_DISK_7: SID=21 device type=DISK
    
19. allocated channel: ORA_DISK_8
    
20. channel ORA_DISK_8: SID=83 device type=DISK
    
21. ignoring encryption for proxy or image copies
    
22. channel ORA_DISK_1: starting datafile conversion
    
23. input datafile file number=00006 name=+DATA/orcl/datafile/tbstrans2.262.1027718497
    
24. converted datafile=/home/oracle/tbstrans2.dbf
    
25. channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01
    
26. Finished conversion at source at 2019-12-22:22:07:28
    
27. 
    
28. RMAN>

复制代码

expdp部分倒是一样的：

1. [oracle@station76 ~]$ expdp system/oracle_4U directory=dir1 dumpfile=tbstrans2.dmp  TRANSPORT_TABLESPACES=tbstrans2
   
2. 
   
3. Export: Release 11.2.0.4.0 - Production on Sun Dec 22 22:05:38 2019
   
4. 
   
5. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
   
8. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
   
9. and Real Application Testing options
   
10. Starting "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01":  system/******** directory=dir1 dumpfile=tbstrans2.dmp TRANSPORT_TABLESPACES=tbstrans2
    
11. Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
    
12. Processing object type TRANSPORTABLE_EXPORT/TABLE
    
13. Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
    
14. Master table "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01" successfully loaded/unloaded
    
15. ******************************************************************************
    
16. Dump file set for SYSTEM.SYS_EXPORT_TRANSPORTABLE_01 is:
    
17.   /home/oracle/dir1/tbstrans2.dmp
    
18. ******************************************************************************
    
19. Datafiles required for transportable tablespace TBSTRANS2:
    
20.   +DATA/orcl/datafile/tbstrans2.262.1027718497
    
21. Job "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01" successfully completed at Sun Dec 22 22:07:40 2019 elapsed 0 00:02:00
    

复制代码

如果传送的数据文件endian序列不是目的地的，就会报“文件头”出错：

1. C:\Users\Apple>impdp system/oracle_4U  directory=dirwin dumpfile=tbstrans2.dmp  TRANSPORT_DATAFILES='C:\app\Apple\oradata\winorcl\tbstrans2.dbf'
   
2. 
   
3. Import: Release 11.2.0.4.0 - Production on 星期日 12月 22 22:10:51 2019
   
4. 
   
5. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. 连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
   
8. With the Partitioning, OLAP, Data Mining and Real Application Testing options
   
9. 已成功加载/卸载了主表 "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01"
   
10. 源时区为 +00:00, 目标时区为 +08:00。
    
11. 启动 "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01":  system/******** directory=dirwin dumpfile=tbstrans2.dmp TRANSPORT_DATAFILES='C:\app\Apple\oradata\winorcl\tbstrans2.dbf'
    
12. 处理对象类型 TRANSPORTABLE_EXPORT/PLUGTS_BLK
    
13. ORA-39123: 数据泵可传输的表空间作业中止
    
14. ORA-01565: 标识文件 'C:\app\Apple\oradata\winorcl\tbstrans2.dbf' 时出错
    
15. ORA-27048: skgfifi: 文件标头信息无效
    
16. OSD-04001: ？???？С？Ч (OS 2097152)
    
17. 
    
18. 作业 "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" 因致命错误于 星期日 12月 22 22:10:57 2019 elapsed 0 00:00:04 停止
    

复制代码

解决办法就是在目的地上再转换：

1. C:\Users\Apple>rman target  /
   
2. 
   
3. 恢复管理器: Release 11.2.0.4.0 - Production on 星期日 12月 22 22:14:05 2019
   
4. 
   
5. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. 已连接到目标数据库: WINORCL (DBID=2162311502)
   
8. 
   
9. RMAN> convert datafile 'C:\app\Apple\oradata\winorcl\tbstrans2.dbf' from platform 'IBM zSeries Based Linux'  format 'C:\app\Apple\oradata\winorcl\tbstrans2b.dbf' ;
   
10. 
    
11. 启动 conversion at target 于 22-12月-19
    
12. 使用目标数据库控制文件替代恢复目录
    
13. 分配的通道: ORA_DISK_1
    
14. 通道 ORA_DISK_1: SID=10 设备类型=DISK
    
15. 通道 ORA_DISK_1: 启动数据文件转换
    
16. 输入文件名=C:\APP\APPLE\ORADATA\WINORCL\TBSTRANS2.DBF
    
17. 已转换的数据文件 = C:\APP\APPLE\ORADATA\WINORCL\TBSTRANS2B.DBF
    
18. 通道 ORA_DISK_1: 数据文件转换完毕, 经过时间: 00:00:01
    
19. 完成 conversion at target 于 22-12月-19
    

复制代码

再次导入（与tbstrans1一样）：

1. C:\Users\Apple>impdp system/oracle_4U  directory=dirwin dumpfile=tbstrans2.dmp  TRANSPORT_DATAFILES='C:\app\Apple\oradata\winorcl\tbstrans2b.dbf'
   
2. 
   
3. Import: Release 11.2.0.4.0 - Production on 星期日 12月 22 22:19:52 2019
   
4. 
   
5. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. 连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
   
8. With the Partitioning, OLAP, Data Mining and Real Application Testing options
   
9. 已成功加载/卸载了主表 "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01"
   
10. 源时区为 +00:00, 目标时区为 +08:00。
    
11. 启动 "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01":  system/******** directory=dirwin dumpfile=tbstrans2.dmp TRANSPORT_DATAFILES='C:\app\Apple\oradata\winorcl\tbstrans2b.dbf'
    
12. 处理对象类型 TRANSPORTABLE_EXPORT/PLUGTS_BLK
    
13. 处理对象类型 TRANSPORTABLE_EXPORT/TABLE
    
14. 处理对象类型 TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
    
15. 作业 "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" 已于 星期日 12月 22 22:20:00 2019 elapsed 0 00:00:05 成功完成
    

复制代码

-----------传送数据库：
先把源头库只读，然后：

1. [oracle@station76 ~]$ rman target /
   
2. 
   
3. Recovery Manager: Release 11.2.0.4.0 - Production on Sun Dec 22 22:31:33 2019
   
4. 
   
5. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: ORCL (DBID=1554722616)
   
8. 
   
9. RMAN> convert database to platform  'Microsoft Windows IA (64-bit)' format '/home/oracle/dbtrans/%U';
   
10. 
    
11. Starting conversion at source at 2019-12-22:22:32:25
    
12. using target database control file instead of recovery catalog
    
13. allocated channel: ORA_DISK_1
    
14. channel ORA_DISK_1: SID=194 device type=DISK
    
15. allocated channel: ORA_DISK_2
    
16. channel ORA_DISK_2: SID=8 device type=DISK
    
17. allocated channel: ORA_DISK_3
    
18. channel ORA_DISK_3: SID=72 device type=DISK
    
19. allocated channel: ORA_DISK_4
    
20. channel ORA_DISK_4: SID=134 device type=DISK
    
21. allocated channel: ORA_DISK_5
    
22. channel ORA_DISK_5: SID=197 device type=DISK
    
23. allocated channel: ORA_DISK_6
    
24. channel ORA_DISK_6: SID=7 device type=DISK
    
25. allocated channel: ORA_DISK_7
    
26. channel ORA_DISK_7: SID=71 device type=DISK
    
27. allocated channel: ORA_DISK_8
    
28. channel ORA_DISK_8: SID=135 device type=DISK
    
29. 
    
30. Directory SYS.DIR1 found in the database
    
31. Directory SYS.XMLDIR found in the database
    
32. Directory SYS.ORACLE_OCM_CONFIG_DIR2 found in the database
    
33. Directory SYS.ORACLE_OCM_CONFIG_DIR found in the database
    
34. Directory SYS.DATA_PUMP_DIR found in the database
    
35. 
    
36. User SYS with SYSDBA and SYSOPER privilege found in password file
    
37. ignoring encryption for proxy or image copies
    
38. channel ORA_DISK_2: starting datafile conversion
    
39. input datafile file number=00001 name=+DATA/orcl/datafile/system.283.1026941797
    
40. channel ORA_DISK_3: starting datafile conversion
    
41. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.282.1026941797
    
42. channel ORA_DISK_4: starting datafile conversion
    
43. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.281.1026941797
    
44. channel ORA_DISK_5: starting datafile conversion
    
45. input datafile file number=00005 name=+DATA/orcl/datafile/tbstrans1.261.1027718433
    
46. channel ORA_DISK_6: starting datafile conversion
    
47. input datafile file number=00006 name=+DATA/orcl/datafile/tbstrans2.262.1027718497
    
48. channel ORA_DISK_7: starting datafile conversion
    
49. input datafile file number=00004 name=+DATA/orcl/datafile/users.265.1027544577
    
50. converted datafile=/home/oracle/dbtrans/data_D-ORCL_I-1554722616_TS-TBSTRANS1_FNO-5_34uk3jgh
    
51. channel ORA_DISK_5: datafile conversion complete, elapsed time: 00:00:00
    
52. converted datafile=/home/oracle/dbtrans/data_D-ORCL_I-1554722616_TS-TBSTRANS2_FNO-6_35uk3jgh
    
53. channel ORA_DISK_6: datafile conversion complete, elapsed time: 00:00:01
    
54. converted datafile=/home/oracle/dbtrans/data_D-ORCL_I-1554722616_TS-USERS_FNO-4_36uk3jgh
    
55. channel ORA_DISK_7: datafile conversion complete, elapsed time: 00:00:02
    
56. converted datafile=/home/oracle/dbtrans/data_D-ORCL_I-1554722616_TS-UNDOTBS1_FNO-3_33uk3jgh
    
57. channel ORA_DISK_4: datafile conversion complete, elapsed time: 00:00:04
    
58. converted datafile=/home/oracle/dbtrans/data_D-ORCL_I-1554722616_TS-SYSTEM_FNO-1_31uk3jgf
    
59. channel ORA_DISK_2: datafile conversion complete, elapsed time: 00:00:28
    
60. converted datafile=/home/oracle/dbtrans/data_D-ORCL_I-1554722616_TS-SYSAUX_FNO-2_32uk3jgg
    
61. channel ORA_DISK_3: datafile conversion complete, elapsed time: 00:00:27
    
62. Edit init.ora file /home/oracle/dbtrans/init_00uk3jgf_1_0.ora. This PFILE will be used to create the database on the target platform
    
63. To recompile all PL/SQL modules, run utlirp.sql and utlrp.sql on the target platform
    
64. To change the internal database identifier, use DBNEWID Utility
    
65. Finished conversion at source at 2019-12-22:22:33:15
    
66. 
    
67. RMAN>

复制代码

注意观察ADR中的日志，在以上rman命令结束的最后一个日志：

1. -rw-r-----. 1 oracle asmadmin     81 Dec 22 22:28 orcl_ora_19483.trm
   
2. -rw-r-----. 1 oracle asmadmin    978 Dec 22 22:28 orcl_ora_19483.trc
   
3. -rw-r-----. 1 oracle asmadmin     76 Dec 22 22:28 orcl_vktm_19500.trm
   
4. -rw-r-----. 1 oracle asmadmin   1092 Dec 22 22:28 orcl_vktm_19500.trc
   
5. -rw-r-----. 1 oracle asmadmin     60 Dec 22 22:28 orcl_asmb_19527.trm
   
6. -rw-r-----. 1 oracle asmadmin    873 Dec 22 22:28 orcl_asmb_19527.trc
   
7. -rw-r-----. 1 oracle asmadmin     69 Dec 22 22:28 orcl_mark_19535.trm
   
8. -rw-r-----. 1 oracle asmadmin    871 Dec 22 22:28 orcl_mark_19535.trc
   
9. -rw-r-----. 1 oracle asmadmin     60 Dec 22 22:28 orcl_mman_19512.trm
   
10. -rw-r-----. 1 oracle asmadmin    873 Dec 22 22:28 orcl_mman_19512.trc
    
11. -rw-r-----. 1 oracle asmadmin    110 Dec 22 22:29 orcl_dbw0_19514.trm
    
12. -rw-r-----. 1 oracle asmadmin   1259 Dec 22 22:29 orcl_dbw0_19514.trc
    
13. -rw-r-----. 1 oracle asmadmin    104 Dec 22 22:29 orcl_dbrm_19508.trm
    
14. -rw-r-----. 1 oracle asmadmin   1321 Dec 22 22:29 orcl_dbrm_19508.trc
    
15. -rw-r-----. 1 oracle asmadmin 173246 Dec 22 22:33 alert_orcl.log
    
16. -rw-r-----. 1 oracle asmadmin    156 Dec 22 22:33 orcl_ora_20401.trm
    
17. -rw-r-----. 1 oracle asmadmin   4700 Dec 22 22:33 orcl_ora_20401.trc
    
18. -rw-r-----. 1 oracle asmadmin     82 Dec 22 22:34 orcl_mmon_19529.trm
    
19. -rw-r-----. 1 oracle asmadmin   1099 Dec 22 22:34 orcl_mmon_19529.trc
    
20. [oracle@station76 trace]$ cp orcl_ora_20401.trc  /home/oracle/dbtrans/
    
21. [oracle@station76 trace]$

复制代码

所以/home/oracle/dbtrans目录下有所有的数据文件+已经在里面的参数文件和刚刚拷贝进去的trace（控制文件set2脚本）