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 > Unable to write restore data

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-03-03, 12:58
SGorman SGorman is offline
Registered User
 
Join Date: Apr 2003
Posts: 2
Red face Unable to write restore data

Hi I'm running a restore of my SAP database but I get the following error messages even though the file system is exactly the same on the DR box as on the one that was backed up. Does anybody have any ideas as to what my problem could be? Thanks.

2003-04-03 18:34:22 9593 6258 ERROR: Unable to write restore data to the datab
ase server: The chunk '/informix/CP1/sapdata/physdev55/data582' will not fit in
the space specified..
2003-04-03 18:34:22 9593 6258 WARNING: Skipped backup/restore of space 'psapco
ep'.
2003-04-03 18:34:24 9593 6258 Process 9593 6258 completed.
2003-04-03 18:34:24 6258 6257 The ON-Bar process 9593 exited with a problem (e
xit code 131 (0x83), signal -1).
2003-04-03 18:35:37 9591 6258 Begin cold level 0 restore psapbt06.
2003-04-03 18:35:43 9591 6258 ERROR: Unable to write restore data to the datab
ase server: The chunk '/informix/CP1/sapdata/physdev60/data736' will not fit in
the space specified..
2003-04-03 18:35:43 9591 6258 WARNING: Skipped backup/restore of space 'psapbt
06'.
2003-04-03 18:35:47 9591 6258 Process 9591 6258 completed.
2003-04-03 18:35:47 6258 6257 The ON-Bar process 9591 exited with a problem (e
xit code 131 (0x83), signal -1).
Reply With Quote
  #2 (permalink)  
Old 04-04-03, 10:53
eherber eherber is offline
Registered User
 
Join Date: Aug 2002
Location: Bonn/Germany
Posts: 152
The best might be to buy a consultant for this
task.

The error message is clear. Check the size of
the specified chunk with dd, i.e.:

dd if=/informix/CP1/sapdata/physdev55/data582 of=/dev/null bs=1024k

This will tell you how large this chunk is (in MB).
Compare this value to the chunks sizes on your production machine where you took the backup.
__________________

Best regards

Eric
--
IT-Consulting Herber
WWW: http://www.herber-consulting.de
Email: eric@herber-consulting.de

***********************************************
Download the IFMX Database-Monitor for free at:
http://www.herber-consulting.de/BusyBee
***********************************************
Reply With Quote
  #3 (permalink)  
Old 04-04-03, 11:18
SGorman SGorman is offline
Registered User
 
Join Date: Apr 2003
Posts: 2
Red face

We have now two consultants, and it does seem to be an O/S / Hardware fault as there are error messages being recorded in the /var/adm/message file concerning read errors on the disk identified by the bar_act.log.
Thanks for the responce. Once the problem is resolved I'll update the message.
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