Where to find Last Backup details ??

DBFinder · #1 (**permalink**) 11-24-11, 05:33

Hello All,

Can some one help me find info about most recent backup whether success or failure ?

I really don't know what backup method is being used; but is there a way to find alert log entries indicating a failure or success ??

Please show me an example.

Regards

DBFinder · #2 (**permalink**) 11-24-11, 10:34

Some one gave a clue to check alarm 16

How do we check alarms, is there any catalog table foe events or alarms ??

please help !!

begooden-it · #3 (**permalink**) 12-01-11, 08:51

Hi

look in the informix log file, and search for messages like this

Code:

2011-06-14 14:27:13 Level 0 Archive started on rootdbs, data01, data02
2011-06-14 14:28:14 Archive on rootdbs, data01, data02 Completed.

As per the backup methode, you have the choice between ontape and onbar.
You will find clues of which is being used by looking at the $ONCONFIG file.
* If the TAPEDEV parameter is filled with an existing device name, except /dev/null, chances are that the method used is ontape.
* look at the file named by the BAR_ACT_LOG parameter: if you see activity with relevant datetimes, and explicit events, you can say that onbar is used.

Hope this helps
Eric

DBFinder · #4 (**permalink**) 12-01-11, 09:12

Thanks, Eric, sure this has helped me.

This is complete info long awaited.

Thanks

begooden-it · #5 (**permalink**) 12-01-11, 09:24

My pleasure :-)

DBFinder · #6 (**permalink**) 12-03-11, 12:46

Mr Eric,

Thanks for your help, glad that I have written a function to help one of my co-worker dba.

This place is using onbar via netbackup. I wanted to cover other possibility - ontape.

Is this possible to find any activity log file for ontape. Or can you sum up few lines in such log file ?

Best Regards

DBFinder · #7 (**permalink**) 12-03-11, 13:46

BTW,

My Message log does not have the date part as you indicated. That is making it hard to process.

rgds

begooden-it · #8 (**permalink**) 12-03-11, 13:54

Mr DBFinder :-)

Could you post your informix log file ( value of MSGPATH in your $ONCONFIG file) So I can take a look at it?

If too big, this can be via ftp.

By the way, what version of IDS do you run?

Cheers
Eric

DBFinder · #9 (**permalink**) 12-03-11, 14:07

Attached,

It was too big , so I truncated.
Rgds

Code:

Sun Jun 13 11:30:29 2004

11:30:29  Checkpoint Completed:  duration was 0 seconds.
11:30:29  Checkpoint loguniq 10, logpos 0x15b018

11:30:32  Level 0 Archive started on rootdbs, physical, logical, dsc01, dsc02, dsc03, dsc04, dsc05, dsc06, dsc07, dsc09, dsc08, dsc10, dsc11
11:35:10  Archive on rootdbs, physical, logical, dsc01, dsc02, dsc03, dsc04, dsc05, dsc06, dsc07, dsc09, dsc08, dsc10, dsc11 Completed.
11:35:11  Checkpoint Completed:  duration was 0 seconds.
11:35:11  Checkpoint loguniq 10, logpos 0x15c358

11:55:34  Checkpoint Completed:  duration was 0 seconds.
11:55:34  Checkpoint loguniq 10, logpos 0x16b018

12:15:46  Checkpoint Completed:  duration was 0 seconds.
12:15:46  Checkpoint loguniq 10, logpos 0x16c018


Sun Jun 20 11:30:29 2004

11:30:29  Checkpoint Completed:  duration was 0 seconds.
11:30:29  Checkpoint loguniq 10, logpos 0x16d018

11:30:29  Level 0 Archive started on rootdbs, physical, logical, dsc01, dsc02, dsc03, dsc04, dsc05, dsc06, dsc07, dsc09, dsc08, dsc10, dsc11
11:34:57  Archive on rootdbs, physical, logical, dsc01, dsc02, dsc03, dsc04, dsc05, dsc06, dsc07, dsc09, dsc08, dsc10, dsc11 Completed.
11:34:58  Checkpoint Completed:  duration was 0 seconds.
11:34:58  Checkpoint loguniq 10, logpos 0x16e358

11:55:05  Checkpoint Completed:  duration was 0 seconds.
11:55:05  Checkpoint loguniq 10, logpos 0x17d018

12:15:17  Checkpoint Completed:  duration was 0 seconds.
12:15:17  Checkpoint loguniq 10, logpos 0x17e018


Sun Jun 27 11:30:31 2004

