Hi everybody.
Try this select
select NODE_NAME, DATE(BACKUP_DATE)as fecha, FILESPACE_NAME, HL_NAME, LL_NAME,
CLASS_NAME from backups where NODE_NAME='XXXXXXX' and FILESPACE_NAME='XXXX'
order by fecha asc
It will display the filespace backup date.
Kind Regards
JOrge
> Date: Thu, 4 Jun 2009 10:10:16 -0400
> From: deehre01 AT LOUISVILLE DOT EDU
> Subject: Re: [ADSM-L] TSM for Oracle
> To: ADSM-L AT VM.MARIST DOT EDU
>
> I understand that rman CAN automatically delete old backups. As a TSM Admin,
> I am being asked to verify that rman IS deleting old backups. Is there any
> way to verify such from the TSM side?
>
> David
>
> >>> Grigori Solonovitch <G.Solonovitch AT BKME DOT COM> 6/4/2009 1:42 AM >>>
> I am using RMAN 9i/10g with TSM 5.5 successfully.
> RMAN manages data expiry for Oracle databases completely without any manual
> intervention, but some configuration efforts are required:
> 1) dedicated TSM node for Oracle data with management class and copy group;
> 2) set vere=no limit, verd=0 rete=<N> ret=0 in copy group, where <N> is a
> period of time in days to be able to recover database (I am using 31 day);
> 3) for each database set retention period in RMAN by
> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF <N> DAYS, where <N> equal to
> <N> in copy group;
> 4) run full database backup periodically. I am running full database backup
> twice per month with retention period 31 days. All other days run incremental
> backup for database;
> 5) perform " delete noprompt obsolete" from RMAN backup script;
> 6) schedule at proper time "crosscheck backup" + "delete noprompt expired
> backup" + "delete noprompt obsolete" daily for each database (just not to
> delay backups);
> 7) schedule "crosscheck archivelog all" + "delete noprompt expired archivelog
> all" daily for each database (just not to delay backups)
>
> Grigori G. Solonovitch
>
> Senior Technical Architect
>
> Information Technology Bank of Kuwait and Middle East http://www.bkme.com
>
> Phone: (+965) 2231-2274 Mobile: (+965) 99798073 E-Mail: G.Solonovitch AT bkme
> DOT com
>
> Please consider the environment before printing this Email
>
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf
> Of David E Ehresman
> Sent: Wednesday, June 03, 2009 8:59 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: [ADSM-L] TSM for Oracle
>
> Do can a TSM Admin verify that the rman clients are deleting their old TSM
> for Oracle backups?
>
> David
>
> Please consider the environment before printing this Email.
>
> "This email message and any attachments transmitted with it may contain
> confidential and proprietary information, intended only for the named
> recipient(s). If you have received this message in error, or if you are not
> the named recipient(s), please delete this email after notifying the sender
> immediately. BKME cannot guarantee the integrity of this communication and
> accepts no liability for any damage caused by this email or its attachments
> due to viruses, any other defects, interception or unauthorized modification.
> The information, views, opinions and comments of this message are those of
> the individual and not necessarily endorsed by BKME."
_________________________________________________________________
Chatea sin límites en Messenger con la tarifa plana de Orange
http://serviciosmoviles.es.msn.com/messenger/orange.aspx
|
