Re: Help with full logical logs
This is a multi-part message in MIME format.
--------------3C9CB7546D0C62EA65C48205
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Jonathan Leffler wrote:
>
> Joachim Scherer wrote:
> > my logical logs are full. ontape -a doesn't work anymore. How can
> > free the logs without loosing my data. And hopefully without doing
> > a restore.
>
> > We're running Informix 7.12 UC1 on SunSolaris
>
> The first question is why doesn't ontape -a work any more?
> You need to back up those logs. Since you don't want to risk the
> data, you need to get them backed up. You could change the backup
> device -- /dev/null might work but would lose the data, but you
> should be OK with a disk file (this is an emergency).
>
> I've not had to do serious receovery work for 5+ years, so I might
> be off target, but I think that's going to the key. Since you use
> ontape, any suggestions about switching to another backup system
> won't help at this point...
>
Ok here's more detail information.
Here's an output of onstat -l:
INFORMIX-OnLine Version 7.12.UC1 -- On-Line (CKPT REQ) -- Up 1 days
02:04:30 -- 8976 Kbytes
Blocked:CKPT
Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-1 0 16 0 0 0,00
phybegin physize phypos phyused %used
10003f 500 379 0 0,00
Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-1 1 16 1 1 1 1,0 1,0
Buffer Waiting
Buffer ioproc flags #bcpiers
L-1 a11c010 0x1 0
address number flags uniqid begin size used %used
a050ce8 1 U------ 31 100233 250 250 100,00
a050d04 2 U------ 32 10032d 250 250 100,00
a050d20 3 U---C-L 33 100427 250 250 100,00
a050d3c 4 U------ 28 100521 250 250 100,00
a050d58 5 U------ 29 10061b 250 250 100,00
a050d74 6 U------ 30 100715 250 250 100,00
So all the logical logs are full.
LTAPEDEV in the onconfig file points to a file in the file system.
When I try to do an backup using ontape, I get the following output:
# ontape -aServer is in an incompatible state
Program over.
#
The server ist still online and works ok regarding select statements. I
still can connect usind dbaccess ar the web interface to the db.
I also brought the whole engine down and started it again. Well, without success.
Can I simply add an new logical log file and try again?
thanks for any help
Joachim Scherer
--------------3C9CB7546D0C62EA65C48205
Content-Type: text/x-vcard; charset=us-ascii;
name="joachim.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Joachim Scherer
Content-Disposition: attachment;
filename="joachim.vcf"
begin:vcard
n:Scherer;Joachim
x-mozilla-html:TRUE
version:2.1
email;internet:joachim@diana.scientific.de
x-mozilla-cpt:;0
fn:Joachim Scherer
end:vcard
--------------3C9CB7546D0C62EA65C48205--