RE: restore using ontape
While taking the backup using ontape I had used "ontape -s" and selected 0
level archive.
Does this include the logical logs also?
while restoring I gave "No" when it asked whether to restore the logical
log.
I don't have any other tape with logical logs backed up.
Pls let me know if the level 0 backup taken by ontaoe includes logical logs
also?
Thanks for all those who replied...
Thanks,
Srini
-----Original Message-----
From: William Rice [mailto:ricew@operamail.com]
Sent: Monday, June 19, 2000 7:47 PM
To: informix-list; Srinivas Sreekumar
Subject: RE: restore using ontape
You need to restore your logical logs as well.
Will
>===== Original Message From Srinivas Sreekumar <SRINIVAS_SK@inf.com> =====
>Hi All,
>
>Now the chunk status is as below
>
>c61f7458 3 3 1 750000 536821 PI- /dev/vg05/databaseB
>c61f7538 4 3 2 766000 726581 PI- /dev/vg04/databaseC
>
>How can I make the chunk online or change the status to "PO".
>Pls help me out.....
>we have informix 7.30 on HP UX.
>
>thanks,
>Srini
>
>-----Original Message-----
>From: Srinivas Sreekumar
>Sent: Monday, June 19, 2000 2:25 PM
>To: informix-list@iiug.org
>Subject: restore using ontape
>Importance: High
>
>
>Hi All,
>
>I am new to informix....So pls help me.
>
>I had a problem with one of my the chunk of a DBSpace. I had to restore it
>from the tape using "ontape -r -D dbaseb"
>the restoration was compleated successfully.Now the status of dbspaces are
>as below...
>---------------------------------------------------------------------------
-
>--------------------
>informix@haddock:/usr/informix> onstat -d
>
>Informix Dynamic Server Version 7.30.UC8 -- Quiescent -- Up 02:21:27 --
>13544
> Kbytes
>
>Dbspaces
>address number flags fchunk nchunks flags owner name
>c61f7158 1 1 1 1 N informix rootdbs7
>c61f76f8 2 1 2 1 N informix dbasea
>c61f77b8 3 401 3 2 NP informix dbaseb
>c61f7878 4 1 5 1 N informix dbased
> 4 active, 2047 maximum
>
>Chunks
>address chk/dbs offset size free bpages flags pathname
>c61f7218 1 1 1 250000 55958 PO-
>/dev/vg01/rootdb7vol
>c61f7378 2 2 1 750000 147766 PO-
>/dev/vg05/databaseA
>c61f7458 3 3 1 750000 536821 PI-
>/dev/vg05/databaseB
>c61f7538 4 3 2 766000 726581 PI-
>/dev/vg04/databaseC
>c61f7618 5 4 0 50000 49085 PO-
>/dev/vg05/databaseD
> 5 active, 2047 maximum
>
>---------------------------------------------------------------------------
-
>---------------------
>
>The flags for Dbspace "dbaseb" is showing "NP" and for chunks are showing
>"PI".
>Now what am I supposed to do after this to make the database consistent and
>up and running.
>
>thanks,
>Srini
------------------------------------------------------------
This e-mail has been sent to you courtesy of OperaMail, as a free
service from
Opera Software, makers of the award-winning Web Browser, Opera. Visit us
at
http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free
e-mail
account is waiting at: http://www.operamail.com/
------------------------------------------------------------
When you do the level 0 archive it asks whether to backup the current
logical log, other than that the logical logs are archived separately using
ontape -a or ontape -c to the LTAPEDEV device or file. When you restoreanswer YES to the logical logs restore question and mount the file/tape
containing the requested logical log(s) on the LTAPEDEV device or file.
After the restore completes it is IMPERATIVE that you bring the engine to
FULLY ONLINE mode by running onmode -m and waiting for the engine status to
reach 'online' as reported in the message log and by onstat - before
attempting to shut the engine down and restart manually. If you do not do
this you will have to start the restore over again.
Art S. Kagel
Srinivas Sreekumar wrote:
>
> While taking the backup using ontape I had used "ontape -s" and selected 0
> level archive.
> Does this include the logical logs also?
>
> while restoring I gave "No" when it asked whether to restore the logical
> log.
> I don't have any other tape with logical logs backed up.
>
> Pls let me know if the level 0 backup taken by ontaoe includes logical logs
> also?
> Thanks for all those who replied...
>
> Thanks,
> Srini
>
> -----Original Message-----
> From: William Rice [mailto:ricew@operamail.com]
> Sent: Monday, June 19, 2000 7:47 PM
> To: informix-list; Srinivas Sreekumar
> Subject: RE: restore using ontape
>
> You need to restore your logical logs as well.
>
> Will
> >===== Original Message From Srinivas Sreekumar <SRINIVAS_SK@inf.com> =====
> >Hi All,
> >
> >Now the chunk status is as below
> >
> >c61f7458 3 3 1 750000 536821 PI- /dev/vg05/databaseB
> >c61f7538 4 3 2 766000 726581 PI- /dev/vg04/databaseC
> >
> >How can I make the chunk online or change the status to "PO".
> >Pls help me out.....
> >we have informix 7.30 on HP UX.
> >
> >thanks,
> >Srini
> >
> >-----Original Message-----
> >From: Srinivas Sreekumar
> >Sent: Monday, June 19, 2000 2:25 PM
> >To: informix-list@iiug.org
> >Subject: restore using ontape
> >Importance: High
> >
> >
> >Hi All,
> >
> >I am new to informix....So pls help me.
> >
> >I had a problem with one of my the chunk of a DBSpace. I had to restore it
> >from the tape using "ontape -r -D dbaseb"
> >the restoration was compleated successfully.Now the status of dbspaces are
> >as below...
> >---------------------------------------------------------------------------
> -
> >--------------------
> >informix@haddock:/usr/informix> onstat -d
> >
> >Informix Dynamic Server Version 7.30.UC8 -- Quiescent -- Up 02:21:27 --
> >13544
> > Kbytes
> >
> >Dbspaces
> >address number flags fchunk nchunks flags owner name
> >c61f7158 1 1 1 1 N informix rootdbs7
> >c61f76f8 2 1 2 1 N informix dbasea
> >c61f77b8 3 401 3 2 NP informix dbaseb
> >c61f7878 4 1 5 1 N informix dbased
> > 4 active, 2047 maximum
> >
> >Chunks
> >address chk/dbs offset size free bpages flags pathname
> >c61f7218 1 1 1 250000 55958 PO-
> >/dev/vg01/rootdb7vol
> >c61f7378 2 2 1 750000 147766 PO-
> >/dev/vg05/databaseA
> >c61f7458 3 3 1 750000 536821 PI-
> >/dev/vg05/databaseB
> >c61f7538 4 3 2 766000 726581 PI-
> >/dev/vg04/databaseC
> >c61f7618 5 4 0 50000 49085 PO-
> >/dev/vg05/databaseD
> > 5 active, 2047 maximum
> >
> >---------------------------------------------------------------------------
> -
> >---------------------
> >
> >The flags for Dbspace "dbaseb" is showing "NP" and for chunks are showing
> >"PI".
> >Now what am I supposed to do after this to make the database consistent and
> >up and running.
> >
> >thanks,
> >Srini
>
> ------------------------------------------------------------
> This e-mail has been sent to you courtesy of OperaMail, as a free
> service from
> Opera Software, makers of the award-winning Web Browser, Opera. Visit us
> at
> http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free
> e-mail
> account is waiting at: http://www.operamail.com/
> ------------------------------------------------------------
"Art S. Kagel" wrote:
> When you do the level 0 archive it asks whether to backup the current
> logical log, other than that the logical logs are archived separately using
> ontape -a or ontape -c to the LTAPEDEV device or file. When you restore> answer YES to the logical logs restore question and mount the file/tape
> containing the requested logical log(s) on the LTAPEDEV device or file.
here is my Problem after the 1st logical log restore (saved as file) informix
crahses.
this is what my logfile shows after the rootdbs has been restored :
--
15:25:41 Physical Restore of rootdbs Completed.
15:25:41 Checkpoint Completed: duration was 0 seconds.
15:25:41 Checkpoint loguniq 73, logpos 0x18c2b4
15:25:57 Logical Recovery Started.
15:25:57 dynamically allocated new shared memory segment (size 8388608)
15:25:57 Checkpoint Completed: duration was 0 seconds.
15:25:57 Checkpoint loguniq 73, logpos 0x18c2b4
15:25:57 Start Logical Recovery - Start Log 73, End Log ?
15:25:57 Starting Log Position - 73 0x18c2b4
15:25:58 Checkpoint Completed: duration was 0 seconds.
15:25:58 Checkpoint loguniq 73, logpos 0x18d018
15:26:27 Logical Recovery ABORTED.
Aborted by client.
15:26:27 Assert Failed: Logical Recovery ABORTED.
Dynamic Server 2000 must abort
15:26:27 Informix Dynamic Server 2000 Version 9.20.UC1
15:26:27 Who: Session(12, user@backend, 712, 277371568)
Thread(19, ontape, 10858298, 1)
File: rslgr.c Line: 1079
15:26:27 stack trace for pid 716 written to /tmp/af.3fba003
15:26:27 See Also: /tmp/af.3fba003, shmem.3fba003.0
15:26:30 rslgr.c, line 1079, thread 19, proc id 716, Logical Recovery ABORTED.
Dynamic Server 2000 must abort.
15:26:31 The Master Daemon Died
15:26:31 PANIC: Attempting to bring system down
15:26:31 semctl: errno = 22
15:26:31 semctl: errno = 22
--
thanks for any help
Chris
In article <39514129.9E84E47A@bloomberg.net>,
kagel@bloomberg.net wrote:
>
> After the restore completes it is IMPERATIVE that you bring the
engine to
> FULLY ONLINE mode by running onmode -m and waiting for the engine
status to
> reach 'online' as reported in the message log and by onstat - before
> attempting to shut the engine down and restart manually. If you do
not do
> this you will have to start the restore over again.
>
> Art S. Kagel
>
Is that quite necessary? On a 7.31 engine, I found that I could bring
down the engine straight after the restore (ie, without an onmode -m)
and bring it back online (oninit) without any problems.
I did not restore any logical logs (during the restore). But will that
cause the behaviour that Art is speaking about?
Alanoly.
Sent via Deja.com http://www.deja.com/
Before you buy.
Related threads
- IDS 10 table-level restore
- Informix Development Webinar December 11, 2007
- ontape -p/r with changed ROOTPATH
- Migrate from HP PA-RISC to HP ITANIUM by ontape