You can use BR*Tools for Oracle to perform a database block verification.
· Make sure 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 Database check and verification → Verification of database blocks.
3. Set the required options:
Menu Entry |
Equivalent BRBACKUP Command Option |
BRBACKUP profile (profile) |
|
Database user/password (user) |
|
Backup type (type) |
|
Files for verification (mode) |
|
Confirmation mode (confirm) |
|
Query mode (query) |
|
Parallel execution (execute) |
|
Extended output (output) |
|
Message language (language) |
|
BRBACKUP command line (command) |
This shows you the BRBACKUP -w only_dbv command that is to be executed using the current settings. |
4. To start processing with the selected options, choose Continue.
5. Check the results in the BRBACKUP logs.
¡ The summary log backup<DBSID>.log displays the return code.
¡ The detail log b<encoded timestamp>.dbv displays the progress.
For more information on how to view the logs with BR*Tools, see Showing Logs with BR*Tools.