Welcome to my world. A world where I'm unable to find any good reporting
tools for NDMP backups.
I asked a question like this about 2 weeks ago on the forum. I
had a few responses but not exactly what I was looking for.
I've started on my own query and this is what I have come up
with so far.
The actlog is useless, as the volume is not listed at the
completion, I have gone with the backup table: A report that will list
the q-trees that have not been backed up in the last 24 hours.
Name: MISSED_NETAPP_BACKUPS
Line Number: 1
Command: select backups.node_name,
backups.filespace_name,
vfsmappings.filespace_name,
backups.type,
backups.backup_date as "Last Backup
Date" from
backups, vfsmappings where
backups.filespace_name like
vfsmappings.virtual_fs_name and
backups.type<>'TOC' and BACKUP_DATE <
current_timestamp -1 day and
STATE='ACTIVE_VERSION'
You will notice that we are backing up at the qtree level, so we
are looking at the vfsmappings table, if you are backing up at the
volume level, it would have to be a little different.
It's a work in progress, as the format is still not quite what
I'm looking for.
Ben
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Joni Moyer
Sent: Tuesday, May 10, 2005 9:09 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: NAS Report through the ACTLOG table
Hi Iain,
Yes, it's very beneficial. Thanks! Here is my output. I am just
trying to get the name of the filesystem that is being backed up for
this process to be reported within this script as well and I can't seem
to figure out how to join this select statement with the actlog to
associate it and find the filesystem info. I'm pretty positive that it
can be done, but I haven't been successful so far. Thank you for your
help!
NODE_NAME: NAS_SERVER_2_OFFSITE
DATE: 2005-05-10
ACTIVITY: NAS Backup
START: 00:15:14
END: 00:16:26
length: 00:01:12
MB: 46
FILES: 0
SUCCESSFUL: YES
********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
joni.moyer AT highmark DOT com
********************************
"Iain Barnetson"
<Iain.Barnetson@H
ALLIBURTON.COM>
To
Sent by: "ADSM: ADSM-L AT VM.MARIST DOT EDU
Dist Stor
cc
Manager"
<[email protected]
Subject
.EDU> Re: NAS Report through the ACTLOG
table
05/10/2005 10:52
AM
Please respond to
"ADSM: Dist Stor
Manager"
<[email protected]
.EDU>
Joni,
Is this any use to you:
select entity as node_name, date(start_time) as date, cast(activity as -
varchar(10)) as activity, -
time(start_time) as start,time(end_time) as end, -
cast(substr(cast(end_time-start_time as char(20)),3,8) as char(8)) as
"Length", -
cast(bytes/1024/1024 as decimal(6,0)) as - megabytes,cast(affected as
decimal(7,0)) as files, successful from summary where -
start_time>=current_timestamp - 1 day and (entity like 'ABZ%' or entity
like 'NAS%') - and (activity='BACKUP' or activity='NAS Backup') - order
by start, node_name
Regards,
Iain Barnetson
IT Systems Administrator
UKN Infrastructure Operations
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Joni Moyer
Sent: 10 May 2005 15:38
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] NAS Report through the ACTLOG table
Hello Everyone,
If the previous message concerning a select statement cannot be run,
then I found the message numbers within the activity log that contain
the information that I need: 1064 & 988. I ran the following:
select date(date_time) as "Date",time(date_time) as
"Time",message,process from actlog where date_time>(current_timestamp -
1 day) and msgno in
(1064,988) order by process
and received this:
2005-05-09 19:00:29 ANR1064I Differen 5684
tial backup of N
AS node NAS_SERV
ER_3, file system
/.etc_common, st
arted as process
5684 by adminis
trator LID3QE9.
(SESSION: 294768,
PROCESS: 5684)
2005-05-09 19:05:47 ANR0988I Process 5684
5684 for BACKUP
NAS (DIFFERENTIA
L) running in the
FOREGROUND proce
ssed 65,536 bytes
with a completion
state of SUCCESS
at 19:05:47. (S
ESSION: 294768,
PROCESS: 5684)
Is there a way to pull information out of the following output to just
look like a table with the following information:
Date
Begin Time
End Time
NAS_Server_#
Filesystem
Process#
Differential/Full
MB Backed up
Completion State
Thank you in advance! I am really trying to get an exact way to receive
a detailed NDMP backup report and just can't seem to get what I want.
********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
joni.moyer AT highmark DOT com
********************************
----------------------------------------------------------------------
This e-mail, including any attached files, may contain confidential and
privileged information for the sole use of the intended recipient. Any
review, use, distribution, or disclosure by others is strictly
prohibited.
If you are not the intended recipient (or authorized to receive
information for the intended recipient), please contact the sender by
reply e-mail and delete all copies of this message.
|