Re: Archives missing from archive list.
On May 8, 2005, at 11:45 PM, Stuart Lamble wrote: ...It would be nice to know why this is happening, ... The Archive facility is very much filespace-oriented: If you archive into one filespace, you can't expect to list its files by querying from another filespace. Backup, Archive, and HSM all have very different orientations. Richard Sims
Re: Archives missing from archive list.
As usual Richard is correct Syntax -Query ARchive--+--+--+- filespec---+ '- options-' '- filespec-' Parameters filespec Specifies the path and file name that you want to query. Use wildcard characters to specify a group of files or all the files in a directory. If you use wildcard characters, enclose the file specification in double quotation marks. Specify an asterisk (*) to query all archived files in the current directory. ^^ H. Milton Johnson -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: Monday, May 09, 2005 6:16 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Archives missing from archive list. On May 8, 2005, at 11:45 PM, Stuart Lamble wrote: ...It would be nice to know why this is happening, ... The Archive facility is very much filespace-oriented: If you archive into one filespace, you can't expect to list its files by querying from another filespace. Backup, Archive, and HSM all have very different orientations. Richard Sims
Archives missing from archive list.
Greetings all. This one has me baffled, and whilst I'd normally spend more time investigating, I'm going on leave tomorrow for three days, and other parties view this as sufficiently urgent that I want to resolve it if possible before then. Basically, we have a number of applications based around Oracle databases (eg: SAP); these are backed up using the archive facility of TSM (yes, I'm aware of the inherent contradiction in that statement.) As an example of the problem, I have logs from the client that claim that the command: dsmc archive -description=CDUT_WEEKLY_07/05/05 01:00 - compression=no -archmc=DDB_WEEKLY_8WR_1 /space/CDUT/data/sis_d4.dbf completed successfully. Investigating the activity log for the appropriate time also indicates that the archive completed successfully. However, if I then run, on the archiving client, the command: dsmc q archive / -subdir=yes | grep CDUT_WEEKLY_07 I get back nothing -- there are entries for March or so, but definitely not for May. In comparison, if I run the command select description from archive where node_name='(source host)' and look through the output, I see CDUT_WEEKLY_07/05/05 01:00 in the list. All of this combined suggests to me that the data is there; it's just that the query archive command, for some unknown reason, isn't reporting it. Anybody have any suggestions on what to do next? Many thanks in advance, Stuart.
Re: Archives missing from archive list.
Make sure you are doing the q archive as the same userid (oracle perhaps) that performed the archive in the first place. On Mon, 9 May 2005 11:41:25 +1000, Stuart Lamble wrote: Greetings all. This one has me baffled, and whilst I'd normally spend more time investigating, I'm going on leave tomorrow for three days, and other parties view this as sufficiently urgent that I want to resolve it if possible before then. Basically, we have a number of applications based around Oracle databases (eg: SAP); these are backed up using the archive facility of TSM (yes, I'm aware of the inherent contradiction in that statement.) As an example of the problem, I have logs from the client that claim that the command: dsmc archive -description=CDUT_WEEKLY_07/05/05 01:00 - compression=no -archmc=DDB_WEEKLY_8WR_1 /space/CDUT/data/sis_d4.dbf completed successfully. Investigating the activity log for the appropriate time also indicates that the archive completed successfully. However, if I then run, on the archiving client, the command: dsmc q archive / -subdir=yes | grep CDUT_WEEKLY_07 I get back nothing -- there are entries for March or so, but definitely not for May. In comparison, if I run the command select description from archive where node_name='(source host)' and look through the output, I see CDUT_WEEKLY_07/05/05 01:00 in the list. All of this combined suggests to me that the data is there; it's just that the query archive command, for some unknown reason, isn't reporting it. Anybody have any suggestions on what to do next? Many thanks in advance, Stuart. Ian Hobbs [EMAIL PROTECTED] === Never argue with an idiot. They drag you down to their level then beat you with experience. -Dilbert
Re: Archives missing from archive list.
On 09/05/2005, at 1:34 PM, Ian Hobbs wrote: Make sure you are doing the q archive as the same userid (oracle perhaps) that performed the archive in the first place. Nice try, but I get back the exact same results: absolutely no mention of the (for instance) CDUT_WEEKLY_07/05/05 01:00 archive, even when the command is run as oracle. In fact, to the best of my knowledge, I get the same results as root as if I'm logged in (via su) as oracle. Unless using su to access the account in question makes a difference, but I would be *extremely* surprised if that were so. If that was all it was, I wouldn't have been prompted to look into this in the first place. :) My thanks nonetheless. [snippage]
Re: Archives missing from archive list.
This could be a really long shot.
try
dsmc q archive {insert the source filespace name here}/* -subdir=yes | grep
CDUT_WEEKLY_07
It appears that the request is for any archive off the root filespace.
Possible. I'm quite away from a unix system at the moment, and was only able to
check using my home windows server.
I've been getting varying results that don't make much sence. example, the dsmc
q ar * -su=yes show me all archives from my C drive, but not my E
drive, but if I do a q ar e:\* -su=yes then I see the E drive archives.
H
On Mon, 9 May 2005 13:06:53 +1000, Stuart Lamble wrote:
On 09/05/2005, at 1:34 PM, Ian Hobbs wrote:
Make sure you are doing the q archive as the same userid (oracle
perhaps) that performed the archive in the
first place.
Nice try, but I get back the exact same results: absolutely no
mention of the (for instance) CDUT_WEEKLY_07/05/05 01:00 archive,
even when the command is run as oracle. In fact, to the best of my
knowledge, I get the same results as root as if I'm logged in (via
su) as oracle. Unless using su to access the account in question
makes a difference, but I would be *extremely* surprised if that were
so.
If that was all it was, I wouldn't have been prompted to look into
this in the first place. :) My thanks nonetheless.
[snippage]
Ian Hobbs
[EMAIL PROTECTED]
===
Never argue with an idiot. They drag you down to their level then beat
you with experience.
-Dilbert
Re: Archives missing from archive list.
On 09/05/2005, at 2:35 PM, Ian Hobbs wrote:
This could be a really long shot.
try
dsmc q archive {insert the source filespace name here}/* -
subdir=yes | grep CDUT_WEEKLY_07
It appears that the request is for any archive off the root
filespace. Possible. I'm quite away from a unix system at the
moment, and was only able to
check using my home windows server.
I've been getting varying results that don't make much sence.
example, the dsmc q ar * -su=yes show me all archives from my C
drive, but not my E
drive, but if I do a q ar e:\* -su=yes then I see the E drive
archives.
H
Bingo. Thank you *very* much for that. I'll pass that on to the DBA;
hopefully that will calm her down. :-)
It would be nice to know why this is happening, but in the absence of
that knowledge, I'll take any solution I can grab. Especially since
it seems to give some of the older archives from the same
filesystem... *shrugs*
Again, many, many thanks.
Stuart.
Re: Archives missing from archive list.
Perhaps at one point the data was simply in a sub directory of the root
filesystem.
On Mon, 9 May 2005 13:45:26 +1000, Stuart Lamble wrote:
On 09/05/2005, at 2:35 PM, Ian Hobbs wrote:
This could be a really long shot.
try
dsmc q archive {insert the source filespace name here}/* -
subdir=yes | grep CDUT_WEEKLY_07
It appears that the request is for any archive off the root
filespace. Possible. I'm quite away from a unix system at the
moment, and was only able to
check using my home windows server.
I've been getting varying results that don't make much sence.
example, the dsmc q ar * -su=yes show me all archives from my C
drive, but not my E
drive, but if I do a q ar e:\* -su=yes then I see the E drive
archives.
H
Bingo. Thank you *very* much for that. I'll pass that on to the DBA;
hopefully that will calm her down. :-)
It would be nice to know why this is happening, but in the absence of
that knowledge, I'll take any solution I can grab. Especially since
it seems to give some of the older archives from the same
filesystem... *shrugs*
Again, many, many thanks.
Stuart.
Ian Hobbs
[EMAIL PROTECTED]
===
Never argue with an idiot. They drag you down to their level then beat
you with experience.
-Dilbert
