On Tue, Mar 01, 2005 at 06:03:52PM -0500, Kovarski, Mark wrote:
> Hi,
>
> We have RMAN setup with TDP for Oracle (on TSM of course). The backups
> are kicked off by cron on the client. Is there a way to monitor these
> backups? Any SQL statements that can be used for that. Any tables that
> can be looked at for completion times, data transferred etc.
>
> Or any other recommendations?
Look in
q sess
or macro
<snip>
/*  -----------------------------------------*/
/*  Script Name: Q_RMAN_SESSION_THRUPUT      */
/*  Description: Query RMAN throughput       */
/*  Parameter:   $1 = Node_name              */
/*  Parameter:   $2 = date                   */
/*  Parameter:   $3 = time                   */
/*  Example: run Q_RMAN_SESSION_THRUPUT $1 $2 $3*/
/*  -----------------------------------------*/
select  sum(BYTES) as "Summe Bytes seit $3" -
from summary -
where -
ENTITY=upper('$1') and ACTIVITY='BACKUP' and -
start_time>='$2 $3' and -
end_time<=current_timestamp
select sum(BYTES_RECEIVED) as "Summe Bytes -
aktuelle Session" -
from sessions -
where CLIENT_NAME=upper('$1')
<snip>
$2=YYYY-MM-DD for example: 2005-01-31
$3=HH:MM:SS.SSSS for example 00:00:00.0000

Cheers,
ku

> Mark K.
>
>
> <FONT SIZE = 
> 1>****************************************************************************
> This e-mail and any attachments may contain confidential and privileged 
> information. If you are not the intended recipient, please notify the sender 
> immediately by return e-mail, delete this e-mail and destroy any copies. Any 
> dissemination or use of this information by a person other than the intended 
> recipient is unauthorized and may be illegal. Unless otherwise stated, 
> opinions expressed in this e-mail are those of the author and are not 
> endorsed by the author's employer.</FONT>

--
Emperor Palpatine:
        Take your Jedi weapon! Use it. Strike me down with all
        of your hatred and your journey towards the dark
        side will be complete!