IBM Support

TDPOSYNC fails to find all objects when not using sysdba privileges

Question & Answer


Question

Is there a way to run the TDPOSYNC SYNCDB command with sysdba permissions.

Cause

The TDPOSYNC SYNCDB command needs to have sysdba privileges in order to access all the backup data.

Answer

When connecting to the Oracle instance via a password file, administrative users can be connected and authenticated to a local or remote database by using the SQL*Plus CONNECT command. In this scenario, the administrative user must connect using their user name and password. Depending on the level of privileges that are assigned and needed, the administrator might also need to specify to CONNECT AS SYSDBA.

If a password file is used for Oracle when running the TDPOSYNC SYNCDB command, the "as sysdba" specification can be included within the connect string. For example:

    Catalog 1 User Name: user1
    Catalog 1 Password: PWD
    Catalog 1 Connect String: db1 as sysdba

This would result in the following connection string to the SQL*Plus interface that is used by the tdposync processing when querying the Oracle backups.
  • user1//PWD@db1 as sysdba

    • SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 31 07:40:03 2014

    Copyright (c) 1982, 2011, Oracle. All rights reserved.

    Connected to:

    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

    With the Partitioning option...

[{"Product":{"code":"SSTFZR","label":"Tivoli Storage Manager for Databases"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Data Protection for Oracle","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Product Synonym

TSM

Document Information

Modified date:
17 June 2018

UID

swg21681938

Page Feedback