ORACLE 10G 迁移至ASM过程小结

迁移在两台虚拟机上进行

/**

*为了方便，在开始前直接创建了TEST2数据库在ASM上，即TEST2是一个运*行的ASM上的空数据库，这样，步骤中的修改pfile的步骤可不进行，直接备份出来即可。

*/

源机：WINDOWS SERVER2003 sp2 32bit

文件管理：OS管理

SQL> select * from v$version where rownum<2;

SQL> select name,log_mode from v$database;

模拟一个环境

SQL>create tablespace test1_space datafile ‘c:/temp/test1_space01.dbf’ size 50M autoextend on next 50M maxsize 200M;
SQL>create table test1_table tablespace test1_space as select * from v$datafile;

目的机：WINDOWS SERVER2003 sp2 32bit

文件管理：ASM管理

SQL> select * from v$version where rownum<2;

SQL> select name,log_mode from v$database;

1、空间准备

源机数据库已占用的空间

SQL> select sum(bytes)/1024/1024 size_mb from dba_segments;

查看目的机ASM剩余空间

C:\>set ORACLE_HOME= C:\oracle\product\10.2.0\db_1
C:\>set ORACLE_SID=+ASM
C:\>asmcmd
ASMCMD>du
ASMCMD>lsdg

2、  配置参数文件

1) 源机上执行

SQL> create pfile='c:/temp/inittest1.ora' from spfile;

2) 目标上执行

SQL> create pfile='c:/temp/inittest1.ora' from spfile;

3) 按照目标机的格式修改源机的pfile

改前的源机pfile（inittest1.ora）

test1.__db_cache_size=306184192

test1.__java_pool_size=4194304

test1.__large_pool_size=4194304

test1.__shared_pool_size=130023424

test1.__streams_pool_size=0

*.audit_file_dest='C:\oracle\product\10.2.0/admin/test1/adump'

*.background_dump_dest='C:\oracle\product\10.2.0/admin/test1/bdump'

*.compatible='10.2.0.1.0'

*.control_files='C:\test1\test1\control01.ctl','C:\test1\test1\control02.ctl','C:\test1\test1\control03.ctl'

*.core_dump_dest='C:\oracle\product\10.2.0/admin/test1/cdump'

*.db_block_size=8192

*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_name='test1'

*.db_recovery_file_dest='\test1\fra'

*.db_recovery_file_dest_size=2147483648

*.dispatchers='(PROTOCOL=TCP)(SERVICE=test1XDB)'

*.job_queue_processes=10

*.log_archive_format='ARC%S_%R.%T'

*.nls_language='AMERICAN'

*.nls_territory='CHINA'

*.open_cursors=300

*.pga_aggregate_target=149946368

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=450887680

*.undo_management='AUTO'

*.undo_tablespace='UNDOTBS1'

*.user_dump_dest='C:\oracle\product\10.2.0/admin/test1/udump'

改前的目标机pfile（inittest2.ora）

test2.__db_cache_size=398458880

test2.__java_pool_size=4194304

test2.__large_pool_size=4194304

test2.__shared_pool_size=197132288

test2.__streams_pool_size=0

*.audit_file_dest='C:\oracle\product\10.2.0/admin/test2/adump'

*.background_dump_dest='C:\oracle\product\10.2.0/admin/test2/bdump'

*.compatible='10.2.0.1.0'

*.control_files='+DATA_GROUP/test2/controlfile/current.260.822592045','+LOG_GROUP/test2/controlfile/current.256.822592045'

*.core_dump_dest='C:\oracle\product\10.2.0/admin/test2/cdump'

*.db_block_size=8192

*.db_create_file_dest='+DATA_GROUP'

*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_name='test2'