hi,

You can issue server sql commands to see the information you want.  The
commands will work for any kind of backup, not only for Oracle.

> select * from backups where node_name='your-nodename-in-cap-letters' AND
filespace_name='your-file-space-name-as-it-is'

another command:
> select * from contents where node_name='your-nodename-in-cap-letters'
AND filespace_name='your-file-space-name-as-it-is'

For example, if your nodename is test and filespace name is /adsmorc:

> select * from backups where node_name='TEST' AND
filespace_name='/adsmorc'

regards,
Thiha

To:   ADSM-L AT VM.MARIST DOT EDU
cc:

Subject:  Oracle Question


We have oracle database on NT and TSM on AIX. Looking at the client node,
under FileSpace Name I find \adsmorc which does not show the size.  How
can
I find out how much is backed up?

Mehdi Amini
LAN/WAN Engineer
ValueOptions
3110 Fairview Park Drive
Falls Church, VA 22042
Phone: 703-208-8754
Fax: 703-205-6879