Move Oracle Database from one machine to another machine using RMAN

1. Take full backup of database on target , create pfile from spfile.

2. Move backup pieces and pfile to restoration machine.

3.Make necessary changes in pfile (paths according to new server like controlfiles,archivelog locations ) & place it on $ORACLE_HOME/dbs location.

4.startup nomount with pfile & create spfile from pfile shut down DB and startup nomount with spfile.

5.connect to rman

rman target /

6.create controlfile from backup

rman>restore controlfile from '/location/.bkp';

7. start the database in mount state.

sql> startup mount

8. Restore and recover the database from backup
rman> run {
catalog start with '/backup location/';
set newname for database to '/new database files location/%b';
restore database;
switch datafile all;
recover database;
}

9.Rename the all redo logs.

sql>select member from v$logfile;
sql>alter database rename file '/old location/redo03.log' to '/new location/redo03.log';

10. Open database in resetlogs.

sql>alter database open resetlogs;

11. Create temporary tablespace and make it default to database.

sql>create temporary tablespace temp1 tempfile '/location/temp02.dbf' size 100m autoextend on next 100m maxsize unlimited;

sql>alter database default temporary tablespace temp1;