Re: Migration R12.1.3 to new server

Posted by ErmanArslansOracleBlog on Sep 23, 2022; 2:40pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Migration-R12-1-3-to-new-server-tp11083p11095.html

Just copy your oracle home from PROD to CLONE. Relink it on CLONE. if -- if necessary. if you directory structure changes..
Just use RMAN duplicate to clone your database from PROD to CLONE. RMAN will open the database in CLONE with resetlogs, but this resetlogs operation will be on newly created clone (namely CLONE) and it will not affect your production (namely PROD)

There are different duplicate options (duplicate from backup, from your active db and so on..)
See RMAN Documentation for this.

Here is document if you want to do a backup based RMAN duplicate -> Perform Backup Based RMAN DUPLICATE Without Connecting To Target Database For Both Disk & Tape Backups (Doc ID 1375864.1)