Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002
    Location
    The Netherlands - Zaandam
    Posts
    1

    Angry Unanswered: Point in time restore problems - Urgent please...

    Hi All,

    We use Informix 7.31UC7.
    When we do a cold full resore (onbar -r -f dbslist) everything goes fine and after an onmode -m we restored the complete database.
    But when we do a cold point-in-time restore (onbar -r -n 20 -f dbsfile) the restore fails at the moment that onbar starts to restore the logical logs.

    Please help !!

    Thanks in Advance,
    Maurice van īt Loo
    The Netherlands

    bar_act.log:

    2002-03-26 17:41:31 17202 15856 Completed cold level 0 restore llog.
    2002-03-26 17:41:31 17202 15856 Process 17202 15856 completed.
    2002-03-26 17:42:30 19920 15856 Completed cold level 0 restore catdbs.
    2002-03-26 17:42:30 19920 15856 Process 19920 15856 completed.
    2002-03-26 17:42:30 15856 28438 ERROR: Unable to start the logical restore: A Point-In-Time Logical Restore is only permitted during a Full Restore.
    DBSpace 'blob_preview' was not recovered during this restore..
    2002-03-26 17:42:30 15856 28438 SQL -408 Invalid message type received from the sqlexec process.
    2002-03-26 17:42:31 15856 28438 SQL -27002 No connections are allowed in Dynamic Server quiescent mode.
    2002-03-26 17:42:33 15856 28438 SQL -27002 No connections are allowed in Dynamic Server quiescent mode.
    2002-03-26 17:42:35 15856 28438 SQL -27002 No connections are allowed in Dynamic Server quiescent mode.

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Located in the onbar release notes:

    43039 ERROR: Unable to start the logical restore: <error_text>.

    Retry the logical restore. If it fails again, contact Informix
    Technical Support for assistance.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •