If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > Point in time restore problems - Urgent please...

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-27-02, 02:47
Compare Compare is offline
Registered User
 
Join Date: Mar 2002
Location: The Netherlands - Zaandam
Posts: 1
Angry 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.
Reply With Quote
  #2 (permalink)  
Old 04-01-02, 14:56
rnealejr rnealejr is offline
Registered User
 
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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On