Copy data to new oracle data base

12-10-2021 12:51 AM
Labels (1)
New Contributor III


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  is in Oracle 11g) to new server.

can anyone guide me what would be best practice of copying data from old server to new server ?

OS: Linux 8.x version


Thanks in Advance

0 Kudos
1 Reply
Occasional Contributor

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).  Also our Oracle administrator handled the TNS file update so our existin .sde connection files, layers, and MXDs were stable.  Sorry, that isn't much detail.

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 & posted to minimize size of delta tables

0 Kudos