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."
|