https://community.esri.com/t5/geodatabase-questions/copy-data-to-new-oracle-data-base/m-p/1126932#M7470 <P>it's been awhile since we did this and my Oracle administrator probably remembers better, but I think we took a backup of the database on the old server and restored it on the new server, then did the Oracle upgrade, followed by the Geodatabase upgrade (do not forget to put the correct version of the shape library if using ESRI ST geometry on the new server).&nbsp; Also our Oracle administrator handled the TNS file update so our existin .sde connection files, layers, and MXDs were stable.&nbsp; Sorry, that isn't much detail.</P><P>I am primarily the SDE or geodatabase administrator and before we started made sure to compress the geodatabase versions down as much as possible by synchronizing all replicas and getting old versions removed or reconciled &amp; posted to minimize size of delta tables</P> Thu, 16 Dec 2021 21:06:01 GMT Steve_Salas 2021-12-16T21:06:01Z https://community.esri.com/t5/geodatabase-questions/copy-data-to-new-oracle-data-base/m-p/1124775#M7457 <P>Hi,</P><P>We are planning to install geodatabase 10.8.1 on Oracle 19c in new server. so we need to copy existing data(complete data) from old server ( geodatabase 10.2.1&nbsp; is in Oracle 11g) to new server.</P><P>can anyone guide me what would be best practice of copying data from old server to new server ?</P><P>OS: Linux 8.x version</P><P>&nbsp;</P><P>Thanks in Advance</P> Fri, 10 Dec 2021 08:52:32 GMT https://community.esri.com/t5/geodatabase-questions/copy-data-to-new-oracle-data-base/m-p/1124775#M7457 Tarunvisvanadula1994 2021-12-10T08:52:32Z https://community.esri.com/t5/geodatabase-questions/copy-data-to-new-oracle-data-base/m-p/1126932#M7470 <P>it's been awhile since we did this and my Oracle administrator probably remembers better, but I think we took a backup of the database on the old server and restored it on the new server, then did the Oracle upgrade, followed by the Geodatabase upgrade (do not forget to put the correct version of the shape library if using ESRI ST geometry on the new server).&nbsp; Also our Oracle administrator handled the TNS file update so our existin .sde connection files, layers, and MXDs were stable.&nbsp; Sorry, that isn't much detail.</P><P>I am primarily the SDE or geodatabase administrator and before we started made sure to compress the geodatabase versions down as much as possible by synchronizing all replicas and getting old versions removed or reconciled &amp; posted to minimize size of delta tables</P> Thu, 16 Dec 2021 21:06:01 GMT https://community.esri.com/t5/geodatabase-questions/copy-data-to-new-oracle-data-base/m-p/1126932#M7470 Steve_Salas 2021-12-16T21:06:01Z