|
dump" 54. db_name = "winorcl" 55. # Please review the values of the following parameters: 56. __shared_pool_size = 167772160 57. __large_pool_size = 4194304 58. __java_pool_size = 16777216 59. __streams_pool_size = 0 60. __db_cache_size = 415236096 61. remote_login_passwordfile= "EXCLUSIVE" 62. db_domain = "766.com" 63. dispatchers = "(PROTOCOL=TCP) (SERVICE=winorclXDB)" 64. # The values of the following parameters are from source database: 65. processes = 150 66. nls_language = "SIMPLIFIED CHINESE" 67. nls_territory = "CHINA" 68. sga_target = 612368384 69. db_block_size = 8192 70. compatible = "10.2.0.1.0" 71. log_archive_format = "ARC%S_%R.%T" 72. db_file_multiblock_read_count= 16 73. undo_management = "AUTO" 74. undo_tablespace = "UNDOTBS1" 75. job_queue_processes = 10 76. open_cursors = 300 77. pga_aggregate_target = 203423744 四：开始迁移 1. [oracle@rhel6 ~]$ export ORACLE_SID=winorcl 2. [oracle@rhel6 ~]$ sqlplus /nolog 3. SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jul 17 20:25:10 2011 4. Copyright (c) 1982, 2005, Oracle. All rights reserved. 5. 6. SQL> conn /as sysdba 7. Connected to an idle instance. 8. SQL> create spfile from pfile; 9. File created. 10. 11. SQL> startup nomount 12. ORACLE instance started. 13. Total System Global Area 612368384 bytes 14. Fixed Size 2022696 bytes 15. Variable Size 188744408 bytes 16. Database Buffers 415236096 bytes 17. Redo Buffers 6365184 bytes 18. 19. SQL> @/home/oracle/winorcl.sql; 20. Control file created. 21. 22. 23. SQL> alter database open resetlogs; 24. Database altered. 25. 26. SQL> select dbid,name from v$database; 27. 28. DBID NAME 29. ---------- --------------------------- 30. 1904915064 WINORCL 31. 32. SQL> select * from t_migrate; 33. 34. A 35. ---------- 36. 1 37. 38. SQL> select tablespace_name from dba_tablespaces; 39. 40. TABLESPACE_NAME 41. -------------------------------------------------------------------------------- 42. SYSTEM 43. UNDOTBS1 44. SYSAUX 45. TEMP 46. USERS 47. EXAMPLE 48. WIN_MIGRATE 49. 50. 7 rows selected. 51. 52. SQL> alter tablespace temp add tempfile '/u01/app/oradata/winorcl/temp01.dbf' size 50M; 53. Tablespace altered. 五：收尾工作 1. SQL> shutdown immediate 2. Database closed. 3. Database dismounted. 4. ORACLE instance shut down. 5. SQL> startup upgrade 6. ORACLE instance started. 7. 8. Total System Global Area 268435456 bytes 9. Fixed Size 2020056 bytes 10. Variable Size 83889448 bytes 11. Database Buffers 176160768 bytes 12. Redo Buffers 6365184 bytes 13. Database mounted. 14. Database opened. 15. 16. SQL> @ /rdbms/admin/utlirp.sql; 17. SQL> spool /tmp/upgrade.log 18. SQL> @ /rdbms/admin/utlrp.sql; 19. SQL> startup force 本文出自 “月牙天冲” 博客
|