This content has been marked as final. Show 5 replies
Since you are using Oracle 11 you can use Active duplicate : ( Complete step by step )
I'll check my notes for another method.
I also have this which you would have to change to use with remote, but most of it still applys :
Edited by: mseberg on Oct 13, 2012 12:06 PM
You can refer this document http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmdupdb.htm which explains you two methods of duplication.
You can go with the "active database duplication" which does not require you to take the backup of database on machine 1, but since you have already taken it, you can go with "backup based duplication". Both these methods are explained in detail in the document I mentioned above.
To copy the backup from Machine 1 to Machine 2, you could either use
a. Tape Backups -- have the system administrator copy the folder from Machine 1 to tape and then restore to Machine 2
b. FTP or SFTP -- have the system administrator enable the FTP services on Machine 2 so that Machine 1 can use the FTP or SFTP client to copy the files across.
In either case, you need to have the filesystem on Machine 2 created first. The system administrator can create the file system.
Hemant K Chitale