1、先在源端做一次完整的数据库备份包括控制文件、归档日志，并把备份拷在目标端服务器的相同路径下；


2、在源端执行create pfile ='/home/oracle/app/oracle/product/11.2.0/dbhome_1/pfile_orcl.ora' from spfile;
   修改相关路径参数保持源端与目标端的路径相同，可在目标端创建相关目录使得路径相同


3、在目标端执行createspfile from pfile ='/home/oracle/app/oracle/product/11.2.0/dbhome_1/pfile_orcl.ora';


4、startup nomount状态，然后在rman中恢复控制文件;


5、restore database，如果在参数文件中制定了数据文件转换路径应该不会出现找不到路径，无法创建数据文件的问题；
   出现无法创建数据文件的问题，在rman中执行下列语句，转换数据文件   
run{ 
set newname for datafile 1 to '/home/oracle/app/oracle/oradata/biketo/backup/system01';
set newname for datafile 2 to '/home/oracle/app/oracle/oradata/biketo/backup/sysaux01';
set newname for datafile 3 to '/home/oracle/app/oracle/oradata/biketo/backup/undotbs01';
set newname for datafile 4 to '/home/oracle/app/oracle/oradata/biketo/backup/users01';
set newname for datafile 5 to '/home/oracle/app/oracle/oradata/biketo/backup/testdata01';
set newname for datafile 6 to '/home/oracle/app/oracle/oradata/biketo/backup/app01';
set newname for datafile 7 to '/home/oracle/app/oracle/oradata/biketo/backup/PUB_LOB_SPACE';
set newname for datafile 8 to '/home/oracle/app/oracle/oradata/biketo/backuptbs_tmp';
restore database;
switch datafile all;}


6、recover database


7、alter database open 会出现与5相同的问题，找不到联机重做日志文件的路径，在rman中执行下列语句，转换路径


alter database rename file '/u01/app/oradata/biketo/backup/redolog1a.rdo' to '/home/oracle/app/oracle/oradata/biketo/backup/redolog1a.rdo';


alter database rename file '/u01/app/oradata/biketo/backup/redolog1b.rdo' to '/home/oracle/app/oracle/oradata/biketo/backup/redolog1b.rdo';


alter database rename file '/u01/app/oradata/biketo/backup/redolog2a.rdo' to '/home/oracle/app/oracle/oradata/biketo/backup/redolog2a.rdo';


alter database rename file '/u01/app/oradata/biketo/backup/redolog2b.rdo' to '/home/oracle/app/oracle/oradata/biketo/backup/redolog2b.rdo';


8、如果是64位迁移到32位机器会出现ORA-06553: PLS-801: internal error [56319]的错误
按照以下步骤可解决
1、Shutdown immediate
2、startup migrate
注：startup migrate表示降级，在9i，无论升级/降级 数据库都是startup migrate；
10g后增加了upgrade参数，升级可直接用startup upgrade，降级仍是startup migrate.
3、@$ORACLE_HOME/rdbms/admin/utlirp.sql;
4、Shutdown immediate
5、Startup
6、@$ORACLE_HOME/rdbms/admin/utlrp.sql;
7、Shutdown immediate
8、Startup




9,要重建临时表空间，因为备份的时候不会备份临时表空间
CREATE TEMPORARY TABLESPACE temp TEMPFILE '/home/oracle/app/oracle/oradata/biketo/backup/temp.dbf' SIZE 1024 m AUTOEXTEND ON NEXT 10 m MAXSIZE UNLIMITED;


ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp;


DROP TABLESPACE temptbs01 INCLUDING CONTENTS AND DATAFILES;