Ask a Question

What type of Health Checks to be done on RAC databases?

502 views
in 12C RAC by ACE (20,920 points)

1 Answer

by ACE (20,920 points)

Using ORAChk 2.2.5

Checking Health of pluggable databases using OS authentication.

Health-checks are performed over:

  • CBO Statistics for schema objects accessed by the one SQL statement being analyzed
  • CBO Parameters
  • CBO System Statistics
  • CBO Data Dictionary Statistics
  • CBO Fixed-objects Statistics
Availability Health ID Title
Oracle Server - Enterprise Edition 10125 An odd number of voting disks must exist
Oracle Server - Enterprise Edition 10126 The status of a mounted ASM diskgroup needs to be examined and corrected
Oracle Server - Enterprise Edition 10225 Datafiles intended for use should be online
Oracle Server - Enterprise Edition 10193 Either LOG_ARCHIVE_DEST or LOG_ARCHIVE_DEST_n should be set to shared locations
Oracle Server - Enterprise Edition 10282 Remove ACTIVE_INSTANCE_COUNT from the PFILE/SPFILE
Oracle Server - Enterprise Edition 10341 Set REMOTE_LISTENER and LOCAL_LISTENER initialization parameters
Oracle Server - Enterprise Edition 10011 There is only one control file being used
Oracle Server - Enterprise Edition 10012 There is only one control file being used
Oracle Server - Enterprise Edition 10013 There is an insufficient number of redo logs files being used
Oracle Server - Enterprise Edition 10014 There is an insufficient number of redo logs files being used
Oracle Server - Enterprise Edition 10037 ARCHIVELOG mode needs to be enabled
Oracle Server - Enterprise Edition 10038 Enable automatic archiving by setting LOG_ARCHIVE_START to trUE
Oracle Server - Enterprise Edition 10089 Multiplex redo log files and place members of each group on separate disks
Oracle Server - Enterprise Edition 10015 Force logging mode is not being used
Oracle Server - Enterprise Edition 10016 Force logging mode is not being used
Oracle Server - Enterprise Edition 10017 The recovery area location is not set
Oracle Server - Enterprise Edition 10018 The recovery area location is not set
Oracle Server - Enterprise Edition 10003 Redo log files are too small

 

Categories

Most popular tags

rac asm 11g 12c tuning goldengate single node rac node eviction rman 11g new features streams tablespace dataguard oracle diagnostic files cloud rac training dba training incremental backups temp tablespace multitenant undo grid flashback xml db change tracking 12c new features dba undo management sybase asmb grid computing ora-19809 free space fan scripts taf clusterware cluster sql sql server oracle training oracle dba jobs dba jobs rules lcr grid installation oracle dba ora-19804 archive logs active dataguard replication nosql sort usage v$temp_space_header instance recovery haip memory tuning stream control files corrupt jobs ora-1555 rollback segment temp physical standby dgmgrl deadlock retention sga 9i backups vip delete components 10g standby upgrade architecture pdb instance trail gg pfile oracle database 19c new features for developers oracle database 19c new features for administrators oracle database 19c new features for dba oracle database 19c database new features ora-00214: control file version inconsistent with file ora-00214 control file inconsistent control file version inconsistent with file ora-00214 control file version inconsistent with file sysbackup privilege sql interface improvements rman enhancements oracle 12c new feature oracle 12c new feature rman enhancements ora-19625 error identifying file rename pdb

Related questions

Snow Theme by Q2A Market
Powered by Question2Answer
...