使用RMAN将文件系统中oracle 10g数据库文件迁移到ASM磁盘组。
文章分为三个部分:一、创建ASM磁盘组 二、切换数据文件到ASM 三、迁移临时文件、online log等到ASM
【实验环境】
操作系统 : AIX5.3
数据库版本:Oracle 10.2.0
存储设备 :SUN T3 光纤阵列
【文章目录】
![](http://img.blog.itpub.net/blog/attachment/201410/12/29475508_1413110318p8z7.jpg?x-oss-process=style/bb)
【实验过程】
4、RMAN热备数据文件
4.1、0级增量热备:
RMAN > run {
sql 'alter system archive log current';
allocate channel dev1 type disk;
backup as copy incremental level 0 database format '+DATA' TAG 'lxh_asm_migration';
sql 'alter system archive log current';
}
4.2、1级增量热备:SCN不一致
如果数据库较大、备份时间较长,可以再做一次1级增量热备。更新copy
run {
sql 'alter system archive log current';
allocate channel dev1 type disk;
backup incremental level 1 for recover of copy with tag 'lxh_asm_migration' database;
sql 'alter system archive log current';
}
4.3、refresh copy:SCN一致:1194421
![](http://img.blog.itpub.net/blog/attachment/201410/12/29475508_1413110699y3WX.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201410/12/29475508_14131107162T3A.jpg?x-oss-process=style/bb)
5、在ASM磁盘上创建SPFILE的copy
![](http://img.blog.itpub.net/blog/attachment/201410/12/29475508_1413110762w6VB.jpg?x-oss-process=style/bb)
6、备份控制文件以便需要时从ASM转回
RMAN> shutdown immediate;
RMAN> startup mount;
RMAN> backup as copy current controlfile format '/arch/pre-asm-controlfile.ctl';7、创建pfile指向asm spfile
![](http://img.blog.itpub.net/blog/attachment/201410/12/29475508_1413110901Uin8.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201410/12/29475508_14131109141Vhc.jpg?x-oss-process=style/bb)
可直接在$ORACLE_HOME/dbs下修改initprod.ora
编辑initprod.ora
[oracle@aix227:/u01/app/oracle/product/10.2.0/db_1/dbs]$more initprod.ora
SPFILE='+DATA/spfile'
[oracle@aix227:/u01/app/oracle/product/10.2.0/db_1/dbs]$
8、转储控制文件到ASM
8.1、修改参数中控制文件位置到ASM
![](http://img.blog.itpub.net/blog/attachment/201410/12/29475508_1413110991q7dJ.jpg?x-oss-process=style/bb)
8.2、重启到nomount转储控制文件
![](http://img.blog.itpub.net/blog/attachment/201410/12/29475508_1413111086DJ7M.jpg?x-oss-process=style/bb)
9、切换数据文件到ASM
RMAN> alter database mount;
9.1、切换前查看SCN
![](http://img.blog.itpub.net/blog/attachment/201410/12/29475508_141311123270WH.jpg?x-oss-process=style/bb)
9.2、switch database to copy;
![](http://img.blog.itpub.net/blog/attachment/201410/12/29475508_1413111297Y08y.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201410/12/29475508_14131113124Ecd.jpg?x-oss-process=style/bb)
9.3、切换完成查看SCN:datafile_header:1194421
![](http://img.blog.itpub.net/blog/attachment/201410/12/29475508_1413111382wyIC.jpg?x-oss-process=style/bb)
10、recover database
![](http://img.blog.itpub.net/blog/attachment/201410/12/29475508_14131114317oqF.jpg?x-oss-process=style/bb)
recover 过程中告警日志
Thu Aug 21 14:32:02 2014
alter database recover datafile list clear
Thu Aug 21 14:32:02 2014
Completed: alter database recover datafile list clear
Thu Aug 21 14:32:02 2014
alter database recover datafile list
1 , 2 , 3 , 4 , 5
Completed: alter database recover datafile list
1 , 2 , 3 , 4 , 5
Thu Aug 21 14:32:02 2014
alter database recover if needed
start
Media Recovery Start
parallel recovery started with 3 processes
Thu Aug 21 14:32:03 2014
Recovery of Online Redo Log: Thread 1 Group 3 Seq 151 Reading mem 0
Mem# 0 errs 0: /u01/app/oracle/oradata/prod/redo03.log
Thu Aug 21 14:32:04 2014
Recovery of Online Redo Log: Thread 1 Group 4 Seq 152 Reading mem 0
Mem# 0 errs 0: /u01/app/oracle/oradata/prod/redo04.log
Thu Aug 21 14:32:15 2014
Media Recovery Complete (prod)
Thu Aug 21 14:32:17 2014
Completed: alter database recover if needed
start
![](http://img.blog.itpub.net/blog/attachment/201410/12/29475508_1413111465d7SQ.jpg?x-oss-process=style/bb)
吕星昊
2014.10.12
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29475508/viewspace-1296464/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29475508/viewspace-1296464/