11:30:31  Checkpoint Completed:  duration was 0 seconds.
11:30:31  Checkpoint loguniq 10, logpos 0x17f018

11:30:31  Level 0 Archive started on rootdbs, physical, logical, dsc01, dsc02, dsc03, dsc04, dsc05, dsc06, dsc07, dsc09, dsc08, dsc10, dsc11
11:34:35  Archive on rootdbs, physical, logical, dsc01, dsc02, dsc03, dsc04, dsc05, dsc06, dsc07, dsc09, dsc08, dsc10, dsc11 Completed.
11:34:35  Checkpoint Completed:  duration was 0 seconds.
11:34:35  Checkpoint loguniq 10, logpos 0x180358

11:54:41  Checkpoint Completed:  duration was 0 seconds.
11:54:41  Checkpoint loguniq 10, logpos 0x18f018

12:14:53  Checkpoint Completed:  duration was 0 seconds.
12:14:53  Checkpoint loguniq 10, logpos 0x190018


Tue Jun 29 15:06:34 2004

15:06:34  Checkpoint Completed:  duration was 0 seconds.
15:06:34  Checkpoint loguniq 10, logpos 0x227018

15:26:48  Checkpoint Completed:  duration was 0 seconds.
15:26:48  Checkpoint loguniq 10, logpos 0x231018

15:47:01  Checkpoint Completed:  duration was 0 seconds.
15:47:01  Checkpoint loguniq 10, logpos 0x232018


Wed Jun 30 09:37:58 2004

09:37:58  Checkpoint Completed:  duration was 0 seconds.
09:37:58  Checkpoint loguniq 10, logpos 0x238018

09:58:11  Checkpoint Completed:  duration was 0 seconds.
09:58:11  Checkpoint loguniq 10, logpos 0x23b018

10:18:24  Checkpoint Completed:  duration was 0 seconds.
10:18:24  Checkpoint loguniq 10, logpos 0x23c018


Sun Jul  4 11:30:31 2004

11:30:31  Checkpoint Completed:  duration was 0 seconds.
11:30:31  Checkpoint loguniq 10, logpos 0x23d018

11:30:31  Level 0 Archive started on rootdbs, physical, logical, dsc01, dsc02, dsc03, dsc04, dsc05, dsc06, dsc07, dsc09, dsc08, dsc10, dsc11
11:34:52  Archive on rootdbs, physical, logical, dsc01, dsc02, dsc03, dsc04, dsc05, dsc06, dsc07, dsc09, dsc08, dsc10, dsc11 Completed.
11:34:52  Checkpoint Completed:  duration was 0 seconds.
11:34:52  Checkpoint loguniq 10, logpos 0x23e358

11:55:12  Checkpoint Completed:  duration was 0 seconds.
11:55:12  Checkpoint loguniq 10, logpos 0x24d018

12:15:24  Checkpoint Completed:  duration was 0 seconds.
12:15:24  Checkpoint loguniq 10, logpos 0x24e018


Tue Jul  6 10:43:41 2004

10:43:41  Checkpoint Completed:  duration was 0 seconds.
10:43:41  Checkpoint loguniq 10, logpos 0x25e018

11:03:53  Checkpoint Completed:  duration was 0 seconds.
11:03:53  Checkpoint loguniq 10, logpos 0x25f018

11:24:05  Checkpoint Completed:  duration was 0 seconds.
11:24:05  Checkpoint loguniq 10, logpos 0x260018

15:06:27  Checkpoint Completed:  duration was 0 seconds.
15:06:27  Checkpoint loguniq 10, logpos 0x263018

15:26:40  Checkpoint Completed:  duration was 0 seconds.
15:26:40  Checkpoint loguniq 10, logpos 0x264018

15:46:46  Checkpoint Completed:  duration was 0 seconds.
15:46:46  Checkpoint loguniq 10, logpos 0x265018


Sun Jul 11 11:30:28 2004

11:30:28  Checkpoint Completed:  duration was 0 seconds.
11:30:28  Checkpoint loguniq 10, logpos 0x266018

11:30:29  Level 0 Archive started on rootdbs, physical, logical, dsc01, dsc02, dsc03, dsc04, dsc05, dsc06, dsc07, dsc09, dsc08, dsc10, dsc11
11:35:16  Archive on rootdbs, physical, logical, dsc01, dsc02, dsc03, dsc04, dsc05, dsc06, dsc07, dsc09, dsc08, dsc10, dsc11 Completed.
11:35:16  Checkpoint Completed:  duration was 0 seconds.
11:35:16  Checkpoint loguniq 10, logpos 0x267358

