~专业好文档为您搜集整理~谢谢使用~
sort_area_size=524288 hash_join_enabled=TRUE
修改如下参数：
background_dump_dest=/database2/9i/admin/orcl1/bdump core_dump_dest=/database2/9i/admin/orcl1/cdump user_dump_dest=/database2/9i/admin/orcl1/udump instance_name=orcl1
2. 启动数据库
export ORACLE_BASE=/database2/9i export ORACLE_HOME=$ORACLE_BASE/db_1 export PATH=$ORACLE_HOME/bin:$PATH export ORACLE_SID=orcl1
startup nomount pfile='?/dbs/initorcl1.ora'; create spfile from pfile='?/dbs/initorcl1.ora'; shutdown abort startup nomount
alter system set sga_max_size=4g scope=spfile; alter system set pga_aggregate_target=2g scope=spfile;
ALTER SYSTEM SET SHARED_POOL_SIZE='1024m' SCOPE=spfile; ALTER SYSTEM SET JAVA_POOL_SIZE='1024m' SCOPE=spfile;
~专业好文档为您搜集整理~谢谢使用~
~专业好文档为您搜集整理~谢谢使用~
shutdown abort; startup mount; 3. 恢复数据库 run {
allocate channel c1 type disk; allocate channel c2 type disk; allocate channel c3 type disk; allocate channel c4 type disk; allocate channel c5 type disk; allocate channel c6 type disk; allocate channel c7 type disk; allocate channel c8 type disk;
set newname for datafile 1 to '/database2/9i/oradata/orcl1/system01.dbf';
set newname for datafile 2 to '/database2/9i/oradata/orcl1/undotbs01.dbf'; set newname for datafile 3 to '/database2/9i/oradata/orcl1/example01.dbf'; set newname for datafile 4 to '/database2/9i/oradata/orcl1/indx01.dbf';
set newname for datafile 5 to '/database2/9i/oradata/orcl1/tools01.dbf'; set newname for datafile 6 to '/database2/9i/oradata/orcl1/users01.dbf';
set newname for datafile 7 to '/database2/9i/oradata/orcl1/ACCIDENT.dbf'; set newname for datafile 8 to '/database2/9i/oradata/orcl1/ACCi_DATA.dbf'; set newname for datafile 9 to '/database2/9i/oradata/orcl1/IMPORTVEH1.dbf'; set newname for datafile 10 to '/database2/9i/oradata/orcl1/ntiis_26.dbf';
set newname for datafile 11 to '/database2/9i/oradata/orcl1/undotbs03.dbf';
~专业好文档为您搜集整理~谢谢使用~
~专业好文档为您搜集整理~谢谢使用~
set newname for datafile 12 to '/database2/9i/oradata/orcl1/MANAGE1.dbf';
set newname for datafile 13 to '/database2/9i/oradata/orcl1/undotbs04.dbf'; set newname for datafile 14 to '/database2/9i/oradata/orcl1/WZZD_ZD1.dbf'; set newname for datafile 15 to '/database2/9i/oradata/orcl1/UNDOTBS11.dbf';
set newname for datafile 16 to '/database2/9i/oradata/orcl1/undotbs05.dbf';
set newname for datafile 17 to '/database2/9i/oradata/orcl1/undotbs02.dbf'; set newname for datafile 18 to '/database2/9i/oradata/orcl1/database2dacr.ora';
set newname for datafile 19 to '/database2/9i/oradata/orcl1/P_NEW_DATA1.ora'; set newname for datafile 20 to '/database2/9i/oradata/orcl1/P_INDEX.ora'; set newname for datafile 21 to '/database2/9i/oradata/orcl1/P_TEMP.ora'; set newname for datafile 22 to '/database2/9i/oradata/orcl1/ntiis.ora'; set newname for datafile 23 to '/database2/9i/oradata/orcl1/ntiis_2.ora'; set newname for datafile 24 to '/database2/9i/oradata/orcl1/ntiis_index.ora'; set newname for datafile 25 to '/database2/9i/oradata/orcl1/ntiis_12_1.ora'; set newname for datafile 26 to '/database2/9i/oradata/orcl1/ntiis_12_2.ora'; set newname for datafile 27 to '/database2/9i/oradata/orcl1/ntiis_index_12_1.ora'; set newname for datafile 28 to '/database2/9i/oradata/orcl1/ntiis_index_12_2.ora'; set newname for datafile 29 to '/database2/9i/oradata/orcl1/ntiis_3.dbf'; set newname for datafile 30 to '/database2/9i/oradata/orcl1/ntiis_4.dbf'; set newname for datafile 31 to '/database2/9i/oradata/orcl1/ntiis_5.dbf'; set newname for datafile 32 to '/database2/9i/oradata/orcl1/ntiis_6.dbf'; set newname for datafile 33 to '/database2/9i/oradata/orcl1/ntiis_7.dbf'; set newname for datafile 34 to '/database2/9i/oradata/orcl1/ntiis_8.dbf'; set newname for datafile 35 to '/database2/9i/oradata/orcl1/ntiis_9.dbf';
~专业好文档为您搜集整理~谢谢使用~
~专业好文档为您搜集整理~谢谢使用~
set newname for datafile 36 to '/database2/9i/oradata/orcl1/ntiis_10.dbf'; set newname for datafile 37 to '/database2/9i/oradata/orcl1/ntiis_11.dbf'; set newname for datafile 38 to '/database2/9i/oradata/orcl1/ntiis_12.dbf'; set newname for datafile 39 to '/database2/9i/oradata/orcl1/ntiis_13.dbf'; set newname for datafile 40 to '/database2/9i/oradata/orcl1/ntiis_14.dbf'; set newname for datafile 41 to '/database2/9i/oradata/orcl1/ntiis_index_1.ora'; set newname for datafile 42 to '/database2/9i/oradata/orcl1/ntiis_index_2.ora'; set newname for datafile 43 to '/database2/9i/oradata/orcl1/ntiis_15.dbf';
set newname for datafile 44 to '/database2/9i/oradata/orcl1/P_NEW_DATA2.ora'; set newname for datafile 45 to '/database2/9i/oradata/orcl1/ntiis_index_3.ora'; set newname for datafile 46 to '/database2/9i/oradata/orcl1/ntiis_12_3.ora'; set newname for datafile 47 to '/database2/9i/oradata/orcl1/IV_DATA1.ora'; set newname for datafile 48 to '/database2/9i/oradata/orcl1/IV_DATA2.ora'; set newname for datafile 49 to '/database2/9i/oradata/orcl1/IV_INDEX1.ora'; set newname for datafile 50 to '/database2/9i/oradata/orcl1/IV_INDEX2.ora'; set newname for datafile 51 to '/database2/9i/oradata/orcl1/IV_USER1.ora'; set newname for datafile 52 to '/database2/9i/oradata/orcl1/ntiis_index_4.ora'; set newname for datafile 53 to '/database2/9i/oradata/orcl1/ntiis_index_5.ora'; set newname for datafile 54 to '/database2/9i/oradata/orcl1/ntiis_16.dbf'; set newname for datafile 55 to '/database2/9i/oradata/orcl1/ntiis_17.dbf'; set newname for datafile 56 to '/database2/9i/oradata/orcl1/ntiis_18.dbf'; set newname for datafile 57 to '/database2/9i/oradata/orcl1/ntiis_19.dbf'; set newname for datafile 58 to '/database2/9i/oradata/orcl1/ntiis_20.dbf'; set newname for datafile 59 to '/database2/9i/oradata/orcl1/ntiis_12_4.ora';
~专业好文档为您搜集整理~谢谢使用~
~专业好文档为您搜集整理~谢谢使用~
set newname for datafile 60 to '/database2/9i/oradata/orcl1/ntiis_12_5.ora'; set newname for datafile 61 to '/database2/9i/oradata/orcl1/ntiis_12_6.ora'; set newname for datafile 62 to '/database2/9i/oradata/orcl1/ntiis_21.dbf'; set newname for datafile 63 to '/database2/9i/oradata/orcl1/ntiis_22.dbf'; set newname for datafile 64 to '/database2/9i/oradata/orcl1/ntiis_23.dbf'; set newname for datafile 65 to '/database2/9i/oradata/orcl1/ntiis_24.dbf'; set newname for datafile 66 to '/database2/9i/oradata/orcl1/ntiis_25.dbf'; set newname for datafile 67 to '/database2/9i/oradata/orcl1/ntiis_index_6.ora'; set newname for datafile 68 to '/database2/9i/oradata/orcl1/ntiis_index_7.ora';
set newname for datafile 69 to '/database2/9i/oradata/orcl1/undotbs06.dbf'; set newname for datafile 70 to '/database2/9i/oradata/orcl1/undotbs07.dbf';
set newname for datafile 71 to '/database2/9i/oradata/orcl1/undotbs08.dbf';
set newname for datafile 72 to '/database2/9i/oradata/orcl1/undotbs09.dbf'; set newname for datafile 73 to '/database2/9i/oradata/orcl1/ACCi_DATA_1.dbf'; set newname for datafile 74 to '/database2/9i/oradata/orcl1/ACCi_DATA_2.dbf'; set newname for datafile 75 to '/database2/9i/oradata/orcl1/ACCi_DATA_3.dbf'; set newname for datafile 76 to '/database2/9i/oradata/orcl1/ACCi_DATA_4.dbf'; set newname for datafile 77 to '/database2/9i/oradata/orcl1/ACCi_DATA_5.dbf'; set newname for datafile 78 to '/database2/9i/oradata/orcl1/ntiis_index_8.ora'; set newname for datafile 79 to '/database2/9i/oradata/orcl1/ntiis_index_9.ora';
set newname for datafile 80 to '/database2/9i/oradata/orcl1/P_NEW_DATA3.ora'; set newname for datafile 81 to '/database2/9i/oradata/orcl1/ntiis_27.dbf'; set newname for datafile 82 to '/database2/9i/oradata/orcl1/ntiis_28.dbf'; set newname for datafile 83 to '/database2/9i/oradata/orcl1/ntiis_12_7.ora';
~专业好文档为您搜集整理~谢谢使用~
某政府部门ORACLE数据库系统数据迁移实施报告
