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.

  • 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

  • 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

  • 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