将oracle从文件系统迁移到ASM.docVIP

将oracle从文件系统迁移到ASM 将oracle从文件系统迁移到ASM 环境一：Windows XP、oracle 10g 1、使用dbca创建ASM实例并创建密码文件 C:\Documents and Settings\jiangyong orapwd file=D:\oracle\product\10.2.0\db_1\database\PWD+asm.ora password=sys entries=5 2、创建asm磁盘 C:\Documents and Settings\jiangyong asmtool -create D:\oracle\asmdisk\disk1 2048M C:\Documents and Settings\jiangyong asmtool -create D:\oracle\asmdisk\disk2 2048M C:\Documents and Settings\jiangyong asmtool -create D:\oracle\asmdisk\disk3 2048M C:\Documents and Settings\jiangyong asmtool -create D:\oracle\asmdisk\disk4 2048M C:\Documents and Settings\jiangyong asmtool -create D:\oracle\asmdisk\disk5 2048M 3、创建css服务(用来连接asm和数据库进行通信的，单机环境下也需要CSS进程) C:\Documents and Settings\jiangyong localconfig add C:\Documents and Settings\jiangyong crsctl check cssd (检查创建的css是否正常启动) CSS appears healthy 4、修改相应的参数并重启实例 C:\Documents and Settings\jiangyong set ORACLE_SID=+ASM (要先使用dbca创建ASM实例才能登录) SQL alter system set _asm_allow_only_raw_disks=false scope=spfile; (为true时则必须使用裸设备来创建ASM磁盘) SQL alter system set asm_diskstring=D:\oracle\asmdisk\*; (定义实例启动时有哪些信誉好的足球投注网站可用的ASM磁盘的路径) SQL show parameter asm_diskgroups; SQL shutdown immediate; SQL startup open; 5、创建ASM磁盘组 SQL create diskgroup DG1 normal redundancy disk D:\oracle\asmdisk\disk1,D:\oracle\asmdisk\disk2,D:\oracle\asmdisk\disk3; (redundancy:High为3路镜像，Normal为2路镜像，External为不做镜像处理) SQL create diskgroup recovery normal redundancy disk D:\oracle\asmdisk\disk4,D:\oracle\asmdisk\disk5; SQL select path from v$asm_disk; SQL select name, total_mb, free_mb from v$asm_disk_stat; SQL select disk_number,total_mb,free_mb from v$asm_disk; SQL select name,state from v$asm_diskgroup; 6、备份原数据库 RMAN backup as copy database format +DG1; 7、修改原数据库相关参数 SQL alter system set db_recovery_file_dest_size=2g scope=both; SQL alter system set db_recovery_file_dest=+RECOVERY scope=both;