Copy data to new oracle data base

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

Hi,

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
Steve_Salas
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