ADSM-L

Re: SQL query

2000-07-06 11:49:59
Subject: Re: SQL query
From: Michel Engels <Michel.Engels AT DEVOTEAM DOT BE>
Date: Thu, 6 Jul 2000 16:49:59 +0100
To see the Oracle archive you could try by replacing the archives in the select
by backups. In fact all backups created via the agent are backups for TSM (when
Oracle works the same as the SQL agent we installed) so this would mean:

select * from backups where node_name='MYNODE'

Good luck,

Michel Engels




"Loon, E.J. van - SPLXM" <Eric-van.Loon AT KLM DOT NL> on 07/06/2000 03:09:44 PM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

To:   ADSM-L AT VM.MARIST DOT EDU
cc:    (bcc: Michel Engels/BE/Devoteam)

Subject:  Re: SQL query



Hi Uwe and Dwight!
Thanks for your reply!
The select * from archives where node_name='MYNODE' does produce the output
I was looking for. There is only one downside, for some reason it does not
list the archives created by the Oracle Connect Agent... And that's what I
was hoping to use this query for.
I was hoping to produce a list of archives for this node so that the Oracle
Administrator could compare this list against his Oracle Recovery Catalog to
scan for differences. Guess this won't be possible...
Kindest regards,
Eric van Loon


<Prev in Thread] Current Thread [Next in Thread>