11:55:29  Checkpoint Completed:  duration was 0 seconds.
11:55:29  Checkpoint loguniq 10, logpos 0x276018

12:15:41  Checkpoint Completed:  duration was 0 seconds.
12:15:41  Checkpoint loguniq 10, logpos 0x277018


Thu Jul 15 12:54:29 2004

12:54:29  Checkpoint Completed:  duration was 0 seconds.
12:54:29  Checkpoint loguniq 10, logpos 0x279018

DBFinder · #10 (**permalink**) 12-03-11, 14:12

Code:

IBM Informix Dynamic Server Version 9.40.FC3     -- On-Line -- Up 30 days 23:32:13 -- 484656 Kbytes

DBFinder · #11 (**permalink**) 12-03-11, 14:21

Code:

IBM Informix Dynamic Server Version 11.50.FC9DE -- On-Line (CKPT REQ) -- Up 00:00:16 -- 149744 Kbytes
Blocked:CKPT

Code:

Sun Nov 20 21:39:32 2011

21:39:32 Event alarms enabled. ALARMPROG = '/opt/IBM/informix/etc/alarmprogram.sh'
21:39:32 Booting Language <c> from module <>
21:39:32 Loading Module <CNULL>
21:39:32 Booting Language <builtin> from module <>
21:39:32 Loading Module <BUILTINNULL>
21:39:38 DR: DRAUTO is 0 (Off)
21:39:38 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
21:39:38 Warning: shared-memory connection file '/INFORMIXTMP/.inf.centos55x64' is overwritten. This file might
belong to another instance of IDS server. If the service name of the IDS
database server is not unique in the environment of the host computer where
the database server resides, rename the service.
21:39:38 IBM Informix Dynamic Server Version 11.50.FC9DE Software Serial Number AAA#B000000
21:39:39 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.

21:39:39 Started 1 B-tree scanners.
21:39:39 B-tree scanner threshold set at 5000.
21:39:39 B-tree scanner range scan size set to -1.
21:39:39 B-tree scanner ALICE mode set to 6.
21:39:39 B-tree scanner index compression level set to med.
21:39:39 Physical Recovery Started at Page (1:7062).
21:39:39 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
21:39:39 Logical Recovery Started.
21:39:39 10 recovery worker threads will be started.
21:39:39 Logical Recovery has reached the transaction cleanup phase.
21:39:39 Checkpoint Completed: duration was 0 seconds.
21:39:39 Sun Nov 20 - loguniq 6, logpos 0xe25018, timestamp: 0x7d0ac Interval: 694

21:39:39 Maximum server connections 0
21:39:39 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 1

21:39:39 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

21:39:40 Dataskip is now OFF for all dbspaces
21:39:41 Checkpoint Completed: duration was 0 seconds.
21:39:41 Sun Nov 20 - loguniq 6, logpos 0xe27018, timestamp: 0x7d0c9 Interval: 695

21:39:41 Maximum server connections 0
21:39:41 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2

21:39:41 On-Line Mode
21:39:42 SCHAPI: Started dbScheduler thread.
21:39:43 Booting Language <spl> from module <>
21:39:43 Loading Module <SPLNULL>
21:39:43 SCHAPI: Started 2 dbWorker threads.
21:39:44 SCHAPI: [Auto Update Statistics Refresh 19-4] Error -206 The specified table (aus_cmd_info) is not in the database.

begooden-it · #12 (**permalink**) 12-03-11, 14:26

Ok,

with ontape, the only info you'll have are the lines timestamped 11:30:29 and 11:30:29
( archive started and archive completed ).
If errors occur, you should see them with ERROR and archive in the string

If you don't have the "Archive.*Completed' regexp, you backed has not finished.

Regarding the date thing, I have my own msgpath parser that builds the complete timestamp ( yyyy-mm-dd HH:MM

S ) :-). It is written in Perl

DBFinder · #13 (**permalink**) 12-03-11, 14:28

Cool,

Thank you.

begooden-it · #14 (**permalink**) 12-03-11, 14:35

By the way again,

did you test the 11.70 Innovator-C Edition ( xC4 latest release ), which
is a free edition for production environment ?

You will be limited to 4 CPU VPs and 2Gb of shared memory, but this can help...
No chunk size limits.

You can find it here:
You can even download the Ultimate Edition ( no limits at all, except for a period of 30 days I think).

Maaaany new functionality, general perf enhancement by 30% or more, a really beautiful product!
And candidate to install the Informix Warehouse Accelerator too...
Eric