here p.addr=s.paddr 3. 3 and s.username='SYS' and s.program like '%rman%'; 4. 5. SPID 6. ------------ 7. 476 8. 3488 4056  三.在linux服务器上准备相应的目录，并将上传的文件移动到相关的目录,修改控制文件脚本和初始化参数文件 1. [root@rhel6 ~]# mount -t cifs -o username=yang //192.168.50.195/data /mnt 2. Password: 3. [root@rhel6 ~]# ls /mnt 4. DATA_D-WINORCL_I-1904915064_TS-EXAMPLE_FNO-5_03MHMQUN DATA_D-WINORCL_I-1904915064_TS-UNDOTBS1_FNO-2_04MHMQUU INIT_00MHMQTE_1_0.ORA 5. DATA_D-WINORCL_I-1904915064_TS-SYSAUX_FNO-3_02MHMQU8 DATA_D-WINORCL_I-1904915064_TS-USERS_FNO-4_06MHMQV3 winorcl_ora_4056.trc 6. DATA_D-WINORCL_I-1904915064_TS-SYSTEM_FNO-1_01MHMQTF DATA_D-WINORCL_I-1904915064_TS-WIN_MIGRATE_FNO-6_05MHMQV2 7. 8. [oracle@rhel6 ~]$ mkdir -p /u01/app/admin/winorcl/{adump,bdump,cdump,udump} 9. [oracle@rhel6 ~]$ mkdir -p /u01/app/oradata/winorcl 10. [oracle@rhel6 ~]$ mkdir -p /u01/app/flash_recovery_area/WINORCL 11. 12. [oracle@rhel6 ~]$ cp /mnt/DATA_D-WINORCL_I-1904915064_TS-* /u01/app/oradata/winorcl/ 13. [oracle@rhel6 ~]$ cp /mnt/INIT_00MHMQTE_1_0.ORA $ORACLE_HOME/dbs/initwinorcl.ora 14. [oracle@rhel6 ~]$ cp /mnt/winorcl_ora_4056.trc ~/winorcl.sql 15. 16. [oracle@rhel6 ~]$ cd /u01/app/oradata/winorcl 17. [oracle@rhel6 winorcl]$ mv DATA_D-WINORCL_I-1904915064_TS-EXAMPLE_FNO-5_03MHMQUN example01.dbf 18. [oracle@rhel6 winorcl]$ mv DATA_D-WINORCL_I-1904915064_TS-SYSAUX_FNO-3_02MHMQU8 sysaux01.dbf 19. [oracle@rhel6 winorcl]$ mv DATA_D-WINORCL_I-1904915064_TS-SYSTEM_FNO-1_01MHMQTF system01.dbf 20. [oracle@rhel6 winorcl]$ mv DATA_D-WINORCL_I-1904915064_TS-UNDOTBS1_FNO-2_04MHMQUU undotbs1.dbf 21. [oracle@rhel6 winorcl]$ mv DATA_D-WINORCL_I-1904915064_TS-USERS_FNO-4_06MHMQV3 users01.dbf 22. [oracle@rhel6 winorcl]$ mv DATA_D-WINORCL_I-1904915064_TS-WIN_MIGRATE_FNO-6_05MHMQV2 win_migrate01.dbf 23. 24. [oracle@rhel6 ~]$ cat winorcl.sql 25. CREATE CONTROLFILE REUSE SET DATABASE "winorcl" RESETLOGS ARCHIVELOG 26. MAXLOGFILES 16 27. MAXLOGMEMBERS 3 28. MAXDATAFILES 100 29. MAXINSTANCES 8 30. MAXLOGHISTORY 292 31. LOGFILE 32. GROUP 1 '/u01/app/oradata/winorcl/redo01.dbf' SIZE 50M, 33. GROUP 2 '/u01/app/oradata/winorcl/redo02.dbf' SIZE 50M, 34. GROUP 3 '/u01/app/oradata/winorcl/redo03.dbf' SIZE 50M 35. DATAFILE 36. '/u01/app/oradata/winorcl/system01.dbf', 37. '/u01/app/oradata/winorcl/undotbs1.dbf', 38. '/u01/app/oradata/winorcl/sysaux01.dbf', 39. '/u01/app/oradata/winorcl/users01.dbf', 40. '/u01/app/oradata/winorcl/example01.dbf', 41. '/u01/app/oradata/winorcl/win_migrate01.dbf' 42. CHARACTER SET ZHS16GBK 43. ; 44. 45. [oracle@rhel6 dbs]$ grep -v '^$' initwinorcl.ora 46. # Please change the values of the following parameters: 47. control_files = "/u01/app/oradata/winorcl/control01.dbf","/u01/app/oradata/winorcl/control02.dbf" 48. db_recovery_file_dest = "/u01/app/flash_recovery_area" 49. db_recovery_file_dest_size= 21474836480 50. audit_file_dest = "/u01/app/admin/winorcl/adump" 51. background_dump_dest = "/u01/app/admin/winorcl/bdump" 52. user_dump_dest = "/u01/app/admin/winorcl/udump" 53. core_dump_dest = "/u01/app/admin/winorcl/c |