You can use BR*Tools for Oracle to update compression rates. BRBACKUP performs the update. If you use devices with hardware compression, we recommend updating compression rates monthly, as this helps BRBACKUP to make the most efficient use of your tape volumes.
Make sure that you have set the necessary BRBACKUP parameters in the initialization profile init<DBSID>.sap, because BRTOOLS uses these when it calls BRBACKUP.
...
1. Start BRGUI or BRTOOLS.
2. Choose Backup and database copy → Additional functions → Update of compression rates.
3. Choose the required options:
Menu Entry |
Equivalent BRBACKUP Command Option |
BRBACKUP profile (profile) |
|
Database user/password (user) |
|
Backup type (type) |
|
Files for compression (mode) |
|
Confirmation mode (confirm) |
|
Query mode (query) |
|
Parallel execution (execute) |
|
Additional output (output) |
|
Message language (language) |
|
BRBACKUP command line (command) |
This shows you the BRBACKUP -k only command that is to be executed using the current settings. |
4. To start processing with the selected options, choose Continue.
5. You check the results in the BRBACKUP logs.
¡ The summary log back<DBSID>.logdisplays the return code.
¡ The detail log b<encoded timestamp>.cmb displays progress.
For more information on how to view the logs, see Showing Logs with BR*Tools.