Oninit cdi / Archive
Talk to an expert →

How do I forward logs to other server. "No Storage spaces" error

Posted in 2003

Topics: Backup & Restore, Logging & Checkpoints, Versions, Editions & End-of-Life

Isaac Loven — — source: Usenet: comp.databases.informix

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------=_NextPartTM-000-210db7d7-8df6-4ccf-984a-492203bd8d0e Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C39471.C4845CD0" ------_=_NextPart_001_01C39471.C4845CD0 Content-Type: text/plain; charset="iso-8859-1" Hi colleagues, I am trying to restore a database to another machine, and roll logical logs forward. We have IDS 9.30.FC3, HPUX11.0 DataProtector5.0. I have added Informix patch PHSS_28737. Every night we close the application, and take a business copy of the disks to another VA7400. This copy can be seen by the other Server (B). As a result, the disk layout is identical. We can start the database on the other machine ( oninit ) but it only has 1am data. We wish to roll forward logs generated later on server A ( which we keep on tape ) to Server B. Why do I get the message "There are no storage spaces/logical logs to backup/restore" below ? I have also tried onbar -r -l, onbar -r -l -n 246, onbar -r, onbar -p then onbar -l. ( I have RTFM, and searched iiug, hp.com and comp.database.informix to know avail ) serverB:730:/informix.930/etc># onbar -r -w 2003-10-15 14:16:51 8975 8973 /home/informix.930/bin/onbar_d -r -w 2003-10-15 14:16:52 8975 8973 Successfully connected to Storage Manager. 2003-10-15 14:16:57 8975 8973 Begin salvage for log 246. 2003-10-15 14:17:00 8975 8973 Completed salvage of logical log 246. 2003-10-15 14:17:00 8975 8973 There are no storage spaces/logical logs to backup/restore. 2003-10-15 14:17:05 8975 8973 Due to the previous error, logical restore will not be attempted. Thanks, Isaac. Isaac Loven. Unix Technical Support Engineer. Business & Technology Services. Australian Unity Limited Phone: 03 9697 0396 Mobile: 0423 780 946 ------_=_NextPart_001_01C39471.C4845CD0 Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD> <BODY> <DIV><FONT face=Arial size=2><SPAN class=467410504-15102003>Hi colleagues,</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=467410504-15102003>I am trying to restore a database to another machine, and roll logical logs forward.</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=467410504-15102003>We have IDS 9.30.FC3, HPUX11.0 DataProtector5.0.&nbsp; I have added Informix patch PHSS_28737. </SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=467410504-15102003></SPAN></FONT>&nbsp;</DIV> <DIV><FONT face=Arial size=2><SPAN class=467410504-15102003>Every night we close the application, and take a business copy of the disks to another&nbsp;VA7400.&nbsp;This copy can be seen by the other Server (B).</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=467410504-15102003>As a result, the disk layout is identical.</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=467410504-15102003>We can start the database on the other machine ( oninit ) but it only has 1am&nbsp;data.</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=467410504-15102003>We wish to roll forward logs generated later on server A&nbsp; ( which we keep on tape ) to&nbsp;Server B.&nbsp;</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=467410504-15102003></SPAN></FONT>&nbsp;</DIV><FONT size=+0><SPAN class=467410504-15102003> <DIV><FONT face=Arial><FONT size=2><STRONG><SPAN class=467410504-15102003>Why do I get the message "</SPAN>There are no storage spaces/logical logs to backup/restore<SPAN class=467410504-15102003>"&nbsp; below ?</SPAN></STRONG></FONT></FONT></DIV> <DIV><FONT face=Arial><FONT size=2><SPAN class=467410504-15102003><STRONG></STRONG></SPAN></FONT></FONT>&nbsp;</DIV> <DIV><FONT face=Arial><FONT size=2><SPAN class=467410504-15102003>I have also tried onbar -r -l, onbar -r -l -n 246, onbar -r, onbar -p&nbsp;&nbsp; then onbar -l. </SPAN></FONT></FONT></DIV> <DIV><FONT face=Arial><FONT size=2><SPAN class=467410504-15102003></SPAN></FONT></FONT>&nbsp;</DIV> <DIV><FONT face=Arial><FONT size=2><SPAN class=467410504-15102003>( I have RTFM, and searched iiug, hp.com and comp.database.informix to know avail ) </SPAN></FONT></FONT></DIV> <DIV><FONT size=+0><BR><FONT face=Arial><FONT size=2><SPAN class=467410504-15102003>serverB</SPAN>:730:/informix.930/etc<SPAN class=467410504-15102003>&gt;#&nbsp; </SPAN>&nbsp;onbar -r -w<BR>&nbsp;2003-10-15 14:16:51 8975&nbsp; 8973 /home/informix.930/bin/onbar_d -r -w<BR>&nbsp;2003-10-15 14:16:52 8975&nbsp; 8973 Successfully connected to Storage Manager.<BR>&nbsp;2003-10-15 14:16:57 8975&nbsp; 8973 Begin salvage for log 246.<BR>&nbsp;2003-10-15 14:17:00 8975&nbsp; 8973 Completed salvage of logical log 246.<BR>&nbsp;2003-10-15 14:17:00 8975&nbsp; 8973 There are no storage spaces/logical logs to backup/restore.<BR>&nbsp;2003-10-15 14:17:05 8975&nbsp; 8973 Due to the previous error, logical restore will not be attempted.</FONT></FONT></FONT></DIV></SPAN></FONT> <DIV><FONT size=1><FONT face=Arial><FONT size=2>Thanks,</FONT></FONT></FONT></DIV> <DIV><FONT face="FlemishScript BT" size=6>Isaac. </FONT></DIV> <DIV><FONT size=1><FONT face=Arial><FONT size=2></FONT></FONT></FONT>&nbsp;</DIV> <DIV><FONT size=1><FONT face=Arial><FONT size=2>Isaac Loven.</FONT> </FONT></FONT></DIV> <DIV><FONT face=Arial size=1></FONT>&nbsp;</DIV> <DIV><FONT face=Arial size=1>Unix Technical Support Engineer.</FONT></DIV> <DIV><FONT size=1><FONT face=Arial>Business &amp; Technology Services. Australian Unity Limited<BR><FONT size=2>Phone:&nbsp; 03 9697 0396&nbsp;&nbsp; Mobile:</FONT> <FONT size=2>0423 780 946&nbsp;<SPAN class=682204405-17102003><FONT color=#0000ff>&nbsp; &nbsp;</FONT></SPAN></FONT></FONT></FONT></DIV> <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV></BODY></HTML> ------_=_NextPart_001_01C39471.C4845CD0-- ------=_NextPartTM-000-210db7d7-8df6-4ccf-984a-492203bd8d0e-- sending to informix-list

