Available Data Protection for Oracle options
The options that can be set in the tdpo.opt file for Data Protection for Oracle are described.
- dsmi_log
- Specify the directory that contains
the Data Protection for Oracle error
log file tdpoerror.log.
If the IBM Spectrum Protect™ errorlogname option is specified in the dsm.sys file (for the stanza that is used by Data Protection for Oracle), the errorlogname option overrides the value that is specified by dsmi_log. If the errorlogname option is being used, make sure that it specifies a file in a path that has write permissions for Oracle users.
For error log files, create a directory for the error logs and have the dsmi_log option point to that directory. The user who is running backups must have writable rights to this directory.
- dsmi_orc_config
- Specify the complete path to the IBM® Spectrum Protect client user options file dsm.opt used during the Data Protection for Oracle session. If you do not specify this option, Data Protection for Oracle looks for the options file in the Data Protection for Oracle installation directory. You must specify this option if your IBM Spectrum Protect client user options file is in a directory other than the Data Protection for Oracle installation directory.
- tdpo_enablescriptinput
- You can automate the maintenance of IBM Spectrum
Protect
Data Protection for Oracle without the need for user interaction. You can set the tdpo_enablescriptinput option to allow the tdposync utility to receive input from a script or batch file.You can specify the following options:
- Yes
- The tdposync utility can receive redirected input that allows the utility to run in batch mode.
- No
- The tdposync utility must be run in interactive mode and requires user input to complete its run. This option is the default.Attention: If you run the tdposync command interactively and the tdpo_enablescriptinput is set to Yes, the input for the Oracle password is shown in plain text. To obfuscate the password, set the tdpo_enablescriptinput to No.
- tdpo_fs
- Specify a file space name on the IBM Spectrum Protect
server for Data Protection for Oracle backup,
delete, and restore operations. The file space name can contain a
string of 1-1024 characters.
- The default file space name is adsmorc.
- When you have more than one Oracle database, use this option to back up each Oracle target database to its own file space on the IBM Spectrum Protect server.
- The file space name in the include/exclude statement must match the file space name that is specified in the tdpo_fs option for include/exclude processing to function correctly.
- If this option was set during Data Protection for Oracle backup operations, this option must be set during restore and delete operations.
- tdpo_owner
- This option specifies a session-owner name and object owner name. The value can contain a string of 1 to 64 characters. This value is case-sensitive. For restore and delete operations, this option must specify the same value that was used during the Data Protection for Oracle backup. Do not set this option when passwordaccess generate is specified.
- tdpo_pswdpath
- This option specifies the directory where the TDPO.nodename password file is located. The default value is the directory where Data Protection for Oracle is installed. Note, when passwordaccess generate is specified, Data Protection for Oracle uses the value of the passworddir option that is specified in the dsm.sys file and does not use the tdpo_pswdpath option. However, the directory that is specified by the passworddir option must be a directory that is writeable by the Oracle user. The Oracle user is the user ID of the target Oracle database instance.
- tdpo_node
- Specify the Data Protection for Oracle node
name that is used during operations with the IBM Spectrum Protect
server.
The node name can contain a string of 1-1024 characters. You must
use a node name that is different from the backup-archive client node
name. It is the IBM Spectrum Protect API and not Data Protection for Oracle that negotiates which login credentials to use with the IBM Spectrum Protect server. As a result, certain option settings affect password management. For example, when the tdpo_node option is specified in the tdpo.opt file, and passwordaccess prompt is specified in the dsm.sys file, the IBM Spectrum Protect API uses the value of the tdpo_node option. It then ignores the value of the nodename option that is specified in the dsm.sys file. If you do not specify a value for the passwordaccess option, the default value is prompt. Follow these recommendations:
- When passwordaccess prompt is specified in the dsm.sys file, you can specify the tdpo_node option in the tdpo.opt file.
- When passwordaccess generate is specified in the dsm.sys file, do not specify the tdpo_node option in the tdpo.opt file.
To restore data from one Oracle server to another Oracle server with Data Protection for Oracle, be aware of the following tdpo_node considerations:
- The value of the tdpo_node option in the tdpo.opt file on the target Oracle server, must equal the value of the tdpo_node option in the tdpo.opt file on the source Oracle server.
- If passwordaccess prompt is specified for the backup, then passwordaccess prompt must be specified for the restore. For example, if passwordaccess prompt is specified in the dsm.sys file on the target Oracle server, run the tdpoconf password command to create the password locally on the source Oracle server.
- If passwordaccess generate is specified for the backup, then passwordaccess generate must be specified for the restore. If the password for the Data Protection for Oracle node is unknown because of the passwordaccess generate setting, you can reset the password for the production node on the IBM Spectrum Protect server. After the password is reset, use the new password to run the tdpoconf password command. Reset the password on the production system to set the password for the next backup. Also, reset the password on the alternate system to set the password for the restore operation.
- Data Protection for Oracle and the IBM Spectrum Protect API must be at the same levels on both the source Oracle server and the target Oracle server.
- tdpo_date_fmt
- This option specifies the
format that you want to use to display dates.
You can specify a number, 0 - 5. The default value is 1.
You can specify a number, 1 - 5. The default value is 1.
- 0 Use the locale-specified date format.
- 1 MM/DD/YYYY (Default value)
- 2 DD-MM-YYYY
- 3 YYYY-MM-DD
- 4 DD.MM.YYYY
- 5 YYYY.MM.DD
- tdpo_num_fmt
- This option specifies the format
that you want to use to display numbers. You can specify a number,
1 - 6. The default value is 1.
- 1 1,000.00 (Default value)
- 2 1,000,00
- 3 1 000,00
- 4 1 000.00
- 5 1.000,00
- 6 1'000,00
- tdpo_time_fmt
- This option specifies the
format that you want to use to display time.
You can specify a number, 1 - 4. The default value is 1.
You can specify a number, 0 - 4. The default value is 1.
- 0 Use the locale-specified time format.
- 1 23:00:00 (Default value)
- 2 23,00,00
- 3 23.00.00
- 4 12:00:00 A/P
- tdpo_mgmt_class_2
- This option specifies the second management class that is used for copy 2 in the RMAN duplex copy command.
- tdpo_mgmt_class_3
- This option specifies the third management class that is used for copy 3 in the RMAN duplex copy command.
- tdpo_mgmt_class_4
- This option specifies the fourth management class that is used for copy 4 in the RMAN duplex copy command. Four copies is the maximum that is allowed by RMAN.