syncdb command

The syncdb command synchronizes Oracle catalog databases or the Oracle control file with the IBM® Spectrum Protect server.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-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 IBM Spectrum Protect 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

Unix and Linux: 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.

Windows: 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 IBM Spectrum Protect 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 IBM Spectrum Protect™ database with the RMAN backup history.
-NUMORCINSTances=number

Unix and Linux: 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.

Windows: 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 IBM Spectrum Protect 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

Unix and Linux: Synchronize the IBM Spectrum Protect 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 Spectrum Protect for Databases:
Data Protection for Oracle
Version 8, Release 1, Level 0.0
(C) Copyright IBM Corporation 1997, 2016. All rights reserved.

From Date (01/01/1990): 10/20/2016
To Date (10/28/2016): 10/28/2016

Catalog 1 User Name: rman
Catalog 1 Password: rman
Catalog 1 Connect String: rman
Synchronize the IBM Spectrum Protect database with the RMAN backup history and the Oracle control file using the tdposync syncdb command. The following output is displayed:
Command: TDPOSYNC syncdb -nocatalog -numorcinstances=2

Output:
IBM Spectrum Protect for Databases:
Data Protection for Oracle
Version 8, Release 1, Level 0.0
(C) Copyright IBM Corporation 1997, 2016. All rights reserved.
From Date (01/01/1990): 10/20/2016
To Date (10/28/2016): 10/28/2016

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_B
Windows: When you specify the syncdb -numcatalogs parameter, you are prompted for input for each catalog on the node. This example assumes two separate RMAN catalogs, rman and rman2: 
C:\Tivoli\Tsm\AgentOba>tdposync syncdb -numcatalogs=2 -TDPO_OPTFILE=c:\RMAN\
scripts\tdpo.opt

Output:
IBM Spectrum Protect for Databases:
Data Protection for Oracle
Version 8, Release 1, Level 0
(C) Copyright IBM Corporation 1997, 2014. All rights reserved.

From Date (01/01/1990): 10/20/2016
To Date (10/28/2016): 10/28/2016

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
Note: From Date implicitly searches from time=00:00:01 and To Date implicitly searches to time=23:59:59 of the same day.