We need to check
1. DB backup is performed successfully or not
2. DB Housekeeping Jobs are running successfully or not (DB Check, Update stats, clear old log files, adapt extents)
3. Archive directory is having space
4. Offline to Oraarch are scheduled periodically and running fine.
SCHEDULE DB BACKUP
Init<SID>.sap ---------- Open it
Change the parameter values
Backup_type = disk
These tools are used to manage or monitor the oracle database which are specifically provided by SAP.
BRTOOLS reads the parameters from init<SID>.sap
It resides in Oracle_Home\database (Windows)
In UNIX DBS directory
It controls the runtime behavior of BRTOOLS.
BRTOOLS contains the following Options
It is used to connect to the database and performs various administrative tasks.
BRCONNECT - f check ... it is used to check the database and writes the logs into sapcheck directory.
Check conditions are described in transaction DB17 which in turn stores the details in DBMSGORA
Open Command Prompt > brconnect -f check
> brconnect -u system -p <pwd> -f check
brconnect -f stats
Used to run the database statistics. It identifies the tables whose statistics are outdated and updates them. We need to run the DB optimizer once a week. So that all the tables and Indexes where there are stored will be known to DB Optimizer. It is updated periodically (Weekly). Optimizer is used to collect the statistics for the tables whose statistics are outdated.
Running update statistics improves the performance of the system.
(Eg. Friend comes to India from America after 5 years)