RESTORE problem : help ??
Posted in 2000
This is a multi-part message in MIME format.
------=_NextPart_000_0007_01C0662F.31AA14E0
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0008_01C0662F.31B1B600"
------=_NextPart_001_0008_01C0662F.31B1B600
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
hi there,
The Hard disks were crashed yesterday night and the informix database is =
on the those raw device.
We have done a level-0 backups just 1 hours before the incident. But =
when we tried to restore the db, it DIDN't show the usual
10 percent done.
20 percent done.
..
..
100 percent done
in fact the restore (ontape -r) completed after 2 hours without showing =
the above msg. The error msg shown on the online.log was OK.=20
archieve started at ....
completed at ...
When it asked "Do you want to restore logical log ?" , we put in the =
logical log tape and then typed "Y". But instead of=20
restore the logical log, the ontape went to "Program over".
online log - tells the online was aborted.
22:17:02 Recovery Mode
22:17:02 Physical Restore of rootdbs, cdrs1and2, cdrs3and4, cdrs5and6, =
cdrs7and
8, cdrs9and0, logicallogs, ccmsdata, rcmsdata, physicallog, =
cdrs1and2new, cdrs3a
nd4new, cdrs5and6new, cdrs7and8new, cdrs9and0new, cdrs01idx, cdrs02idx, =
cdrs03id
x, cdrs04idx, sna_online_cdr, sna_online_cdridx, sna_history_cdr, =
sna_history_cd
ridx, snb_online_cdr, snb_online_cdridx, snb_history_cdr, =
snb_history_cdridx, cd
r_unload started.
22:17:04 Checkpoint Completed: duration was 0 seconds.
23:44:18 Physical Restore of rootdbs, cdrs1and2, cdrs3and4, cdrs5and6, =
cdrs7and
8, cdrs9and0, logicallogs, ccmsdata, rcmsdata, physicallog, =
cdrs1and2new, cdrs3a
nd4new, cdrs5and6new, cdrs7and8new, cdrs9and0new, cdrs01idx, cdrs02idx, =
cdrs03id
x, cdrs04idx, sna_online_cdr, sna_online_cdridx, sna_history_cdr, =
sna_history_cd
ridx, snb_online_cdr, snb_online_cdridx, snb_history_cdr, =
snb_history_cdridx, cd
r_unload Completed.
23:44:18 Checkpoint Completed: duration was 0 seconds.
23:46:50 Logical Recovery Started.
23:46:50 Checkpoint Completed: duration was 0 seconds.
23:46:50 Start Logical Recovery - Start Log 27687, End Log ?
23:46:50 Starting Log Position - 27687 0x7fd018
23:48:03 Logical Recovery ABORTED.
Aborted by client.
23:48:04 Assert Failed: Logical Recovery ABORTED.
Dynamic Server must abort
23:48:04 Informix Dynamic Server Version 7.30.UC7XM
23:48:04 Who: Session(21, informix@snss, 2581, 0)
Thread(62, ontape, 0, 5)
23:48:04 stack trace for pid 2589 written to /tmp/af.3eebb3
23:48:49 See Also: /tmp/af.3eebb3
23:48:49 rslgr.c, line 1001, thread 62, proc id 2589, Logical Recovery =
ABORTED.
Dynamic Server must abort.
23:48:49 PANIC: Attempting to bring system down
23:50:16 Segment locked: addr=3D0xce7b0000, size=3D203603968
23:50:16 Event alarms enabled. ALARMPROG =3D =
'/home/informix/etc/log_full.sh'
23:50:22 DR: DRAUTO is 0 (Off)
23:50:22 Informix Dynamic Server Version 7.30.UC7XM Software Serial =
Number AAC#
J921103
23:50:22 (11) connection rejected - no calls allowed for sqlexec
23:50:22 listener-thread: err =3D -27002: oserr =3D 0: errstr =3D : No =
connections ar
e allowed in Dynamic Server quiescent mode.
23:50:22 Informix Dynamic Server Initialized -- Shared Memory =
Initialized.
23:50:22 Physical Recovery Started.
23:50:23 Physical Recovery Complete: 0 Pages Restored.
23:50:23 Logical Recovery Started.
23:50:26 Logical Recovery Complete.
Worst till now I'm getting this error
> ontape -r
Please mount tape 1 on /dev/rmt/2m and press Return to continue ...=20Physical restore failed - function read archive backup failed code -1 =
errno 4=20
Your advise will be very much appreciated.
Regards,
Lee
------=_NextPart_001_0008_01C0662F.31B1B600
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>hi there,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>The Hard disks were crashed yesterday night and the =
informix=20
database is on the those raw device.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>We have done a level-0 backups just 1 hours before =
the=20
incident. But when we tried to restore the db, it DIDN't show the=20
usual</FONT></DIV>
<DIV><FONT size=3D2>10 percent done.</FONT></DIV>
<DIV><FONT size=3D2>20 percent done.</FONT></DIV>
<DIV><FONT size=3D2>..</FONT></DIV>
<DIV><FONT size=3D2>..</FONT></DIV>
<DIV><FONT size=3D2>100 percent done</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>in fact the restore (ontape -r) completed after 2 =
hours=20
without showing the above msg. The error msg shown on the online.log was =
OK.=20
</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>archieve started at ....</FONT></DIV>
<DIV><FONT size=3D2>completed at ...</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>When it asked "Do you want to restore logical log ?" =
, we put=20
in the logical log tape and then typed "Y". But instead of </FONT></DIV>
<DIV><FONT size=3D2>restore the logical log, the ontape went to "Program =
over".</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>online log - tells the online was =
aborted.</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=3Dr_ansi size=3D2> </DIV>
<DIV><FONT face=3DArial>22:17:02 Recovery Mode</FONT></DIV>
<DIV><FONT face=3DArial>22:17:02 Physical Restore of rootdbs, cdrs1and2, =
cdrs3and4, cdrs5and6, cdrs7and</FONT></DIV>
<DIV><FONT face=3DArial>8, cdrs9and0, logicallogs, ccmsdata, rcmsdata,=20
physicallog, cdrs1and2new, cdrs3a</FONT></DIV>
<DIV><FONT face=3DArial>nd4new, cdrs5and6new, cdrs7and8new, =
cdrs9and0new,=20
cdrs01idx, cdrs02idx, cdrs03id</FONT></DIV>
<DIV><FONT face=3DArial>x, cdrs04idx, sna_online_cdr, sna_online_cdridx, =
sna_history_cdr, sna_history_cd</FONT></DIV>
<DIV><FONT face=3DArial>ridx, snb_online_cdr, snb_online_cdridx, =
snb_history_cdr,=20
snb_history_cdridx, cd</FONT></DIV>
<DIV><FONT face=3DArial>r_unload started.</FONT></DIV>
<DIV><FONT face=3DArial>22:17:04 Checkpoint Completed: duration was 0=20
seconds.</FONT></DIV>
<DIV><FONT face=3Dr_ansi size=3D2> </DIV>
<DIV><FONT face=3DArial>23:44:18 Physical Restore of rootdbs, cdrs1and2, =
cdrs3and4, cdrs5and6, cdrs7and</FONT></DIV>
<DIV><FONT face=3DArial>8, cdrs9and0, logicallogs, ccmsdata, rcmsdata,=20
physicallog, cdrs1and2new, cdrs3a</FONT></DIV>
<DIV><FONT face=3DArial>nd4new, cdrs5and6new, cdrs7and8new, =
cdrs9and0new,=20
cdrs01idx, cdrs02idx, cdrs03id</FONT></DIV>
<DIV><FONT face=3DArial>x, cdrs04idx, sna_online_cdr, sna_online_cdridx, =
sna_history_cdr, sna_history