Re: Informix: ontape -a error: Log backup to device '/dev/null' not allowed (1327 Views)
Reply
Advisor
Andrey Pevnev
Posts: 17
Registered: ‎12-20-2004
Message 1 of 12 (1,327 Views)
Accepted Solution

Informix: ontape -a error: Log backup to device '/dev/null' not allowed

Hello!

I want to enable automatic logical logs backup on informix IDS, but ontape -a gives this error:

Performing automatic backup of logical logs.
Logbackup failed - Log backup to device '/dev/null' not allowed


Program over.

LTAPEDEV is set to /dev/null in onconfig

I found a technical case on IBM site with the same problem http://www-1.ibm.com/support/docview.wss?rs=0&q1=Log+backup+to+device+%27%2fdev%2fnull%27+not+allowe...〈=en

But I've restarted Informix many times, it doesn't help :(

Maybe you have some ideas?

Informix version:
Informix Dynamic Server Version 7.31.UD6W5
HP-UX
B.11.11 U 9000/800

Thanks!
Please use plain text.
Respected Contributor
Tommy Brown
Posts: 500
Registered: ‎09-24-1998
Message 2 of 12 (1,327 Views)

Re: Informix: ontape -a error: Log backup to device '/dev/null' not allowed

Andrey,
You must change the LTAPEDEV to a valid tape device and restart the Informix server.
Tommy
I may be slow, but I get there !
Please use plain text.
Advisor
Andrey Pevnev
Posts: 17
Registered: ‎12-20-2004
Message 3 of 12 (1,327 Views)

Re: Informix: ontape -a error: Log backup to device '/dev/null' not allowed

But I don't want to backup logical logs.
On another HP machine LTAPEDEV is set to /dev/null and everything is ok. I can't understand why it can't work on this machine...
Please use plain text.
Respected Contributor
Tommy Brown
Posts: 500
Registered: ‎09-24-1998
Message 4 of 12 (1,327 Views)

Re: Informix: ontape -a error: Log backup to device '/dev/null' not allowed

Andrey,
Change TAPEDEV to /dev/null
not LTAPEDEV and try the ontape again.. LTAPEDEV must not be /dev/null
Tommy
I may be slow, but I get there !
Please use plain text.
Respected Contributor
Tommy Brown
Posts: 500
Registered: ‎09-24-1998
Message 5 of 12 (1,327 Views)

Re: Informix: ontape -a error: Log backup to device '/dev/null' not allowed

Sorry,
I just double checked.. Neither should be /dev/null.
You can send them to a file, then delete the file.. This was a change I think at 7.31 we could at 7.24, not since..
Tommy
I may be slow, but I get there !
Please use plain text.
Honored Contributor
Rainer von Bongartz
Posts: 1,015
Registered: ‎02-01-1999
Message 6 of 12 (1,327 Views)

Re: Informix: ontape -a error: Log backup to device '/dev/null' not allowed

Andrey

I don't see what you want to accomplish.

you wrote

I want to enable automatic logical logs backup on informix IDS

and later

but I don't want to backup logical logs.

Please tell us what your goal exactly is

Regards
Rainer
He's a real UNIX Man, sitting in his UNIX LAN making all his UNIX plans for nobody ...
Please use plain text.
Honored Contributor
Steve Lewis
Posts: 725
Registered: ‎05-18-2000
Message 7 of 12 (1,327 Views)

Re: Informix: ontape -a error: Log backup to device '/dev/null' not allowed

I think you actually want the logs to self-clear without needing an ontape. When LTAPEDEV is set to /dev/null you never need to run ontape -a or ontape -c because it regards the logs as always backed up. i.e. at the end of every log switch the engine automatically sets the flags back to U-B----

You may have an unprintable character in the onconfig file at that line which is causing it to mis-read it.

Completely delete the entire LTAPEDEV line using dd in vi, then re-enter

LTAPEDEV /dev/null # Log tape device path

Also put /dev/null next to TAPEDEV

Then bounce it again. Run ontape -s -L 0, then change TAPEDEV back to your normal device and bounce it again.


Please use plain text.
Advisor
Andrey Pevnev
Posts: 17
Registered: ‎12-20-2004
Message 8 of 12 (1,327 Views)

Re: Informix: ontape -a error: Log backup to device '/dev/null' not allowed

Yeah, Steve, that's what I want! :)

Ok, I will set LTAPEDEV to /dev/null and will no run onatpe -a, let's see will logical logs overflow or not. Thanks!
Please use plain text.
Frequent Advisor
Brian Butscher
Posts: 44
Registered: ‎05-07-2000
Message 9 of 12 (1,327 Views)

Re: Informix: ontape -a error: Log backup to device '/dev/null' not allowed

Andrey,

You can write your logical logs to /dev/null using 'ontape -c' not 'ontape -a'. Just change your LTAPEDEV /dev/null. By the way,
when you change your tape device for either LTAPEDEV or TAPEDEV you don't need to bounce IDS as these two parameters are read when you perform a database backup or logical log backup.

Regards,

Brian
Please use plain text.
Frequent Advisor
Brian Butscher
Posts: 44
Registered: ‎05-07-2000
Message 10 of 12 (1,327 Views)

Re: Informix: ontape -a error: Log backup to device '/dev/null' not allowed

Andrey,

I should have said that the 'ontape -c' or ontape -a is not needed. Your logical logs will continuously backup to /dev/null, which is what you want. We have two of our dev server running this way, no problems.

Regards,

Brian
Please use plain text.
Advisor
Andrey Pevnev
Posts: 17
Registered: ‎12-20-2004
Message 11 of 12 (1,326 Views)

Re: Informix: ontape -a error: Log backup to device '/dev/null' not allowed

Thanks, Brian!
Please use plain text.
Valued Contributor
rmueller58
Posts: 851
Registered: ‎02-19-2001
Message 12 of 12 (1,326 Views)

Re: Informix: ontape -a error: Log backup to device '/dev/null' not allowed

I am running IDS 7.31 fwiw, You CAN run the
TAPEDEV to /dev/null, LTAPEDEV still runs transactions logs, in order maintain record rollback transactions have to go to log. I don't think there is a way around and personally I'd not recommend it.
My nutsack would be hanging on my door if something happened and a database got some whacked data.. ontape takes very little CPU or memory but could well be a butt saver, from personal experience in having to recover from a mirror crash recently YOU DO want archives in addition to your exports. disk and tapes are cheap compared to getting 500 pissed off educators breathing down your throat.

You can set your transaction logging and archive to run to an NFS mount, Tape or local disk, but IMHO don't go with out..


Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation