• State Verified Answer
  • Replies replies
    15
  • Subscribers subscribers
    8
  • Views views
    113
  • Users 0 members are here
Related Discussions
Options

Omnidbutil -readdb import error on test server 7.03

MigrationDeletedUser
over 7 years ago

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

    0
    over 7 years ago

    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)

  • 0
    over 7 years ago in reply to MigrationDeletedUser

    Hi igor, 

     

     

  • 0
    over 7 years ago in reply to MigrationDeletedUser

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

  • 0
    over 7 years ago in reply to MigrationDeletedUser

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

  • 0
    over 7 years ago in reply to MigrationDeletedUser

    Hi,

     

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

     

     

    Regards,

    Janez

  • 0
    over 7 years ago in reply to JanezST
    Should i also issue omnitrig -stop on test server for preventing jobs start with schedule on test server?
  • 0
    over 7 years ago in reply to JanezST
    Should i also issue omnitrig -stop on test server for preventing jobs start with schedule on test server?
  • 0
    over 7 years ago in reply to JanezST
    Should i also issue omnitrig -stop on test server for preventing jobs start with schedule on test server?
  • 0
    over 7 years ago in reply to MigrationDeletedUser
    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
  • 0
    over 7 years ago in reply to MigrationDeletedUser

    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
  • 0
    over 7 years ago in reply to MigrationDeletedUser

    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

Resources

Support
Documentation
Training
Partner Portal
Contact us
Compliance
Help
Company
Privacy Policy
Terms of Use
Accessibility
Anti-Slavery Statement
Support
How To Buy
Careers
Investor Relations
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.