PDA

View Full Version : Point in time restore problems - Urgent please...


Compare
03-27-02, 03:47
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.

rnealejr
04-01-02, 15:56
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.