root# dsmc q b "{/adsmorc}/*" -ina -subdir=yes
This is on a Unix machine. It doesn't matter at all if the backups are
done through rman client or not. All TSM sees is the node and the
filespaces; TSM server knows nothing of RMAN.
It's good to idea to keep the b/a client and TDPO nodes separate and in
different Policy Domains. So, if you need to the actually file
representations in TSM to find out what is taking up space, then change the
b/a client's dsm.* files to match that of the api/TDPO's same files and
perform the above query. Or make a copy of the b/a file, change them to
match, and then reference the different config files in the dsmc command.
The {} marks enclose the filespace name. If you leave them out, the query
assumes a filespace name that could be different then the one you are
intending to query. I am not sure about doing it from a remote machine, I
have not tried the -node option.
The result I get from the above command on my servers look is something like
this:
IBM Tivoli Storage Manager
Command Line Backup/Archive Client Interface - Version 5, Release 2, Level
0.0
(c) Copyright by IBM Corporation and other(s) 1990, 2003. All Rights
Reserved.
Node Name: XXXX
Session established with server XXXX: Solaris 7/8
Server Version 4, Release 2, Level 4.1
Server date/time: 03/30/04 16:58:22 Last access: 03/30/04 16:57:56
Size Backup Date Mgmt Class A/I File
---- ----------- ---------- --- ----
API 12,275,712 KB 12/16/03 01:00:32 DEFAULT A
/adsmorc//6of93lgk_1_1
API 3,989,504 KB 12/16/03 03:06:03 DEFAULT A
/adsmorc//6pf93srg_1_1
API 12,275,712 KB 12/17/03 03:00:38 DEFAULT A
/adsmorc//6rf96gtp_1_1
API 3,989,504 KB 12/17/03 03:48:56 DEFAULT A
/adsmorc//6sf96jnl_1_1
API 12,275,712 KB 12/18/03 03:00:33 DEFAULT A
/adsmorc//6uf9959l_1_1
API 3,989,504 KB 12/18/03 03:12:57 DEFAULT A
/adsmorc//6vf9960l_1_1
API 429,056 KB 12/19/03 15:38:28 DEFAULT A
/adsmorc//72f9d62r_1_1
API 1,507,328 KB 12/19/03 15:56:37 DEFAULT A
/adsmorc//74f9d74t_1_1
API 1,519,616 KB 12/19/03 16:21:07 DEFAULT A
/adsmorc//75f9d8ir_1_1
API 1,456,128 KB 12/19/03 18:08:29 DEFAULT A
/adsmorc//7af9des4_1_1
API 1,496,064 KB 12/19/03 18:23:00 DEFAULT A
/adsmorc//7bf9dfnb_1_1
.
.
.
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Warren, Matthew (Retail)
Sent: Thursday, April 01, 2004 06:33
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: AW: TDP for Oracle
Would this work?
Dsmc q ba -subdir=y -node=MOXB1F drive:\path\to\file\orc_moxb1f_rmantest
?
I'm assuming you just want to check a file backed up through a normail dsmc
I or dsmc sel command, although I can see the phrase 'rman' in your
filespec...
What do the { and }'s mean in your command shown below? I havent come across
that as a way of specifying files on a windows machine before.
If you are trying to query for an rman backed-up object, then I think you
will need to be using the rman / TDPOracle interface to do it.
Matt.
-----Original Message-----
From: Frank Scolieri <frank.scolieri.b AT BAYER DOT COM>@EME
Sent: Monday, March 29, 2004 8:48 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: AW: TDP for Oracle
When I attempt to run the query command on Windows I
receive the
following error message:
C:\Program Files\Tivoli\TSM\baclient>dsmc q ba -subdir=yes
-node=MOXB1F
{"\orc_moxb1f_rmantest"}
Tivoli Storage Manager
Command Line Backup Client Interface - Version 4, Release 2,
Level 2.0
(C) Copyright IBM Corporation, 1990, 2001, All Rights
Reserved.
Node Name: MOXB1F
Session established with server F17_ADSM: AIX-RS/6000
Server Version 5, Release 1, Level 7.3
Server date/time: 03/29/2004 14:44:05 Last access:
03/29/2004 14:39:08
ANS1081E Invalid search file specification
'{\ORC_MOXB1F_RMANTEST' entered
C:\Program Files\Tivoli\TSM\baclient>
Any suggestions as to why I am receiving this error?
***************
"Thomas Rupp, Vorarlberger Illwerke AG"
<Thomas.Rupp AT ILLWERKE DOT AT>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
03/26/2004 10:57 AM
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To
ADSM-L AT VM.MARIST DOT EDU
cc
Subject
AW: TDP for Oracle
On Windows I use: DSMC QUERY BACKUP -SUBDIR=YES -NODE=xx
{\adsmorc}*
On UNIX: DSMC QUERY BACKUP "/adsmorc/*"
-SUBDIR=YES
-VIRTUALN=xx
You have to replace \adsmorc with the name of your TDPO
filespace.
Thomas Rupp
-----Urspr|ngliche Nachricht-----
Von: Frank Scolieri [mailto:frank.scolieri.b AT BAYER DOT COM]
Gesendet: Freitag, 26. Mdrz 2004 16:54
An: ADSM-L AT VM.MARIST DOT EDU
Betreff: TDP for Oracle
Is there a way to query all files backed up through TDP for
Oracle?
Thanks
___________________________ Disclaimer Notice __________________________
This message and any attachments are confidential and should only be read
by those to whom they are addressed. If you are not the intended recipient,
please contact us, delete the message from your computer and destroy any
copies. Any distribution or copying without our prior permission is
prohibited.
Internet communications are not always secure and therefore the Powergen
Group does not accept legal responsibility for this message. The recipient
is responsible for verifying its authenticity before acting on the
contents. Any views or opinions presented are solely those of the author
and do not necessarily represent those of the Powergen Group.
Registered addresses:
Powergen UK plc, Westwood Way, Westwood Business Park,
Coventry CV4 8LG.
Registered in England & Wales No. 2366970
Powergen Retail Limited, Westwood Way, Westwood Business Park,
Coventry CV4 8LG.
Registered in England and Wales No: 3407430
Telephone +44 (0) 2476 42 4000
Fax +44 (0) 2476 42 5432
|