This chapter describes a number of settings necessary to perform database maintenance and facilitate backups.
In the event of a database crash, objects may become corrupted. Typically, this reveals itself with ORA-00376 and similar errors reported in the Event Log. It is recommended that you carefully review the information in the 1303180.1 Knowledge Base article. Log into the following site and search for 1303180.1:
https://support.oracle.com
In particular, ensure that the indicated tablespaces are set to force logging. You can use the following command to view the status of the database tables:
cop stats %period
where period
indicates the required year (2012), month (201203), or day (20120326). The command output appears as follows:
STRUCTURE PRESENTATION DATA ROWS DATA SIZE yuY0aQ 29 11 20 153 204 - 343 2.0 MB 0.1 MB wg_visit_mo_201203 hash data dims lvls pres view data desc data desc cube name ------ ---- ---- ---- ---- ---- ------ ------ ------- ------- ---------- fTq7vQ 19 11 22 133 156 0 2 0.1 MB 0.1 MB c_keypage_mo_201203 u7q+3g 9 4 8 13 7 - 470 0.6 MB 0.1 MB c_kpi_mo_201203 PMocAw 22 9 17 159 174 - 16960 19.0 MB 4.0 MB c_page_mo_201203 K/p4ww 12 12 29 123 104 0 0 0.1 MB 0.1 MB c_service_mo_201203 1S2Ggg 10 19 29 79 90 - 247 2.0 MB 0.1 MB c_slowurl_mo_201203 lZRuxg 29 5 10 279 61 0 0 0.1 MB 0.1 MB c_trasta_mo_201203 yuY0aQ 29 11 20 153 204 - 343 2.0 MB 0.1 MB c_visit_mo_201203 hash data dims lvls pres view data desc data desc cube name ------ ---- ---- ---- ---- ---- ------ ------ ------- ------- ----------
Note that if the Data column contains a zero value, or there a large number of zeros or dashes, this would indicate corrupted database tables. In this case, you should use the script described in the 556733.1 Knowledge Base article to restore the database. Log into the following site and search for 556733.1:
https://support.oracle.com
In addition, it is recommended that you issue the following commands to force an update of the RUEI configuration and template tables:
makedatabase @ modr -fn all
When performing maintenance on the database, it is recommended that you manually stop RUEI processing for the time that the database is down to prevent the reporting of error messages to show. Do the following:
Use SSH to logon to the Reporter system as the RUEI_USER
user.
Issue the following command to stop processing:
project -stop
Ensure that the following processes are no longer running before bringing down the database: qjobd
, logr
, and rsynclogdird
. If necessary, use the kill
command to stop them.
After completion of database maintenance, restart processing by issuing the following command:
project -start
As of version 12.1.0.3, the USERS
and UXCONF
tablespaces within new installations are set to force
logging
mode. Previously, the default mode was nologging
. The upgrade procedure does not change your database's current setting. However, be aware that changing the tablespace mode to force
logging
can considerably increase disk I/O.
By default, the database does not support online backups. In order to do so, the database's noarchivelog
mode needs to be changed, and a number of operations changed from nologging
mode to force
logging
mode. Do the following:
Logon to the database system as the oracle
user:
Stop all processing by issuing the following commands:
source /etc/ruei.conf su - $RUEI_USER project -stop killall logmsgd killall qjobd killall rsynclogdird
Ensure that the $RUEI_DB_INST
setting specifies the RUEI database.
Change the database to archivelog
mode by issuing the following commands:
. oraenv sqlplus / as sysdba shutdown immediate startup mount alter database archivelog; alter database open;
Issue the following commands to set the required operations to force
logging
mode:
alter tablespace USERS force logging; alter tablespace UXCONF force logging;
Configure and schedule the online backup.
Restart processing with the following command:
project -start
See the Oracle Backup and Recovery User's Guide for further information. It is available at the following location:
http://www.oracle.com/pls/db112/portal.portal_db?selected=14
By default, RUEI uses up to 8 parallel connections to run the KPI value queries. This is controlled by the `db_kpi_value_threads` setting. Increasing the number can improve KPI calculation performance. However, this setting should never be set to a number higher than the amount of cores available from the database server, and there is no use setting it higher than the number of configured KPIs. It has no functional impact other than potentially making data processing run faster.
Use the following command to obtain the setting's current value:
execsql config_get_value processor db_kpi_value_threads
Use the following command to modify the setting's value:
execsql config_set_value processor db_kpi_value_threads *nthreads*
where *nthreads*
specifies the number of parallel connections to use for KPI value queries
RUEI tables have subpartitions for their primary partitions and these are set to a default value of two during installation.
To read the current value, run the following command:
execsql config_get_value processor num_subpartitions_kpi_id
If you need to change the number of subpartitions, use the following commands:
Note:
Changing the number of subpartitions may require an additional license.KPI tables:
execsql config_set_value processor num_subpartitions_kpi_id 10
User flow tables
execsql config_set_value processor num_subpartitions_user_flow_id 10
All other tables
execsql config_set_value processor num_subpartitions_match_id 10
To apply the new settings, enter the following command:
modr all --repartition
Note that the new value will not take effect until a new primary interval partition has been created. Depending on the type of table, a new interval partition may be created only once a day or even once a month.
When the Enterprise Manager repository is undergoing maintenance, you can configure RUEI to ensure that no KPI status change information is sent to the non-functioning Enterprise Manager instance.
When the Enterprise Manager repository maintenance starts, enter the following command on the RUEI system:
execsql emdb_set_status $host $sid maintenance
When the Enterprise Manager repository maintenance is complete, enter the following command on the RUEI system:
execsql emdb_set_status $host $sid up