使用RMAN将文件系统迁移到ASM

1，全备数据库PRODrun{
allocate channel c1 device type disk;
allocate channel c2 device type disk;
backup tag "SH_DB" as compressed backupset format ‘/home/Oracle/full_%U.bak" database
include current controlfile;
backup tag "SH_ARCH" archivelog al format ‘/home/oracle/arch_%U.bak’l;
release channel c1;
release channel c2;
}2，确认控制文件的备份片
RMAN> list backup of control file;/home/oracle/full_03pkgtf4_1_1.bak3，导出pfile，将控制文件修改为+DATA和+FRASYS@PROD >create pfile="/home/oracle/prodpfile" from spfile;[oracle@single ~]$ vi /home/oracle/prodpfile*.audit_file_dest="/u01/admin/PROD/adump"
*.audit_trail="db"
*.compatible="11.2.0.4.0"
##*.control_files="/u01/oradata/PROD/control01.ctl","/u01/fast_recovery_area/PROD/control02.ctl"
*.control_files="+DATA/PROD/controlfile/control01.ctl","+FRA/PROD/controlfile/control02.ctl"
*.db_block_size=8192
*.db_create_file_dest="+DATA"
*.db_domain=""
*.db_name="PROD"
##*.db_recovery_file_dest="/u01/fast_recovery_area"
*.db_recovery_file_dest="+FRA"
*.db_recovery_file_dest_size=4385144832
*.diagnostic_dest="/u01"
*.dispatchers="（PROTOCOL=TCP）（SERVICE=PRODXDB）"
*.log_archive_format="%t_%s_%r.dbf"
*.memory_target=583008256
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile="EXCLUSIVE"
*.undo_tablespace="UNDOTBS1"4，删除PROD
SYS@PROD >startup force mount restrict;SYS@PROD >drop database;5，创建灾备端所需目录（DBCA删除数据库需要此步骤）
mkdir -p $ORACLE_BASE/admin/PROD/adump6，创建数据库密码文件（DBCA删除数据库需要此步骤）
orapwd file=$ORACLE_HOME/dbs/orapwPROD password=oracle entries=5 force=y7，采用修改过的pfile启动到nomount
$ sqlplus / as sysdbaSYS@PROD >startup nomount pfile=/home/oracle/pfile;8，将spfile文件创建到+DATA目录下，利用Oracle11g新特性from memorySYS@PROD >create spfile="+DATA/PROD/spfilePROD.ora" from memory;9，创建一个pfile来指向spfile。将红色字体内容填写在vi创建的pfile文件中。在Oracle11g中安装过集群软件都需要这样配置，无论是单实例ASM还是RAC+ASMSYS@PROD >！vi $ORACLE_HOME/dbs/initPROD.oraSPFILE="+DATA/PROD/spfilePROD.ora’10，恢复控制文件到+DATARMAN> startup force nomount;RMAN> restore controlfile from "/home/oracle/full_03pkgtf4_1_1.bak";11，启动到mountRMAN> mount database;12，识别备份集
RMAN> catalog start with "/home/oracle/";13，恢复数据库，注意关键词set newname 和 switch datafile all是迁移文件系统到ASM的关键。run{
set newname for datafile 1 to "+DATA";
set newname for datafile 2 to "+DATA";
set newname for datafile 3 to "+DATA";
set newname for datafile 4 to "+DATA";
set newname for tempfile 1 to "+DATA";
restore database;
switch datafile all;
recover database;
}14，更改联机日志路径为+DATASYS@PROD >alter database rename file "/u01/oradata/PROD/redo01.log" to "+DATA";
SYS@PROD >alter database rename file "/u01/oradata/PROD/redo02.log" to "+DATA";
SYS@PROD >alter database rename file "/u01/oradata/PROD/redo03.log" to "+DATA";15，open resetlogs开库
SYS@PROD >alter database open resetlogs;16, 如果在set newname tempfile步骤不能成功的迁移tempfile使用下面的命令手工追加
SYS@PROD >alter tablespace temp add tempfile "+DATA" size 10m;
SYS@PROD >alter tablespace temp drop tempfile "/u01/oradata/PROD/temp01.dbf’;实验结束--------------------------------------推荐阅读 --------------------------------------RMAN 配置归档日志删除策略 http://www.linuxidc.com/Linux/2013-11/92670.htmOracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htmRMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htmRMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htmOracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm--------------------------------------分割线 --------------------------------------更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12本文永久更新链接地址