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: [email protected] Please consider the environment before printing this Email -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Sam Sheppard Sent: Tuesday, October 27, 2009 6:05 AM To: [email protected] 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."
