Document Type | Troubleshooting
Category | Backup/Recovery
Applicable Product Version | 7FS02PS
Document Number | TBATS001
Issue
This explains cases where the tbrmgr --userid command does not execute properly when run on a Remote Server instead of the Target DB Local.
- Running tbrmgr backup --userid on a Remote Server: Backup sets are properly created on the Target DB Local
- Running tbrmgr recover --userid on a Remote Server: Checks the status of the DB on the Remote Server
Cause
For tbrmgr, the proper method is to execute it in the Target DB Local environment. When performing recovery on a Remote Server, the backup set must exist on the Remote Server, which is the same as the process of creating a Clone DB.
Solutions
To recover the target DB, the backup must exist on the target DB server, and the command should be executed locally where the target DB resides, which is the proper method.
Specify the username, password, and SID for the user connecting to the Target DB Local backup target in the following format.
--userid USERID[[/PASSWD][@SID]]
NoteIt is recommended to run tbrmgr on the Local of the Target DB where backup/recovery is to be performed.