ment Viadukstrasse 42, P.O. Box 4002 Basel/CH
Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01
Direct: +41 (61) 226 19 78
e-mail: [EMAIL PROTECTED]
**
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
scottcorp
Sent: Friday, 07 September, 2007 0
:29 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Full Backup Size Report
Thanks again to all - the "export node nodename filedata=backupactive
preview-yes" works, but I would love to get this into a SQL statement or
something so I dont have to look at the console or actlog to retrie
Thanks again to all - the "export node nodename filedata=backupactive
preview-yes" works, but I would love to get this into a SQL statement or
something so I dont have to look at the console or actlog to retrieve the
output.
I have been trying for a few hours to get this going but have never re
Outside of some of the TDP Agents, yes, there is only one active copy of a
file. The Oracle TDP agent stores all data as active, so the Export
command would show all data for that node. For Agent backups, I usually
guesstimate the restore time as 150% of the time for a full backup. It's
always h
scottcorp wrote:
> THanks for the replies. SO here is a dumb question - is there only one
> active copy of a file? I am thinking so, but want to make sure.
>
> My goal is to get this one time for all the machines - there are a lot but
> not hundreds.
>
>
Yes. You can have as many inactive copie
THanks for the replies. SO here is a dumb question - is there only one active
copy of a file? I am thinking so, but want to make sure.
My goal is to get this one time for all the machines - there are a lot but not
hundreds.
+-
If you only have to do a specific few machines, and not on a regular basis,
you can do an "export node NODENAME FILEData=active PREVIEW=yes"
The result of this will tell you how much active data the node has. I've
also tried a Select statement, multiplying the capacity by pct_utilized in
the file
of the SQL gurus on this list could hammer it out.
Ben
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
scottcorp
Sent: Wednesday, September 05, 2007 12:50 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Full Backup Size Report
Hello. I have a need to provid
Hello. I have a need to provide a report that details how much data each
client has if I were to perform one full backup or restore of the server. I am
pulling my hair out trying to figure out the right select statement to query
the information. Has anyone done this before and can you please