This would perform restore database using file copy method ( user managed backup restore )
source db name : SOURCEDB
target db name : TARGETDB
1.In target server,create all the necessary folder path in mount points,where you want to put datafiles
mkdir /x01/oradata/TARGETDB
mkdir /x02/oradata/TARGETDB
mkdir $oracle_home/TARGETDB/adump
2.copy all the user managed backup files (datafiles,controlfiles etc) to above paths.( you can get source database file paths using dba_data_file and log tables in source database)
3.get the pfile from source database and create new pfile for target database.
*.db_name='SOURCEDB' -- keep this as it is, until you rename the target database name this can't change
*.db_unique_name='TARGETDB' -- change this to taget database name
4.. oraenv and set ORACLE_SID=TARGETDB
sql>startp nomount;
sql>alter database mount;
5. now rename datafile,log file older paths to new locations
alter database rename file '/x02/oradata/SOURCEDB/ERP_index.dbf' to '/x02/oradata/TARGETDB/ERP_index.dbf';
alter database rename file '/x02/oradata/SOURCEDB/ERP_data.dbf' to '/x02/oradata/TARGETDB/ERP_data.dbf';
alter database rename file '/x02/oradata/SOURCEDB/users01.dbf' to '/x02/oradata/TARGETDB/users01.dbf';
alter database rename file '/x02/oradata/SOURCEDB/sysaux01.dbf' to '/x02/oradata/TARGETDB/sysaux01.dbf';
alter database rename file '/x02/oradata/SOURCEDB/undotbs01.dbf' to '/x02/oradata/TARGETDB/undotbs01.dbf';
alter database rename file '/x02/oradata/SOURCEDB/system01.dbf' to '/x02/oradata/TARGETDB/system01.dbf';
alter database rename file '/x02/oradata/SOURCEDB/temp01.dbf' to '/x02/oradata/TARGETDB/temp01.dbf';
alter database rename file '/x01/oradata/SOURCEDB/redo013.log' to '/x01/oradata/TARGETDB/redo013.log';
alter database rename file '/x02/oradata/SOURCEDB/redo023.log' to '/x02/oradata/TARGETDB/redo023.log';
alter database rename file '/x02/oradata/SOURCEDB/redo033.log' to '/x02/oradata/TARGETDB/redo033.log';
alter database rename file '/x01/oradata/SOURCEDB/redo012.log' to '/x01/oradata/TARGETDB/redo012.log';
alter database rename file '/x02/oradata/SOURCEDB/redo022.log' to '/x02/oradata/TARGETDB/redo022.log';
alter database rename file '/x02/oradata/SOURCEDB/redo032.log' to '/x02/oradata/TARGETDB/redo032.log';
alter database rename file '/x01/oradata/SOURCEDB/redo011.log' to '/x01/oradata/TARGETDB/redo011.log';
alter database rename file '/x02/oradata/SOURCEDB/redo021.log' to '/x02/oradata/TARGETDB/redo021.log';
alter database rename file '/x02/oradata/SOURCEDB/redo031.log' to '/x02/oradata/TARGETDB/redo031.log';
6.sql> alter database open;
7. But still database name shown as source database name ( SOURCEDB)
use the follwing utility to rename the database name
$ nid -- oracle provided utility to rename the database name.
