Veritas-bu

Re: [Veritas-bu] locate database files in clients system level backups

2009-02-27 14:24:03
Subject: Re: [Veritas-bu] locate database files in clients system level backups
From: "Jeff Lightner" <jlightner AT water DOT com>
To: "Stump, Bob A" <Bob.A.Stump AT fnis DOT com>, <veritas-bu AT mailman.eng.auburn DOT edu>
Date: Fri, 27 Feb 2009 14:07:01 -0500

Why not just do a bpflist on the backupid to determine what files it had?

 

What I typically do is:

 

bpimmedia -L -policy <POLICY>  -d mm/dd/ccyy hh:mm:ss -e mm/dd/ccyy hh:mm:ss

 

where -d = start time and -e = end time of the backup you're interested in.

 

 

Or use bpimagelist:

bpimagelist -L -policy <POLICY>  -d mm/dd/ccyy hh:mm:ss -e mm/dd/ccyy hh:mm:ss

 

You can pipe that through “grep <hostname>_” to get just the backupids for the backup.

 

You can then run a bpflist on those images to see which files were backed up:

bpflist -backupid <backupid from above> -d mm/dd/ccyy hh:mm:ss -e mm/dd/ccyy -rl 999

NOTE:  If client/media server is not the master then add "-client <clientname>".

 

 

 


From: veritas-bu-bounces AT mailman.eng.auburn DOT edu [mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of Stump, Bob A
Sent: Friday, February 27, 2009 1:47 PM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] locate database files in clients system level backups

 

 Hello,

I have a thousand clients on several sites throughout the U.S. I want to be able to determine if a client has a database on it that is getting copied to tape by a NetBackup system level backup. I thought that perhaps I could use the NetBackup image catalog.  I was thinking that I could uncompress and convert the clients image files to ascii using bpcatlist/cat_convert and search for .dbf, .mdf, .ldf etc… in the files. Has anybody done this that could help me get started?

Thanks,

Bob Stump

 

 

_____________

The information contained in this message is proprietary and/or confidential. If you are not the
intended recipient, please: (i) delete the message and all copies; (ii) do not disclose,
distribute or use the message in any manner; and (iii) notify the sender immediately. In addition,
please be aware that any message addressed to our domain is subject to archiving and review by
persons other than the intended recipient. Thank you.
_____________

 
Please consider our environment before printing this e-mail or attachments.
----------------------------------
CONFIDENTIALITY NOTICE: This e-mail may contain privileged or confidential information and is for the sole use of the intended recipient(s). If you are not the intended recipient, any disclosure, copying, distribution, or use of the contents of this information is prohibited and may be unlawful. If you have received this electronic transmission in error, please reply immediately to the sender that you have received the message in error, and delete it. Thank you.
----------------------------------
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
<Prev in Thread] Current Thread [Next in Thread>