环境：
sys@ORCL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
sys@ORCL> !uname
Linux
⑴ 修改控制文件的位置
sys@ORCL> show parameter control_files
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string /u01/app/oracle/oradata/ORCL/c
ontrolfile/o1_mf_8050hgfp_.ctl
, /u01/app/oracle/flash_recove
ry_area/ORCL/controlfile/o1_mf
_8050hgqh_.ctl
sys@ORCL> alter database backup controlfile to '/home/oracle/ctlasm.ctl';
sys@ORCL> alter system set control_files='+WATER' scope=spfile;
sys@ORCL> shutdown immediate;
⑵ 数据文件迁移
RMAN> startup nomount
RMAN> restore controlfile from '/home/oracle/ctlasm.ctl';
RMAN> alter database mount;
RMAN> backup as copy database format '+WATER';
RMAN> recover database;
RMAN> switch database to copy;
⑶ 日志文件迁移
idle> conn / as sysdba
idle> alter database open resetlogs;
idle> alter database add logfile group 4 '+WATER/redo04.log' size 50m;
idle> alter database add logfile group 5 '+WATER/redo05.log' size 50m;
idle> alter database add logfile group 6 '+WATER/redo06.log' size 50m;
idle> select group#,status from v$log;
GROUP# STATUS
---------- ----------------
1 UNUSED
2 CURRENT
3 UNUSED
4 UNUSED
5 UNUSED
6 UNUSED
idle> alter system switch logfile;
idle> alter system switch logfile;
idle> alter system switch logfile;
idle> select group#,status from v$log;
GROUP# STATUS
---------- ----------------
1 ACTIVE
2 ACTIVE
3 ACTIVE
4 ACTIVE
5 ACTIVE
6 CURRENT
idle> alter system checkpoint;
idle> alter database drop logfile group 1;
idle> alter database drop logfile group 2;
idle> alter database drop logfile group 3;
idle> select member from v$logfile;
MEMBER
----------------------------------------------------------------------------------------------------
+WATER/redo04.log
+WATER/redo05.log
+WATER/redo06.log
⑷ 临时文件迁移
sys@ORCL> select file_name,tablespace_name from dba_temp_files;
FILE_NAME TABLESPACE_NAME
----------------------------------------------------------------- ------------------------------
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_temp_8050j34j_.tmp TEMP
sys@ORCL> alter tablespace temp add tempfile '+WATER';
sys@ORCL> select file_name,tablespace_name from dba_temp_files;
FILE_NAME TABLESPACE_NAME
----------------------------------------------------------------- ------------------------------
+WATER/orcl/tempfile/temp.265.798479421 TEMP
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_temp_8050j34j_.tmp TEMP
sys@ORCL> alter tablespace temp drop tempfile '/u01/app/oracle/oradata/ORCL/datafile/o1_mf_temp_8050j34j_.tmp';
⑸ 修改db_create_file_dest，db_recovery_file_dest，db_recovery_file_dest_size 的值
sys@ORCL> alter system set db_create_file_dest='+WATER/ORCL/ORADATA' scope=spfile;
sys@ORCL> alter system set db_recovery_file_dest='+WATER' scope=spfile;
sys@ORCL> alter system set db_recovery_file_dest_size=1 G scope=spfile;
sys@ORCL> alter database backup controlfile to '+WATER'; --迁移时，只有一个控制文件
sys@ORCL> show parameter control
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string +WATER/orcl/controlfile/curren
t.256.798477831
⑹ 修改参数文件并迁移spfile
sys@ORCL> alter system set control_files='+WATER/ORCL/ORADATA/CONTROL01.CTL','+WATER/ORCL/ORADATA/CONTROL02.CTL' scope=spfile;
sys@ORCL> create spfile='+WATER/ORCL/spfileorcl.ora' from pfile;
[oracle@localhost dbs]$ rm -i spfileorcl.ora
[oracle@localhost dbs]$ vim initorcl.ora
[oracle@localhost dbs]$ tail -f initorcl.ora
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=139460608
*.processes=150
*.remote_login_passwordfile='NONE'
*.sga_target=418381824
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/orcl/udump'
SPFILE='+WATER/ORCL/spfileorcl.ora'
⑺ 检查ASM实例和数据库实例连接情况
ASMCMD> lsct
DB_Name Status Software_Version Compatible_version Instance_Name
orcl CONNECTED 10.2.0.1.0 10.2.0.1.0 orcl
小结：
第一次迁移时失败，原因是仅作学习之用，磁盘组空间太小，大家如果空间富裕，不妨慷慨些。