Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 1.  Database Restore Question

    Posted Wed February 05, 2020 12:54 PM
    Good day everyone,
    I'm having an issue while restoring a database, after issuing the  onbar_d -r -w -p at 5:29AM  it didn't connect to the storage manager and start restoring databases until 8:41AM.  Below are the relevant rows from the bar_ac.log.  Is there something I can run to get ride of this lag time?


    2020-01-31 05:29:42 25344 25342 /opt/informix/bin/onbar_d -r -w -p
    2020-01-31 05:33:38 25344 25342 Warning: The ixbar file is missing an entry for one or more logical logs. Last log id: 37560 Current log id: 54611
    2020-01-31 05:33:38 25344 25342 Warning: The ixbar file is missing an entry for one or more logical logs. Last log id: 55200 Current log id: 55202
    2020-01-31 05:33:38 25344 25342 Warning: The ixbar file is missing an entry for one or more logical logs. Last log id: 55681 Current log id: 55683
    2020-01-31 05:33:38 25344 25342 Warning: The ixbar file is missing an entry for one or more logical logs. Last log id: 56071 Current log id: 56073
    2020-01-31 05:33:38 25344 25342 Warning: The ixbar file is missing an entry for one or more logical logs. Last log id: 73698 Current log id: 73700
    2020-01-31 06:40:45 25344 25342 Successfully connected to Storage Manager.
    2020-01-31 06:40:46 25344 25342 Begin reserved pages restore (level 0 of rootdbs, Storage Manager copy ID: 606940 0).
    2020-01-31 06:40:46 25344 25342 Completed reserved pages restore (level 0 of rootdbs).
    2020-01-31 08:41:10 25344 25342 Successfully connected to Storage Manager.
    2020-01-31 08:41:10 25344 25342 Begin cold level 0 restore rootdbs (Storage Manager copy ID: 606940 0).
    2020-01-31 08:41:55 25344 25342 Completed cold level 0 restore rootdbs.
    2020-01-31 08:41:58 25475 25344 Process 25475 25344 successfully forked.
    2020-01-31 08:41:58 25476 25344 Process 25476 25344 successfully forked.
    2020-01-31 08:41:58 25475 25344 Successfully connected to Storage Manager.
    2020-01-31 08:41:58 25476 25344 Successfully connected to Storage Manager.
    2020-01-31 08:41:59 25475 25344 Begin cold level 0 restore gimdbs1 (Storage Manager copy ID: 606944 0).
    2020-01-31 08:41:59 25476 25344 Begin cold level 0 restore gtxlog1 (Storage Manager copy ID: 606942 0).
    2020-01-31 08:42:01 25476 25344 Completed cold level 0 restore gtxlog1.
    2020-01-31 08:42:01 25476 25344 Process 25476 25344 completed.
    2020-01-31 08:46:59 25475 25344 0x0532dbb pages of gimdbs1 have been restored.
    2020-01-31 08:52:00 25475 25344 0x0a1df7e pages of gimdbs1 have been restored.
    2020-01-31 08:57:01 25475 25344 0x0f89058 pages of gimdbs1 have been restored.
    2020-01-31 09:02:02 25475 25344 0x014c8147 pages of gimdbs1 have been restored

    ------------------------------
    John Henry
    ------------------------------

    #Informix


  • 2.  RE: Database Restore Question

    Posted Wed February 05, 2020 12:57 PM

    Look at the storage manager and see what it was doing ?

     

    Cheers

    Paul