Posts

Collecting AHF (Autonomous Health Framerwork) Compliance Report in Oracle

-
AHF(Autonomous Health Framework) Compliance proactively checks if your system drifts from best practice configuration and how to fix it again with automatic health checks. All issues found are ranked according to their impact, so you can understand what to take action on. AHF provides detailed recommendations on how to correct your configuration along with any supporting links. It also includes earlier utilities such as TFA and ORAchk/EXAchk and comes as a bundle.  In this blog, we are collecting AHF compliance reports on two nodes of RAC setup on Linux 8 VMs. Prerequisites   - Download and Install AHF on both Linux machines as Root. Set RAT_CRS_HOME to grid home.          $export  $RAT_CRS_HOME=$GRID_HOME Navigate to AHF binaries          cd /u01/app/19c/grid/ahf/oracle.ahf/bin Run AHF Compliance          [oracle@rac1 bin]$ ahfctl compliance This ...
Post a Comment
Read more

Block Corruption on Physical Standby

-
Block Corruption on Physical Standby in Oracle 11g Database Possible Errors Codes- ORA-00600: internal error code, arguments ORA-10567: Redo is inconsistent with data block (file #, block# ) ORA-10564: tablespace tablespace_name ORA-01110: data file 55: 'data_file_name.dbf' ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# Possible Cause-  These errors occur when block corruption replicates from the primary database to the Physical Standby database through archived logs. Immediately after getting replicated these archived logs are being read by the ongoing recovery process (control file gets updated). The recovery process gets halt when it starts reading the corrupted block from the archived log.  This scenario is being supported by the following values for the given parameters. DB_BLOCK_CHECKING ( Low| Medium | Full )   DB_BLOCK_CHECKSUM ( Typical | Full ) DB_LOST_WRITE_PROTECT ( Typical | Full ) Possible Solution -  In c...
Post a Comment
Location: California, USA
Read more