Sam,
For expired correctly in TSM, view:
http://publib.boulder.ibm.com/infocenter/tivihelp/v1r1/index.jsp?topic=/com.ibm.itsmfd.doc_5.4/ab5u000349.htm
Policy requeriments:
verdeleted *0
* retonly *0*
Regards,
Gustavo Olivera
2009/10/27 Grigori Solonovitch <G.Solonovitch AT bkme DOT com>
> Normally you can start this process as root by (this is an example):
>
>
>
> [LPAR08][/]>tdposync syncdb -tdpo_optfile=/home/oracle/admin/tdpo/pbob.opt
>
>
>
> IBM Tivoli Storage Manager for Databases:
>
> Data Protection for Oracle
>
> Version 5, Release 5, Level 2.0
>
> (C) Copyright IBM Corporation 1997, 2009. All rights reserved.
>
>
>
> Catalog 1 User Name: rman
>
>
>
> Catalog 1 Password: XXXXXX
>
>
>
> Catalog 1 Connect String: ptsm.bkme.com
>
>
>
> From Date (01/01/1990): 01/01/2009
>
>
>
> To Date (10/27/2009): 10/27/2009
>
>
>
> Gathering Catalog information...Please wait
>
>
>
> SQL*Plus: Release 10.2.0.3.0 - Production on Tue Oct 27 08:27:10 2009
>
>
>
> Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
>
>
>
> Connected to:
>
> Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
> Production
>
> With the Partitioning and Data Mining Scoring Engine options
>
>
>
> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0
> - 64bit Production
>
> With the Partitioning and Data Mining Scoring Engine options
>
>
>
> The TSM Server is Synchronized with the Oracle Catalog or there
>
> are no matching files in the requested filespace.
>
>
>
> [LPAR08][/]>
>
>
>
> I think it will be enough to answer questions, but I would like to stress
> that tdposync is not working from user oracle - root privileges are
> required.
>
>
>
> Regards,
>
>
>
> 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
> Sam Sheppard
> Sent: Tuesday, October 27, 2009 6:05 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: [ADSM-L] TDPOSYNC question
>
>
>
> We've just gotten most of our Oracle TDP clients upgraded to fairly
>
> recent versions and have been having problems with keeping the RMAN
>
> and TSM inventories straight, ie. things weren't getting expired
>
> correctly in TSM. We have a 30 day retention on TDP backups and have
>
> been manually deleting tapes older than that with DISCARDD=YES but want
>
> to get away from that. Hence, we convinced the DBAs to run the TDPOSYNC
>
> utility which seems to have resolved the problem. However, I received
>
> the following message from the DBA in charge and wondered if anyone
>
> could answer his question (see end of the message):
>
>
>
> > Sam,
>
> > Here is the output from the help command:
>
> > ============================================================
>
> > cobra:/opt/tivoli/tsm/client/oracle/bin64 $:tdposync help
>
> >
>
> > IBM Tivoli Storage Manager for Databases:
>
> > Data Protection for Oracle
>
> > Version 5, Release 4, Level 1.0
>
> > (C) Copyright IBM Corporation 1997, 2007. All rights reserved.
>
> >
>
> > IBM Tivoli Storage Manager for Databases:
>
> > Data Protection for Oracle
>
> > Version 5, Release 4, Level 1.0
>
> > (C) Copyright IBM Corporation 1997, 2007. All rights reserved.
>
> >
>
> > TDPOSYNC SYNCdb
>
> >
>
> -NUMCATalogs=numberY (default: 1 )
>
> >
>
> -TDPO_OPTfile=filenameY (default: $install_dir/tdpo.opt)
>
> >
>
> > TDPOSYNC HELP
>
> > When tdposync sysncdb is run it asks series of questions
>
> > 1. Rman userd id for the repository
>
> > 2. Rman password
>
> > 3. The name of the repository
>
> > 4. The date range you want checked
>
> > I don't see any way to pass that info in a command line or config file.
>
>
>
> TIA for any help with this
>
> Sam Sheppard
>
> San Diego Data Processing Corp.
>
> (858)-581-9668
>
>
>
> 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."
>
|
