4 Replies Latest reply on Jul 5, 2016 6:17 AM by David Miller

    Moving Oracle GeoDB to a new server

    Jason Jones

      We are upgrading our Database server and cleaning out old data etc.. so rather than doing a full database backup and restore we are taking the approch of moving over the data (Feature Classes, annotation etc...) to the new database by using the simple drag and drop.  This is working however there apears to be some odd issues that we are seeing that we are thinking could be related to ArcFM.  For example the new database (using ArcCatalog) looking at the Models Name tab shows some drop down options whereas the original GeoDatabase shows "Models Names do not apply to the selected item"  We are also noticing some auto-renaming of one of our CV domains.  I just wanted to know if there are any documenation for the proper proceedure moving Data between GeoDBs (we are using ArcFM 10.0.2.7217) and ArcGis 10.0 SP2 (and same ver on our ArcSDE)  Do we need to create or establish/Upgrade an ArcFM DB first or after?

       

      thanks

       

      Jason

        • Re: Moving Oracle GeoDB to a new server
          David Miller

          When we move data between our Oracle databases, we've done it a few different ways: backup and restore, Oracle datapump, copy/paste, and we currently use Oracle database cloning.

           

          The copy/paste method of moving data can work, but realize a lot of stuff will end of changing.  Most notably, the Feature ClassIDs and the ObjectIDs on everything because you are essentially recreating the data.  If you have nothing that references this type of data, then you won't really care.

           

          For copy/paste, you'll want to do roughly the following as the database or data owner (depending on how you structured your data):

           

          On the "old" database:

            1. Do a full "ArcFM XML Export" (checking every option) of all the entire database: ArcFM Tools in ArcCatalog
            2. Export all the ArcFM Favorites: ArcFM Tools in ArcCatalog
            3. Someone from SE can comment on this, but I would NOT copy any of the "MM_" tables from one database to the other.

           

          On the "new" database, once you get all the data copied over:

            1. Run the "Create ArcFM Solution Systems Tables" to recreate all the "MM_" tables: ArcFM Tools in ArcCatalog
            2. Run the "Upgrade ArcFM Solution Database" tool: ArcFM Tools in ArcCatalog
            3. "Register as Versioned" all the datasets and tables that were previously versioned in the old database, or else you won't be able to edit.
            4. Run the "ArcFM Solution Object Converter" tool on all the datasets and tables that ArcFM is needed for.
            5. Run "ArcFM XML Import" and choose the option to "Overwrite": ArcFM Tools in ArcCatalog
            6. Import your ArcFM Favorites: ArcFM Tools in ArcCatalog
            7. Reassign user rights/roles as needed.

           

          You'll really want to do this with no users connected to the database, all versions reconciled/posted, and the database compressed...otherwise you could lose some peoples' edits.

            • Re: Moving Oracle GeoDB to a new server
              Tim Szekely

              David is right, don't copy the "MM" tables from the old database.  Use the "Create/Update ArcFM system tables" tool from ArcCatalog for this (just as you said in step #1).

               

              A couple of things - be mindful of the method used to move the data.  Copy/Paste is actually recommended.  Using ArcCatalog's "Export..." to move some data from one database into another may change objectID's and/or GlobalID's, which will cause problems if these values are saved for use as the basis of a relationship class.

               

              Also, for exporting/importing ArcFM settings (via the ArcFM XML Export/Import) make sure to do this with like versions of ArcFM - e.g., don't export settings from a database at an older ArcFM release, and import them into a database at a newer ArcFM release. 

              • Re: Moving Oracle GeoDB to a new server
                Adrienne Judd

                Hey David Miller

                 

                One little note: in the new database, after creating the MM system tables (as SDE), be sure to grant permissions to the data owner user against the MM tables.  Otherwise, when you try to upgrade (as data owner), you get a message something like the following:

                 

                Some or all of the ArcFM Solution System tables have not been created.

                 

                The rest of the message asks you to run Create/Update again.  The message can send people into a bit of a loop.

                  • Re: Moving Oracle GeoDB to a new server
                    David Miller

                    Hey Adrienne Judd !

                     

                    There is a way around what you are talking about.  We have our system tables owned by SDE and a different user owns all the data.  It makes for a slightly different upgrade process:

                     

                    1.  As user SDE, run the "Create ArcFM Solution Systems Tables" tool

                    2.  As the data owner, make a public version off of SDE.DEFAULT

                    3.  As the data owner, run the "Upgrade ArcFM Solution Database" tool.

                    4.  Reconcile and Post the data owner version and delete.

                    5.  As the data owner against SDE.DEFAULT, run the "ArcFM Solution Object Converter" tool against the entire database.

                     

                    That method has worked for us for the last 15 years for the ArcFM upgrades.