↪ replying to Isaac Loven
Obnoxio The Clown — — source: Usenet: comp.databases.informix

Isaac Loven wrote: > > This message is in MIME format. Since your mail reader does not understand > this format, some or all of this message may not be legible. > > ------=_NextPartTM-000-210db7d7-8df6-4ccf-984a-492203bd8d0e > Content-Type: multipart/alternative; > boundary="----_=_NextPart_001_01C39471.C4845CD0" > > ------_=_NextPart_001_01C39471.C4845CD0 > Content-Type: text/plain; > charset="iso-8859-1" > > ------_=_NextPart_001_01C39471.C4845CD0 > Content-Type: text/html; > charset="iso-8859-1" > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > <HTML><HEAD> > <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> > > > <META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD> > <BODY> > <DIV><FONT face=Arial size=2><SPAN class=467410504-15102003>Hi > colleagues,</SPAN></FONT></DIV> > <DIV><FONT face=Arial size=2><SPAN class=467410504-15102003>I am trying to > restore a database to another machine, and roll logical logs > forward.</SPAN></FONT></DIV> > <DIV><FONT face=Arial size=2><SPAN class=467410504-15102003>We have IDS > 9.30.FC3, HPUX11.0 DataProtector5.0.&nbsp; I have added Informix patch > PHSS_28737. </SPAN></FONT></DIV> > <DIV><FONT face=Arial size=2><SPAN > class=467410504-15102003></SPAN></FONT>&nbsp;</DIV> > <DIV><FONT face=Arial size=2><SPAN class=467410504-15102003>Every night we > close the application, and take a business copy of the disks to > another&nbsp;VA7400.&nbsp;This copy can be seen by the other Server > (B).</SPAN></FONT></DIV> > <DIV><FONT face=Arial size=2><SPAN class=467410504-15102003>As a result, > the disk layout is identical.</SPAN></FONT></DIV> > <DIV><FONT face=Arial size=2><SPAN class=467410504-15102003>We can start > the database on the other machine ( oninit ) but it only has > 1am&nbsp;data.</SPAN></FONT></DIV> > <DIV><FONT face=Arial size=2><SPAN class=467410504-15102003>We wish to > roll forward logs generated later on server A&nbsp; ( which we keep on > tape ) to&nbsp;Server B.&nbsp;</SPAN></FONT></DIV> > <DIV><FONT face=Arial size=2><SPAN > class=467410504-15102003></SPAN></FONT>&nbsp;</DIV><FONT size=+0><SPAN > class=467410504-15102003> > <DIV><FONT face=Arial><FONT size=2><STRONG><SPAN > class=467410504-15102003>Why do I get the message "</SPAN>There are no > storage spaces/logical logs to backup/restore<SPAN > class=467410504-15102003>"&nbsp; below > ?</SPAN></STRONG></FONT></FONT></DIV> <DIV><FONT face=Arial><FONT > size=2><SPAN > class=467410504-15102003><STRONG></STRONG></SPAN></FONT></FONT>&nbsp;</DIV> > <DIV><FONT face=Arial><FONT size=2><SPAN class=467410504-15102003>I have > also tried onbar -r -l, onbar -r -l -n 246, onbar -r, onbar -p&nbsp;&nbsp; > then onbar -l. </SPAN></FONT></FONT></DIV> <DIV><FONT face=Arial><FONT > size=2><SPAN class=467410504-15102003></SPAN></FONT></FONT>&nbsp;</DIV> > <DIV><FONT face=Arial><FONT size=2><SPAN class=467410504-15102003>( I have > RTFM, and searched iiug, hp.com and comp.database.informix to know avail ) > </SPAN></FONT></FONT></DIV> > <DIV><FONT size=+0><BR><FONT face=Arial><FONT size=2><SPAN > class=467410504-15102003>serverB</SPAN>:730:/informix.930/etc<SPAN > class=467410504-15102003>&gt;#&nbsp; </SPAN>&nbsp;onbar -r > -w<BR>&nbsp;2003-10-15 14:16:51 8975&nbsp; 8973 > /home/informix.930/bin/onbar_d -r -w<BR>&nbsp;2003-10-15 14:16:52 > 8975&nbsp; 8973 Successfully connected to Storage > Manager.<BR>&nbsp;2003-10-15 14:16:57 8975&nbsp; 8973 Begin salvage for > log 246.<BR>&nbsp;2003-10-15 14:17:00 8975&nbsp; 8973 Completed salvage of > logical log 246.<BR>&nbsp;2003-10-15 14:17:00 8975&nbsp; 8973 There are no > storage spaces/logical logs to backup/restore.<BR>&nbsp;2003-10-15 > 14:17:05 8975&nbsp; 8973 Due to the previous error, logical restore will > not be attempted.</FONT></FONT></FONT></DIV></SPAN></FONT> <DIV><FONT > size=1><FONT face=Arial><FONT size=2>Thanks,</FONT></FONT></FONT></DIV> > <DIV><FONT face="FlemishScript BT" size=6>Isaac. </FONT></DIV> > <DIV><FONT size=1><FONT face=Arial><FONT > size=2></FONT></FONT></FONT>&nbsp;</DIV> > <DIV><FONT size=1><FONT face=Arial><FONT size=2>Isaac Loven.</FONT> > </FONT></FONT></DIV> > <DIV><FONT face=Arial size=1></FONT>&nbsp;</DIV> > <DIV><FONT face=Arial size=1>Unix Technical Support Engineer.</FONT></DIV> > <DIV><FONT size=1><FONT face=Arial>Business &amp; Technology Services. > Australian Unity Limited<BR><FONT size=2>Phone:&nbsp; 03 9697 > 0396&nbsp;&nbsp; Mobile:</FONT> <FONT size=2>0423 780 946&nbsp;<SPAN > class=682204405-17102003><FONT color=#0000ff>&nbsp; > &nbsp;</FONT></SPAN></FONT></FONT></FONT></DIV> > <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV></BODY></HTML> Idiot. -- Ciao, The Obnoxious One "Ogni uomo mi guarda come se fossi una testa di cazzo"

Related threads

Glossary