Re: Migration R12.1.3 to new server

Posted by satish on Sep 23, 2022; 1:57am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Migration-R12-1-3-to-new-server-tp11083p11092.html

Hi erman,

Is reset logs mandatory?We are following below steps.

1)tar the db oracle home in source and copy to target

2)untar the oracle home in target and run adcfgclone dbtechstack

3)shutdown the source and take in Mount state.Take rman cold backup and just copy the backup to new server

4)once step 2 completed(dbtechstack) we will start the instance in nomount and then issue below commands to restore and recover the database from backup

a)restore database

b)recover database(it's not required since using cold backup)

c)Since it is prod,will resetlogs have any impact?

Then post steps follows...like fnd_nodes cleanup,autoconfig etc..

Please correct me if i am wrong