Omnidbutil -readdb import error on test server 7.03

Hi. I try today upgrade procedure from 7.03 to 8.1. Stuck at point 6, import IMDB on test server.

Command issued from cmd.exe window, Run As Administrator.

 

C:\Temp>omnidbutil -readdb -cdb c:\temp\cdb -mmdb c:\temp\mmdb

Database import will overwrite old database. All data will be lost!

Are you sure (y/n)?y

* Add 1 extension files for tablespace fnames.dat.

 

Command completes about 5 seconds, no IMDB import happened.

 

Export from production server wotj 7.03 Cell Manager is OK.

 

Please help.

Parents
  • Verified Answer

    To Import the Database your Target System has to have enough Space in its Tablespaces.

    The Message Indicates you have to add one fnames Datafile to continue.

    On Unix/Linux this would be:

    omnidbutil -extendfnames /var/opt/omni/server/db40/datafiles/cdb -maxsize 2047

    For Windows you will need to change the Path accordingly.

     

    Other Commands related to extending the IDB are:

    omnidbutil -add_dcdir /var/opt/omni/server/db40/dcbfX -maxsize 4096 -maxfiles 10000 -spacelow 100
    omnidbutil -extendtblspace fnX.ext /var/opt/omni/server/db40/datafiles/cdb -maxsize 2047

    Basically you need enough Space in the specific Data-Files as you used on your Source-Database.

    Similar thing applies to the DCBF-Folders, you need the same number of those on the Target. Otherwise you will need to let DP rescan everything to fix the relations (omnidbutil -remap_dcdir)

  • Hi igor, 

     

     

  • OK, i will try it tomorrow. Can you update Customer Advisory?

  • OK, i will try it tomorrow. Can you update Customer Advisory?

  • Hi,

     

    Yes we can update Customer Advisory but it may take several days.

     

     

    Regards,

    Janez

  • Should i also issue omnitrig -stop on test server for preventing jobs start with schedule on test server?
  • Should i also issue omnitrig -stop on test server for preventing jobs start with schedule on test server?
  • Should i also issue omnitrig -stop on test server for preventing jobs start with schedule on test server?
  • if you want to do other things as well it is recommended to turn omnitrig off. During Export/Import it will not be able to start anyway
  • In case it helps, here the Command-Sequence I usually use on one of my Cellserver

    Of course the values have to be adjusted to the specific environment.

     

    #Stop Jobs and clean IDB

    omnitrig -stop
    omnidb -strip
    omnidbutil -fixmpos
    omnidbutil -clear
    omnidbutil -purge_failed_copies
    omnidbutil -purge -sessions 14 -force
    omnidbutil -purge -days 14 -force
    omnidbutil -purge -messages 14 -force
    omnidbutil -purge -mpos -force
    omnidbutil -purge -dcbf -force
    omnidbutil -purge -daily -force
    omnidbutil -purge -filenames -force
    omnidbutil -fixmpos

    #IDB info for comparison
    omnidbutil -info
    omnidbutil -extendinfo

    #additional Backup-Copy in case Export/Import fails
    omnisv stop
    cp -Rp /var/opt/omni/server/db40 /omnidb/dbbackup/db40

    #Export of IDB Tablespaces and Copy of Binary Files
    omnisv start
    omnidbutil -writedb -mmdb /omnidb/dbexport/mmdb -cdb /omnidb/dbexport/cdb
    cp -Rp /var/opt/omni/server/db40/dcbf /omnidb/dbexport/dcbf
    cp -Rp /var/opt/omni/server/db40/dcbf1 /omnidb/dbexport/dcbf1
    cp -Rp /var/opt/omni/server/db40/dcbf2 /omnidb/dbexport/dcbf2
    cp -Rp /var/opt/omni/server/db40/msg /omnidb/dbexport/msg

    #deleting existing IDB Structure and replacing it with Template
    omnisv stop
    rm -r /var/opt/omni/server/db40/*
    cp -Rp /opt/omni/newconfig/var/opt/omni/server/db40/* /var/opt/omni/server/db40/
    omnisv start

    #Initalising IDB and adding additional Datafiles and DCBF Directories
    omnidbinit
    omnidbutil -add_dcdir /var/opt/omni/server/db40/dcbf1 -maxsize 4096 -maxfiles 10000 -spacelow 100
    omnidbutil -add_dcdir /var/opt/omni/server/db40/dcbf2 -maxsize 4096 -maxfiles 10000 -spacelow 100
    omnidbutil -extendfnames /var/opt/omni/server/db40/datafiles/cdb -maxsize 2047
    omnidbutil -extendfnames /var/opt/omni/server/db40/datafiles/cdb -maxsize 2047
    omnidbutil -extendfnames /var/opt/omni/server/db40/datafiles/cdb -maxsize 2047
    omnidbutil -extendtblspace fn1.ext /var/opt/omni/server/db40/datafiles/cdb -maxsize 2047
    omnidbutil -extendtblspace fn2.ext /var/opt/omni/server/db40/datafiles/cdb -maxsize 2047
    omnidbutil -extendtblspace fn3.ext /var/opt/omni/server/db40/datafiles/cdb -maxsize 2047
    omnidbutil -extendtblspace fn4.ext /var/opt/omni/server/db40/datafiles/cdb -maxsize 2047
    omnidbutil -chktblspace
    omnidbutil -modifytblspace

    #Importing IDB Data and copying back Binary Files
    omnidbutil -readdb -mmdb /omnidb/dbexport/mmdb -cdb /omnidb/dbexport/cdb
    cp -Rp /omnidb/dbexport/dcbf /var/opt/omni/server/db40/
    cp -Rp /omnidb/dbexport/dcbf1 /var/opt/omni/server/db40/
    cp -Rp /omnidb/dbexport/dcbf2 /var/opt/omni/server/db40/
    cp -Rp /omnidb/dbexport/msg /var/opt/omni/server/db40/

    #Restarting Servcies again to clear buffers and syncing CDB
    omnisv stop
    omnisv start
    omnidbutil –cdbsync

Reply
  • In case it helps, here the Command-Sequence I usually use on one of my Cellserver

    Of course the values have to be adjusted to the specific environment.

     

    #Stop Jobs and clean IDB

    omnitrig -stop
    omnidb -strip
    omnidbutil -fixmpos
    omnidbutil -clear
    omnidbutil -purge_failed_copies
    omnidbutil -purge -sessions 14 -force
    omnidbutil -purge -days 14 -force
    omnidbutil -purge -messages 14 -force
    omnidbutil -purge -mpos -force
    omnidbutil -purge -dcbf -force
    omnidbutil -purge -daily -force
    omnidbutil -purge -filenames -force
    omnidbutil -fixmpos

    #IDB info for comparison
    omnidbutil -info
    omnidbutil -extendinfo

    #additional Backup-Copy in case Export/Import fails
    omnisv stop
    cp -Rp /var/opt/omni/server/db40 /omnidb/dbbackup/db40

    #Export of IDB Tablespaces and Copy of Binary Files
    omnisv start
    omnidbutil -writedb -mmdb /omnidb/dbexport/mmdb -cdb /omnidb/dbexport/cdb
    cp -Rp /var/opt/omni/server/db40/dcbf /omnidb/dbexport/dcbf
    cp -Rp /var/opt/omni/server/db40/dcbf1 /omnidb/dbexport/dcbf1
    cp -Rp /var/opt/omni/server/db40/dcbf2 /omnidb/dbexport/dcbf2
    cp -Rp /var/opt/omni/server/db40/msg /omnidb/dbexport/msg

    #deleting existing IDB Structure and replacing it with Template
    omnisv stop
    rm -r /var/opt/omni/server/db40/*
    cp -Rp /opt/omni/newconfig/var/opt/omni/server/db40/* /var/opt/omni/server/db40/
    omnisv start

    #Initalising IDB and adding additional Datafiles and DCBF Directories
    omnidbinit
    omnidbutil -add_dcdir /var/opt/omni/server/db40/dcbf1 -maxsize 4096 -maxfiles 10000 -spacelow 100
    omnidbutil -add_dcdir /var/opt/omni/server/db40/dcbf2 -maxsize 4096 -maxfiles 10000 -spacelow 100
    omnidbutil -extendfnames /var/opt/omni/server/db40/datafiles/cdb -maxsize 2047
    omnidbutil -extendfnames /var/opt/omni/server/db40/datafiles/cdb -maxsize 2047
    omnidbutil -extendfnames /var/opt/omni/server/db40/datafiles/cdb -maxsize 2047
    omnidbutil -extendtblspace fn1.ext /var/opt/omni/server/db40/datafiles/cdb -maxsize 2047
    omnidbutil -extendtblspace fn2.ext /var/opt/omni/server/db40/datafiles/cdb -maxsize 2047
    omnidbutil -extendtblspace fn3.ext /var/opt/omni/server/db40/datafiles/cdb -maxsize 2047
    omnidbutil -extendtblspace fn4.ext /var/opt/omni/server/db40/datafiles/cdb -maxsize 2047
    omnidbutil -chktblspace
    omnidbutil -modifytblspace

    #Importing IDB Data and copying back Binary Files
    omnidbutil -readdb -mmdb /omnidb/dbexport/mmdb -cdb /omnidb/dbexport/cdb
    cp -Rp /omnidb/dbexport/dcbf /var/opt/omni/server/db40/
    cp -Rp /omnidb/dbexport/dcbf1 /var/opt/omni/server/db40/
    cp -Rp /omnidb/dbexport/dcbf2 /var/opt/omni/server/db40/
    cp -Rp /omnidb/dbexport/msg /var/opt/omni/server/db40/

    #Restarting Servcies again to clear buffers and syncing CDB
    omnisv stop
    omnisv start
    omnidbutil –cdbsync

Children
No Data