The syncdb command synchronizes Oracle catalog databases or the Oracle control file with the Tivoli® Storage Manager server.
Syntax
>>-TDPOSYNC--syncdb---------------------------------------------> >--+-----------------------------------------+------------------> | .-installed tdpo.opt-. | '- -TDPO_OPTFILE=--+--------------------+-' '-pathname-----------' .-1------. .- -NUMCATalogs=--+--------+----------------------. | '-number-' | >--+-------------------------------------------------+--------->< | .-1------. | | .- -NUMORCINSTances=--+--------+-. | | | '-number-' | | '- -NOCATalog--+--------------------------------+-'
Optional parameters
- -TDPO_OPTFILE=pathname
- This parameter specifies the fully qualified path name to the tdpo.opt file.
This file is the options file that is used by the utilities and the Data Protection for Oracle library.
This file contains the information for the Tivoli Storage
Manager server name
and address that tdposync needs for synchronizing. Note: For syncdb TDPO_OPTFILE, you must specify the same options file values that were used to do the original backup operations.
- -NUMCATalogs=number
This parameter specifies the number of Oracle
catalog databases that you want to synchronize. It prompts you for
information for each catalog that exists on your node.
This parameter specifies the number of Oracle catalog
databases that you want to synchronize and prompts you for information
for each catalog.Specify this option only when you use multiple Oracle catalogs to back up multiple target databases to the same Tivoli Storage Manager server under the same file space, node name, and owner name.
According to the number you specify for -numcatalogs, you are prompted for the user name, password, and connect string for each. If you do not specify -numcatalogs, the default is 1, and you are prompted only once.
You are prompted for start and end dates for your query. Then you are prompted for the following information for each catalog:
- Catalog # User Name:
- Catalog # Password:
- Catalog # Connect String:
You are also prompted for the following date information to narrow your search:
- From Date: MM/DD/YYYY
- To Date: MM/DD/YYYY
If no dates are specified, Data Protection for Oracle displays all objects that are not in sync.
- -NOCATalog
- This parameter specifies that the tdposync utility uses the backup history information that is stored in the Oracle control file rather than a catalog database to reconcile the Tivoli Storage Manager database with the RMAN backup history.
- -NUMORCINSTances=number
- This parameter specifies the number of Oracle
instances that you want to synchronize, and prompts you for information
for each instance that exists on your node. This
parameter specifies the number of Oracle instances that you want to
synchronize and prompts you for information for each instance.
Specify this option only when you use multiple Oracle instances to back up multiple target databases to the same Tivoli Storage Manager server under the same file space, node name, and owner name.
According to the number you specify for -numorcinstances, you are prompted for the user name, password, and connect string for each instance. If you do not specify a value for -numorcinstances, the default is 1, and you are prompted only once.
For each Oracle instance, the following information is requested:- Oracle Database # User Name
- Oracle Database # Password
- Oracle Database # Connect String
You are also prompted for the following date information to narrow your search:- From Date: MM/DD/YYYY
- To Date: MM/DD/YYYY
If no dates are specified, Data Protection for Oracle shows all objects that are not in sync.
Example
Synchronize the Tivoli Storage
Manager database
with the RMAN catalog and the RMAN backup history, with the tdposync
syncdb command. The following output is displayed: Command: TDPOSYNC syncdb
Output:
IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 7, Release 1, Level 0.0
(C) Copyright IBM Corporation 1997, 2013. All rights reserved.
From Date (01/01/1990): 01/01/2013
To Date (01/05/2013): 12/12/2013
Catalog 1 User Name: rman
Catalog 1 Password: rman
Catalog 1 Connect String: rmanCommand: TDPOSYNC syncdb -nocatalog -numorcinstances=2
Output:
IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 7, Release 1, Level 0.0
(C) Copyright IBM Corporation 1997, 2013. All rights reserved.
From Date (01/01/1990): 01/01/2013
To Date (01/05/2013): 12/12/2013
Oracle Database 1 User Name: OrcUser1
Oracle database 1 Password: OrcUser1pw
Oracle database 1 Connect String: Oracle_DB_A
Oracle Database 2 User Name: OrcYser2
Oracle database 2 Password: OrcUser2pw
Oracle database 2 Connect String: Oracle_DB_BC:\Tivoli\Tsm\AgentOba>tdposync syncdb -numcatalogs=2 -TDPO_OPTFILE=c:\RMAN\
scripts\tdpo.opt
Output:
IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 7, Release 1, Level 0.0
(C) Copyright IBM Corporation 1997, 2013. All rights reserved.
From Date (01/01/1990): 01/01/2013
To Date (01/05/2013): 12/12/2013
Catalog 1 User Name: rman
Catalog 1 Password: rman
Catalog 1 Connect String: rman
Catalog 2 User Name: rman2
Catalog 2 Password: rman2
Catalog 2 Connect String: rman2