omniback onbar. How do I forward logs to other server. "No Stora
Posted in 2003
Topics: Backup & Restore, Logging & Checkpoints, Versions, Editions & End-of-Life
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-68e8a47a-c603-48db-8127-268cbef2424c
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C392D7.7DAD01E0"
------_=_NextPart_001_01C392D7.7DAD01E0
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
<mailto:iloven@australianunity.com.au> iloven@australianunity.com.au
------_=_NextPart_001_01C392D7.7DAD01E0
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. I have added Informix patch
PHSS_28737. </SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=467410504-15102003></SPAN></FONT> </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 VA7400. 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 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 ( which we keep on tape )
to Server B. </SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=467410504-15102003></SPAN></FONT> </DIV><FONT><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>" below
?</SPAN></STRONG></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=467410504-15102003><STRONG></STRONG></SPAN></FONT></FONT> </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 then onbar
-l. </SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=467410504-15102003></SPAN></FONT></FONT> </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><BR><FONT face=Arial><FONT size=2><SPAN
class=467410504-15102003>serverB</SPAN>:730:/informix.930/etc<SPAN
class=467410504-15102003>># </SPAN> onbar -r
-w<BR> 2003-10-15 14:16:51 8975 8973 /home/informix.930/bin/onbar_d
-r -w<BR> 2003-10-15 14:16:52 8975 8973 Successfully connected to
Storage Manager.<BR> 2003-10-15 14:16:57 8975 8973 Begin salvage for
log 246.<BR> 2003-10-15 14:17:00 8975 8973 Completed salvage of
logical log 246.<BR> 2003-10-15 14:17:00 8975 8973 There are no
storage spaces/logical logs to backup/restore.<BR> 2003-10-15 14:17:05
8975 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> </DIV>
<DIV><FONT size=1><FONT face=Arial><FONT size=2>Isaac Loven.</FONT>
</FONT></FONT></DIV>
<DIV><FONT face=Arial size=1></FONT> </DIV>
<DIV><FONT face=Arial size=1>Unix Technical Support Engineer.</FONT></DIV>
<DIV><FONT face=Arial size=1>Business & Technology Services. Australian
Unity Limited<BR><FONT size=2>Phone: 03 9697 0396
Mobile:</FONT> <FONT size=2>0423 780 946 </FONT></FONT></DIV>
<DIV><A href="mailto:iloven@australianunity.com.au"><FONT face=Arial
size=1>iloven@australianunity.com.au</FONT></A><BR></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>
------_=_NextPart_001_01C392D7.7DAD01E0--
------=_NextPartTM-000-68e8a47a-c603-48db-8127-268cbef2424c--
sending to informix-list
Related threads
- eliminate duplicate rows
- Informix Active Directory Support on Linux
- Result of a select not as a table
- DBSpace Use by Database